The problem is coming out of proc tabulate, not out of proc format; you are using samedaydelivery as a class (category) variable, but are defining it with a VAR statement. Remove the VAR statement and add it to the class statement:

class LaptopModel SameDayDelivery;

-Mary

--- mark.chase91@YAHOO.IN wrote:

From: mark <mark.chase91@YAHOO.IN> To: SAS-L@LISTSERV.UGA.EDU Subject: Proc Format Date: Tue, 9 Mar 2010 21:25:07 -0800

Hello ,

Could anyone please help me in the code error.I use :-

PROC Format; VALUE $SameDayDelivery 1 = 'Yes' 2 = 'No'; RUN;

/*Proportion of daily transactions that qualify for same day delivery*/ proc tabulate data = weekly_sales_revenues f = comma6.; CLASS LaptopModel ; VAR SameDayDelivery ; LABEL SameDayDelivery='Same Day Delivery'; TABLE DateofSale*SameDayDelivery ALL='Total'*LaptopModel all='Total',UnitsSold *( MEAN STD MIN MAX sum='Sold'*f=8. pctsum<SameDayDelivery all>='in %'*f=comma5.1) /box=[label="Daily Transactions"] ; run;

Error -

ERROR: Variable SameDayDelivery in list does not match type prescribed for this list.

kindly suggest I need to find the proprtion of the Yes and No in SameDayDelivery