topic removing Dollar sign from Tabulate in SAS Procedures

removing Dollar sign from Tabulate

deleted_user — Thu, 04 Mar 2010 19:00:00 GMT

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

Re: removing Dollar sign from Tabulate

Cynthia_sas — Thu, 04 Mar 2010 19:35:43 GMT

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