Hi there,
I'm new to SAS and am using SAS Enterprise Miner 14.1.
My problem is pretty simple (but so am I).
I have a variable "month" that can take the values Jan, Feb, Mar ... Dec but I want to create a new numeric variable from that, let's call it nmonth, that is = 1 if month=Jan, =2 if month = Feb etc.
The Help suggests Expression Builder seems to be the way to go but how do I get to this (if indeed this is the best way to go)?
Regards
Confused
Hi, here's a data step attempt (still an Enterprise Guide holdout). The variable NEW is NUMERIC ...
data x;
input old :$3. @@;
datalines;
JAN MAR OCT DEC
;
data x;
set x;
new = input(put(input(catt(old,'1960'),monyy.),month.),2.);
run;
DATA SET x
Obs old new
1 JAN 1
2 MAR 3
3 OCT 10
4 DEC 12
Hi, here's a data step attempt (still an Enterprise Guide holdout). The variable NEW is NUMERIC ...
data x;
input old :$3. @@;
datalines;
JAN MAR OCT DEC
;
data x;
set x;
new = input(put(input(catt(old,'1960'),monyy.),month.),2.);
run;
DATA SET x
Obs old new
1 JAN 1
2 MAR 3
3 OCT 10
4 DEC 12
Thanks MikeZdeb
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.