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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.