Solved: Re: SAS dates from Character Strings - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

SAS dates from Character Strings

Posted 03-24-2015 01:14 PM (1011 views)

I have a character string '03-jul-95' that has a format of $255. and an informat of $255. I want to convert this to a SAS date. I know how to substring the individual components but I don't know how to convert 'jul' to month number to use the MDY function. I would appreciate any assistance I can get. Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: SAS dates from Character Strings

Posted 03-24-2015 01:41 PM (1062 views) | In reply to Kim_SOM

Use the INPUT function so that you can use an INFORMAT to convert the value for you.

mydate = input(mystring,date11.);

format mydate date9. ;

View solution in original post

2 REPLIES 2

Super User

Super User

Re: SAS dates from Character Strings

Posted 03-24-2015 01:41 PM (1063 views) | In reply to Kim_SOM

Use the INPUT function so that you can use an INFORMAT to convert the value for you.

mydate = input(mystring,date11.);

format mydate date9. ;

Calcite | Level 5

Calcite | Level 5

Re: SAS dates from Character Strings

Posted 03-24-2015 01:47 PM (905 views) | In reply to Tom

Thank you so much for the quick reply. I do appreciate it