removing Dollar sign from Tabulate

[deleted_user]

Hello All ,

/*Generate a table for the total number of units sold over each week*/
proc tabulate data=WEEK f=dollar8.;
class week Laptopmodel;
var UnitsSold;
table week*Laptopmodel,
Unitssold;
run;
proc print data = Tabulate;
run;

I'm getting the $ sign in the 'UnitsSold' in output and dont want it.If I dont use the 'dollar' in data step then i dont get correct numbers , kindly suggest the correctness needed.

Regards ,

mark

[Cynthia_sas]

Hi:
If you carefully examine the code in my previous posting, you will see the use of F= in my PROC TABULATE statement.
http://support.sas.com/forums/thread.jspa?threadID=8892&tstart=0

You can change the format of a variable in PROC TABULATE, by using the FORMAT= option either in the PROC TABULATE statement or in the TABLE statement, as described here, in the documentation:
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473736.htm#a003065553

cynthia