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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.