topic Re: tagratt = date issue in SAS Programming

tagratt = date issue

Elliott — Tue, 17 Aug 2021 12:50:15 GMT

I am working on SAS on Linux using SAS EG or Batch, I am generating a report with ODS outputting to an excel sheet and the date in the data set is date9. but when I output using ods with or without a style tag when I filter in excel it only see it as text.

This is the line I am using / style(column) = [tagattr='format:mm/dd/yyyy']

In the filter dropdown it just shows each date, not like year then you can expand to month and day.

I have searched and tried all suggestions but still am not getting the filter to be for date.

Any assistance will be greatly appreciated.

Thanks,

Elliott

Re: tagratt = date issue

Tom — Tue, 17 Aug 2021 13:05:22 GMT

Please provide a program that reproduces the issue. Either provide data in the form of a data step or use one of the SASHELP datasets.

Re: tagratt = date issue

Reeza — Tue, 17 Aug 2021 15:51:53 GMT

Make sure to apply a SAS format to it as well, ie format=mmddyyd10.;