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.
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.