Hello,
I have a dataset with a variable that is suppose to only be numeric from 1 through 4, but has some extra variables like A B C and D. I am trying to change those alphabetical variables to the following:
A = 1; B = 2; C = 3; D = 4;
What exactly is the sas code for this? Here's a sample dataset Thank you.
data CDC.SAMPLEEDUCATION;
infile datalines dsd truncover;
input Education_Level:$1.;
datalines4;
1
2
3
4
1
2
3
4
1
4
A
B
C
D
;;;;
A custom informat would do what you want directly in the data step:
proc format;
invalue fixMe
'A' = 1
'B' = 2
'C' = 3
'D' = 4
OTHER = [best.];
run;
data SAMPLEEDUCATION;
infile datalines dsd truncover;
input Education_Level :fixMe.;
datalines4;
1
2
3
4
1
2
3
4
1
4
A
B
C
D
;;;;
If A=1,B=2 -- Z=26 and you character code is ascii
data SAMPLEEDUCATION;
input Education_Level $1.;
if anyalpha(education_level) then num=rank(Education_Level) -64;
else num=input(Education_Level,1.);
cards4;
1
2
3
4
1
2
3
4
1
4
A
B
C
D
;;;;
run;quit;
Up to 40 obs WORK.SAMPLEEDUCATION total obs=14
EDUCATION_
Obs LEVEL NUM
1 1 1
2 2 2
3 3 3
4 4 4
5 1 1
6 2 2
7 3 3
8 4 4
9 1 1
10 4 4
11 A 1
12 B 2
13 C 3
14 D 4
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.