topic Re: SAS dates in SAS Procedures

SAS dates

GreggB — Mon, 13 Jun 2011 23:33:53 GMT

i'm reading an external csv file that has dates such 6/1/2011 and 12/30/2011. I want to convert them to numeric format. not sure what function or informat to use

Re: SAS dates

milts — Tue, 14 Jun 2011 00:18:30 GMT

Hi Gregg,

try using mmddyy10. on your input statement;

input date : mmddyy10.

Hope this helps.

Regards,
Milton

Re: SAS dates

Doc_Duke — Tue, 14 Jun 2011 02:57:04 GMT

ANYDTDTE. is also very flexible for reading dates that may be in different styles.

Re: SAS dates

Rockers — Tue, 14 Jun 2011 04:29:54 GMT

data temp;
input a $ 1-10;
datalines;
12/02/2001
;
run;

data temp2;
set temp;
c=input(a,mmddyy10.);
format c date9.;
run;