Compute option in proc report in sas yyyy mm dd


Compute option in proc report in sas yyyy mm dd


A listing of national language formats is provided inFormats Documented in Other SAS Publications.Storing user-defined formats is an important consideration if you associatethese formats with variables in permanent SAS data sets, especially thosedata sets shared with other users. I am able to export the data successfully, however, when I export the dataset to Excel and apply a filter on it, the Date Values appears as shown in Screenshot 1.

However, I want to date values to shown as per the screenshot 2 when I apply a filter on it.The Format shown in screenshot 1 does not allow to perform certain calculation though I have applied sas date9. format while exporting.When the format is a proper date format, as shown in screenshot 2, I can do the those calculation.To bring the date values into proper excel date format, I have to double click on the each cell having date each time.

Post that the date values are automatically changed to excel Date format. I have found the information in this SUGI paper very useful.




Compute option in proc report in sas yyyy mm dd

Compute option in proc report in sas yyyy mm dd

Compute option in proc report in sas yyyy mm dd



Add a comment

Your e-mail will not be published. Required fields are marked *

« Previous records « Next records