Hi! I am trying to learn PROC REPORT and am having difficulty getting my dates to print in the correct order. Here's my code:
PROC REPORT DATA = CAUTI_2016 NOWINDOWS ;
COLUMN DATE LOCATION, (CAUTI DRAIN_DAYS) ;
DEFINE DATE / GROUP ;
DEFINE LOCATION / ACROSS ;
RUN ;
DATE is currently formatted as MONYY5.
My output looks like this:
DATE CAUTI DRAIN_DAYS
APR16 0 198
AUG16 2 222
FEB16 0 235
JAN16 0 178
How can I get it to print in the correct order?
Thank you!
The first question with date type data is "Is your value actually a SAS date valued variable or character?".
Proc contents or examine data set columns to confirm which.
You may need to set ORDER=Internal ind the define statement (if SAS Date value)
If the value is not a SAS date value then you will be stuck with character sort orders and won't work mostly. So you would want to add a SAS date valued variable and use that with appropriate format and order.
The first question with date type data is "Is your value actually a SAS date valued variable or character?".
Proc contents or examine data set columns to confirm which.
You may need to set ORDER=Internal ind the define statement (if SAS Date value)
If the value is not a SAS date value then you will be stuck with character sort orders and won't work mostly. So you would want to add a SAS date valued variable and use that with appropriate format and order.
ORDER = INTERNAL worked!
Thank you!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: