Hello Friends,
I am trying to get my mind around this issue, and I need your advice regarding it.
I have a variable "Date" in my sas dataset in the format "01DEC05".
I want to extract the month "DEC", and the year "05" using the DATA step.
So far I tried using the SUBSTR(Right 😃 function; it does work for the char variable but it does not work for the numeric variable.
Here's my code:
data work.stocks;
set sashelp.stocks;
Inital=substr(Stock,1,1);
Month=SUBSTR(Date,3,3);
Year=SUBSTR(Date,6,2);
put @1 Month @5 Year;
run;
This being my first post here, my apologies if the code tags are not inserted properly.
Best Regards
asar_k
Ref:SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition