BookmarkSubscribeRSS Feed
Obsidian | Level 7

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.




Super User Tom
Super User

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.

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


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3 in conversation