PROC Report Problem with column name

[Kurt_Bremser]

NO!!!

You keep ALL datasets in the long layout, append that, and do any transposing (either with TRANSPOSE or REPORT) as a FINAL(!!!) step.

[Gieorgie]

Kurt sorry but I'm still confuse. My point is how to set proc append or proc transpose so that the wlong setting does not add data as consecutive rows or columns. There is a historical file that starts with Run_Date from 1, then if I run tomorrow with number 2. That number 2 should be the next column, not the next rows.

[Kurt_Bremser]

I will say this a last time, in the hope that it finally sinks in:

ONE DOES NOT WORK WITH WIDE DATASETS!!!

Wide datasets are needed for regression (where you need a lot of predictors side-by-side with the outcome) or for presentation purposes. They are useless for work like joining, subsetting, grouping or appending (what you experience right now).

So you keep all your data in a long layout, can then simply append (as the structure is constant) and let SAS procedures do the work of transposing for you when needed for reporting.

[Gieorgie]

Ok now i get it, sorry i hope i didn't ruin your weekend 🙂