topic Convert a numeric value to comma in SAS Programming

Convert a numeric value to comma

Jcorti — Fri, 24 Feb 2017 15:37:15 GMT

Hi Team,

How I can convert a numeric value using put and input to comma.

var=100000;

new_var=100,000;

Thanks and regards,

Reeza — Fri, 24 Feb 2017 15:40:22 GMT

PUT will create a character variable. I suspect you want a numeric format

format variable comma.;

Jcorti — Fri, 24 Feb 2017 16:19:02 GMT

No , Actually I want to convert it to char value because I am concatenating with another variable..

I tried and variable needs to be in char format to concatenate with another variable.

So I need to convert it from:

var=100000 to new_var=100,000 -->> new_var in char format

Kurt_Bremser — Fri, 24 Feb 2017 16:27:22 GMT

Is that a comma for the 1000/1 million etc separation? Then use the comma format:

new_var = put(var,comma8.);

If more digits are needed, increase the width value accordingly.

Reeza — Fri, 24 Feb 2017 17:35:53 GMT

When concatenating I recommend using CATT/CATX etc family of functions. They don't require a character variable.

Jcorti — Fri, 24 Feb 2017 17:38:47 GMT

Thanks Kurt,

It worked 🙂

Jcorti — Fri, 24 Feb 2017 17:41:01 GMT

r1=put(input("Range Start"n,15.),comma12.);
r2=put("Range End"n,comma15.);
Range=CATX('_',r1,r2);

Yes I used that function and It worked, thanks for the comment