topic SAS date to Excel General format in SAS Programming

SAS date to Excel General format

debw16 — Fri, 10 Aug 2018 21:29:01 GMT

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?

Re: SAS date to Excel General format

Reeza — Fri, 10 Aug 2018 23:32:08 GMT

@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.

Re: SAS date to Excel General format

debw16 — Sat, 11 Aug 2018 22:40:03 GMT

Thanks Reeza, I'll check this out soon and see if I can find something that works.

Re: SAS date to Excel General format

debw16 — Tue, 28 Aug 2018 16:28:32 GMT

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.