Export to Access with date formats

[shelby55]

Hi

I am trying to export a SAS dataset to Access.

The code is:
PROC EXPORT DATA= MYLIB.NACRS2003
OUTTABLE= "NACRS2003"
DBMS=ACCESS REPLACE;
DATABASE="D:\Data Files\Data Release\NACRS.mdb";
RUN;

Where do I include the format statement so that the dates are in date9. format? How to list many?

Thanks.

Shelby

 

[ChrisW75]

I don't know for sure, however I would say that it would be best to apply the format to the columns in a previous datastep. Just use the format statement like this:-

  format X Y X date9.;

Should do it.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.