convert text to date

[linc]

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

[Reeza]

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

---

[linc]

great thanks, the result is perfect 😄

input(compress('text',"-"),MONYY)

[novinosrin]

data w;
date=input('Jul-17', MONYY7.);
format date date9.;
run;

[pau13rown]

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