Help using Base SAS procedures

PROC REPORT doing things on its own

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

PROC REPORT doing things on its own

I have attached a data and a code in .txt to show the problem (for some reason I can't copy paste text in here and I am too lazy to write all the <p></p> in html).

So the problem is that for some unknown/annoying reason PROC REPORT won't order the variables correctly (in the example the '01' of var works ok but then the '02' dates are partly messed up, although they are in correct order in the input data). What I am missing here? I am losing my mind.

Attachment

Accepted Solutions
Solution
‎11-11-2014 03:09 AM
Super User
Posts: 7,833

Re: PROC REPORT doing things on its own

Don't ask me why it works, but changing order= to "internal" for date2 corrected it.

UPDATE:

Now I know why.

Look here: http://support.sas.com/resources/papers/proceedings11/090-2011.pdf

It explains why you get this seemingly strange output.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎11-11-2014 03:09 AM
Super User
Posts: 7,833

Re: PROC REPORT doing things on its own

Don't ask me why it works, but changing order= to "internal" for date2 corrected it.

UPDATE:

Now I know why.

Look here: http://support.sas.com/resources/papers/proceedings11/090-2011.pdf

It explains why you get this seemingly strange output.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 60

Re: PROC REPORT doing things on its own

Posted in reply to KurtBremser

Thanks a lot! Very good article about the topic. Thumbs up.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 169 views
  • 0 likes
  • 2 in conversation