topic Re: Need to convert character to date format MM/DD/YYYY in SAS Procedures

Need to convert character to date format MM/DD/YYYY

xliu1 — Tue, 19 Oct 2021 20:01:33 GMT

I need to convert a character column to the date format

The format I am looking for is 05/04/1995

Here are my sas code:

data degree;
set prod.shrdgmr;
grad_term=input(substr(SHRDGMR_GRAD_DATE, 1,10), mmddyy10.);
keep shrdgmr_pidm SHRDGMR_GRAD_DATE grad_term;
where shrdgmr_pidm=14921;
run;

but the output for created column grad_term is blank

Any idea how I should change the code? Thanks!!

Re: Need to convert character to date format MM/DD/YYYY

ballardw — Tue, 19 Oct 2021 20:07:51 GMT

@xliu1 wrote:

I need to convert a character column to the date format

The format I am looking for is 05/04/1995

Here are my sas code:
data degree;
set prod.shrdgmr;
grad_term=input(substr(SHRDGMR_GRAD_DATE, 1,10), mmddyy10.);
keep shrdgmr_pidm SHRDGMR_GRAD_DATE grad_term;
where shrdgmr_pidm=14921;
run;
but the output for created column grad_term is blank

Any idea how I should change the code? Thanks!!

Why are you attempting to read a date that starts with the year using an Informat that starts with month????

Did you read the log with all the invalid data messages??

Try

grad_term=input(SHRDGMR_GRAD_DATE,yymmdd10.);
format gradterm mmddyy10.;

The Informat length of 10 says to only read the first 10 characters so the substr isn't needed. The correct Informat is.

Re: Need to convert character to date format MM/DD/YYYY

xliu1 — Tue, 19 Oct 2021 20:22:31 GMT

Thanks for your response. This works out.