I have the following date in my SAS program.
201707
In YYMMN6. format, (numeric data).
I need to export it into Excel in the same configuration 201707, but as a general format, as in ... not a date, just a number.
Any ideas on how to approach this?
I solved this by simply changing the format to 8. using the FORMAT command in a DATA step. Ultimately, though, I used PROC IMPORT to import the Excel file and that made the date easier to work with.
@debw16 wrote:
I have the following date in my SAS program.
201707
In YYMMN6. format, (numeric data).
I need to export it into Excel in the same configuration 201707, but as a general format, as in ... not a date, just a number.
Any ideas on how to approach this?
Use ODS EXCEL with TAGATTR.
Page 7 here:
https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf
Another option is is to create a text variable and that will look correct, but a user would have to convert it.
Thanks Reeza, I'll check this out soon and see if I can find something that works.
I solved this by simply changing the format to 8. using the FORMAT command in a DATA step. Ultimately, though, I used PROC IMPORT to import the Excel file and that made the date easier to work with.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.