Hello,
I am new to SAS and am trying to automate bringing a report from excell into SAS and export to Access for end use and archiving. I have no problems with any of the data besides the dates. They come into access as the SAS date e.g. - August 10, 1960 = 222 - Since these dates do not mean anything to my end user I can not leave them but will need to convert them to something meaningful. I have tried using the format commands but when I push the data to excell using this piece of code I get the SAS Dates. Any ideas or help would be appreciated.
Thanks
Proc Append
force base = test.tblassets_bob
data = work.asst_bob3;
* This step appends the new table to the access database;
Quit;
I am new to SAS and am trying to automate bringing a report from excell into SAS and export to Access for end use and archiving. I have no problems with any of the data besides the dates. They come into access as the SAS date e.g. - August 10, 1960 = 222 - Since these dates do not mean anything to my end user I can not leave them but will need to convert them to something meaningful. I have tried using the format commands but when I push the data to excell using this piece of code I get the SAS Dates. Any ideas or help would be appreciated.
Thanks
Proc Append
force base = test.tblassets_bob
data = work.asst_bob3;
* This step appends the new table to the access database;
Quit;