Help using Base SAS procedures

removing Dollar sign from Tabulate

Reply
N/A
Posts: 0

removing Dollar sign from Tabulate

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
SAS Super FREQ
Posts: 8,866

Re: removing Dollar sign from Tabulate

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 91 views
  • 0 likes
  • 2 in conversation