PROC REPORT doing things on its own

[BobHope]

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.

[Kurt_Bremser · Accepted solution]

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.

[BobHope]

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