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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.