Hello,
Here is my SAS code:
proc tabulate data = parenting format=comma12.;
class parsel;
table parsel ='Parents' all,
n*f=7.0 pctn*f=9.1 /rts=25;
keylabelpctn = 'Percent'
all = 'Total';
run;
Using Proc Means i get a total sum of 13572799.05. However, Proc Tabulate yields the following number: 1.36E+07 (when expanded, it is 13570000 (see Excel attachment). How can I format 1.36E+07 to get it fully displayed with 2 decimal points like 13572799.05 (or 13,572,799.05)?
Thanks for your technical input,
Artp
N | Percent | |
Parents | 1.36E+07 | 100 |
Total | 1.36E+07 | 100 |
I don't know where you are getting a SUM from since you do not have any VAR type variables in the table.
The format would be assigned to the statistic keyword just as you have shown with N and Pctn.
The display of a value in exponential notation means that you somewhere may have set a space that was too small for the number of digits.
table var*sum * f= F12.2
should work for a requested sum. IF you are using a comma format you need to allow for the extra characters the commas will take up and us Comma14.2 (or larger as needed)
I don't know where you are getting a SUM from since you do not have any VAR type variables in the table.
The format would be assigned to the statistic keyword just as you have shown with N and Pctn.
The display of a value in exponential notation means that you somewhere may have set a space that was too small for the number of digits.
table var*sum * f= F12.2
should work for a requested sum. IF you are using a comma format you need to allow for the extra characters the commas will take up and us Comma14.2 (or larger as needed)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.