topic Re: Concatenating numeric variable with thousands separator format in ODS and Base Reporting

Concatenating numeric variable with thousands separator format

JoannaL — Wed, 24 May 2017 04:09:39 GMT

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)

Re: Concatenating numeric variable with thousands separator format

Reeza — Wed, 24 May 2017 05:19:56 GMT

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

Re: Concatenating numeric variable with thousands separator format

JoannaL — Wed, 24 May 2017 05:54:54 GMT

Thanks! That solves it beautifully!