topic Control the number of decimal places in display in SAS Procedures

Control the number of decimal places in display

Kevin_Graduate — Mon, 20 Jun 2011 23:35:03 GMT

Is there any OPTIONS that can control the number of decimal places respectively for the two ways of outptut: 1) PUT, and 2) PROC PRINT? The variable invest has 6 decimal places currently by default.

[pre]
DATA newdata;
SET olddata;
IF idnum=10013 THEN PUT invest= ;
RUN;

PROC PRINT DATA=olddata;
WHERE idnum=10013;
RUN;

[/pre]

Re: Control the number of decimal places in display

Cynthia_sas — Mon, 20 Jun 2011 23:55:00 GMT

Hi:
The answer to your question will be a SAS format for both usage scenarios. The difference is that PROC PRINT will need a FORMAT statement:
[pre]
format invest comma10.2;
[/pre]

While the PUT statement just needs to be told what format to use:
[pre]
PUT invest= comma10.2;
[/pre]

If you used a format statement inside your DATA step program, then WORK.NEWDATA would have the format permanently associated with the INVEST variable. For example, in the program below, the WEIGHT variable in WORK.NEW has the format COMMA10.6 associated with it. So, that format is used by PROC PRINT.

cynthia
[pre]
data new;
set sashelp.class;
format weight comma10.6;
run;

ods listing;
proc print data=work.new;
run;
[/pre]

Re: Control the number of decimal places in display

Kevin_Graduate — Tue, 21 Jun 2011 08:19:08 GMT

thanks a lot, Cynthia@sas.