| Date: | Wed, 28 Dec 2011 08:18:53 -0800 |
|---|
| Reply-To: | Irin later <irinfigvam@yahoo.com> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Irin later <irinfigvam@YAHOO.COM> |
|---|
| Subject: | Date value out of range. |
|---|
| Content-Type: | text/plain; charset=iso-8859-1 |
|---|
I am trying to convert numeric Birthdate (looks like 17APR1976:00:00:00.000) into character date format
Proc Contents give me the following output:
Variable Type Len Format Informat Label
BirthDate Num 8 DATETIME22.3 DATETIME22.3 BirthDate
SAS log generates an error on the following piece of code:
75 proc sql;
76 create table TEST as
77 select PUT(Birthdate,date9.) as DOB
78 from ob.OBfile;
ERROR: Date value out of range
NOTE: Table WORK.TEST created, with 9818 rows and 1 columns.
79 quit;
Not even sure what the "range " is meant...What I am doing wrong? How can I fix it?
Thank you in advance,
Irin
|
