topic Re: convert text to date in SAS Programming

convert text to date

linc — Thu, 21 Jun 2018 00:00:52 GMT

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

Re: convert text to date

Reeza — Thu, 21 Jun 2018 00:04:18 GMT

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

Re: convert text to date

novinosrin — Thu, 21 Jun 2018 00:05:50 GMT

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

Re: convert text to date

pau13rown — Thu, 21 Jun 2018 00:55:49 GMT

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

Re: convert text to date

linc — Thu, 21 Jun 2018 00:59:36 GMT

great thanks, the result is perfect 😄

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