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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: