Date:         Thu, 29 Oct 2009 02:52:21 -0700
Reply-To:     shiva <shiva.saidala@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         shiva <shiva.saidala@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How to input date informat exaclty with comman delimiter?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Try this..Hope this helps..

Data agility;
infile datalines DSD dlm=',';
length name $ 10.;
input name $ date1 date2 s1 s2;
informat date1 date2 mmddyy10.;
format date1 date2 mmddyy10.;
Datalines;
Jack,03/17/2009,03/20/2009,76,66
Jeffrey,03/16/2009,,82,
Marilou,03/17/2009,03/22/2009,58,79
Brittania,03/18/2009,03/21/2009,65,63
Jacqueline,03/19/2009,03/21/2009,77,73
;
Run;

Thanks,
shiva