Concatenating numeric variable with thousands separator format

[JoannaL]

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)

[Reeza · Accepted solution]

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

[JoannaL]

Thanks! That solves it beautifully!