Hello,
In a table I have character variables of the type:
389,546,254
28,254,258
1,252,546,533
How to make this variable character, numerically, which format to use?
Thanks for your help
Do like this
data have;
input CharVar $20.;
datalines;
389,546,254
28,254,258
1,252,546,533
;
data want;
set have;
NumVar=input(CharVar, Comma20.2);
format CharVar comma20.2;
run;
proc print data=want;run;
Do like this
data have;
input CharVar $20.;
datalines;
389,546,254
28,254,258
1,252,546,533
;
data want;
set have;
NumVar=input(CharVar, Comma20.2);
format CharVar comma20.2;
run;
proc print data=want;run;
Did you really want to convert '389,546,254' into 3,895,462.54?
If not then do NOT include a decimal specification on the INFORMAT. That is telling SAS where to place the decimal point when the input stream does not have one.
This works:
numvar = input(charvar, comma15.);
You can't change the existing variable from character to numeric. You have to assign the numeric value to a new variable.
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.