date conversion

myboys2 — Tue, 01 Mar 2016 00:59:34 GMT

I have dates comming in as char 02-mar-49, how do i read this date in and output it to yymmddn8.

Thank you

Re: date conversion

Tom — Tue, 01 Mar 2016 01:04:17 GMT

Use DATE9. as the INFORMAT and YYMMDDN8. as the format.

So if you are reading from a text file:

data want ;
   infile 'myfile' ;
   input mydate date9.;
   format mydate yymmddn8.;
run;

If you already have the value in a character variable then you can use INPUT function to convert it to an actual date.

mydate=input(mystr,date9.);

If you want to write it back to another character variable then use the PUT function.

mystr2 = put(mydate,yymmddn8.);

myboys2 — Tue, 01 Mar 2016 01:16:10 GMT

Thank you:)