Date:         Fri, 27 Apr 2001 16:40:26 -0400
Reply-To:     Edward Heaton <HEATONE@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Edward Heaton <HEATONE@WESTAT.COM>
Subject:      Re: Q on dates
Comments: To: RAHUL CHAHAL <rahulchahal@YAHOO.COM>
Content-Type: text/plain; charset="iso-8859-1"

Rahul;
   It appears that your variable BMRDOPEN is of the form mmddyy, so use
MMDDYY8. to read it.  E.g.:

   notedt = input( bmrdopen , mmddyy8. ) ;

Ed

Edward Heaton, SAS Senior Statistical Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1550 Research Boulevard, Room 2018, Rockville, MD 20850-3195
Voice:  (301) 610-4818                      Fax:  (301) 294-3992
mailto:EdwardHeaton@westat.com              http://www.westat.com


-----Original Message-----
From: RAHUL CHAHAL [mailto:rahulchahal@YAHOO.COM]
Sent: Friday, April 27, 2001 4:24 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Q on dates


I have "notedt" in one dataset defined as mmddyy10.
and I need to append the 2nd dataset in which
"bmrdopen" is defined as $8 and create a variable
"notedt".

I am using the following statement to convert
character values to date value - the 2nd dataset does
not have notedt and I am doing the following:

format notedt mmddyy10.;
notedt=input(bmrdopen,$8);

the output is :

OBS    BMRDOPEN        NOTEDT
  1     061396     02/05/2128
  2     061396     02/05/2128
  3     061396     02/05/2128
  4     061396     02/05/2128
  5     061496     05/15/2128
  6     061496     05/15/2128
  7     061796     03/11/2129
  8     061796     03/11/2129
  9     061896     06/19/2129
 10     061896     06/19/2129

How do I correct this problem?

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/