I am a beginner. I am trying to used input to convert text to date, here is my function
input('Jul-17', MONYY5.)
The result is Jul01, same month but the year is wrong.
please help
5 is the length but text is 6 characters. Remove the -
You can remove the dash with the COMPRESS() function if needed.
@linc wrote:
I am a beginner. I am trying to used input to convert text to date, here is my function
input('Jul-17', MONYY5.)
The result is Jul01, same month but the year is wrong.
please help
great thanks, the result is perfect 😄
input(compress('text',"-"),MONYY)
data w;
date=input('Jul-17', MONYY7.);
format date date9.;
run;
data test;
monthtext="January";
month=month(input("01"||substr(monthtext,1,3)||"2000",date9.));
run;
from stackoverflow: https://stackoverflow.com/questions/9300020/sas-format-full-month-name-to-integer
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.