topic Re: Date format in SAS Procedures

Date format

deleted_user — Wed, 17 Dec 2008 08:30:50 GMT

Hi,

i have a date value 2007-10-01(yyyy-dd-mm)in the database..
how to read this date value in sas?

i need format statement for above value

kumar

Re: Date format

LinusH — Wed, 17 Dec 2008 08:41:47 GMT

Concepts about SAS date and time:

http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a002200738.htm

About reading date format from external databases (i.e. Oracle, SAS/ACCESS to RDBMS):

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a003113620.htm

/Linus

Re: Date format

Patrick — Wed, 17 Dec 2008 11:25:26 GMT

Hi Kumar
This 'date' thing is a very common cause of confusion.
There is a difference of what you see (what you see is what format is applied on a field) and what field type data are stored in.
If the date in your database is already in a field of type 'date' or similar then you won't have problems - just access it with SAS.
It the date is stored as a character string then you will have to tell SAS how to read it - that would then be a Informat. SAS would then convert the string to a SAS date (that's a number). To look at it this SAS data you then best apply a Format to the variable (else you just will see a number).
HTH
Patrick

Re: Date format

Cynthia_sas — Wed, 17 Dec 2008 14:36:03 GMT

And here are some previous forum postings and a paper that might be useful:
http://support.sas.com/forums/thread.jspa?messageID=12764㇜
http://support.sas.com/forums/thread.jspa?messageID=9981⛽
http://www2.sas.com/proceedings/sugi24/Begtutor/p58-24.pdf

cynthia