Hi,
I have a few numeric variables that I would like to concatenate and have the numeric variables with thousands separator format. How can I do this? An example of numeric variables (Mean & SD) and the format I want to report Mean (SD) is as below.
Mean | SD | Mean (SD) |
1110053 | 25000 | 1,110,053 (25,000) |
35505 | 5350 | 35,505 (5,350) |
Use the CATT functions to combine the values. Use PUT to convert to desired format.
X = CATT(put(mean, comma16.), ' (', put(sd, comma16.2), ')' );
PS search lexjansen.com for macro clinical reports or macro table 1
Youll find tons of examples. One good one is Creating complex reports by Cynthia Zender @Cynthia_sas
Use the CATT functions to combine the values. Use PUT to convert to desired format.
X = CATT(put(mean, comma16.), ' (', put(sd, comma16.2), ')' );
PS search lexjansen.com for macro clinical reports or macro table 1
Youll find tons of examples. One good one is Creating complex reports by Cynthia Zender @Cynthia_sas
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.