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