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
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 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.