topic Re: PROC REPORT doing things on its own in SAS Procedures

PROC REPORT doing things on its own

BobHope — Tue, 11 Nov 2014 06:13:03 GMT

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.

Re: PROC REPORT doing things on its own

Kurt_Bremser — Tue, 11 Nov 2014 08:09:00 GMT

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.

Re: PROC REPORT doing things on its own

BobHope — Tue, 11 Nov 2014 09:31:11 GMT

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