You are transposing BY row where the source data may NOT be ordered according BY variables that are surrogates for uniquely representing a row. If the BY values are disordered, or repeated a simple BY statement will not work.
For the case of row-by-row transposing of uncertain data, I would recommend creating a VIEW that has an additional computed column ROWNUM that will ensure a distinct identification of a row when prefaced to your original BY group. The VIEW can be deleted after the TRANSPOSE.
Example:
data have;
INPUT LocID Number Pct_HpA Pct_Bh Pct_Menin Pct_Rot Pct_Ap yr;
DATALINES;
1 21876 89.4 94.7 94.3 96.6 98.2 20082009
2 2135 94.8 100 99.2 99.3 100 20082009
3 2449 90.5 96.3 95.5 98.1 98.8 20082009
4 4754 89.1 94.6 93.9 97.4 98.2 20082009
5 2529 81.7 87.2 89.3 95.4 95.8 20082009
1 21556 87.1 92.1 93.3 94.1 95.7 20092010
2 2142 89.5 94.7 93.9 94 94.7 20092010
3 2408 93.4 98.6 97.4 99.3 100 20092010
4 4786 91 95.8 94.7 97.2 98.4 20092010
5 2527 85.6 91.6 90.8 97.3 98.3 20092010
;
data have_v / view=have_v;
set have;
rownum + 1;
run;
proc transpose
data=have_v
out=want ( rename=(_name_=Names col1=Pcts)
drop=rownum
)
;
by rownum locid number yr;
var Pct:;
label Names=' ';
run;
proc delete data=have_v(mt=view);
run;
Result
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.
Click image to register for webinar
Classroom Training Available!
Select SAS Training centers are offering in-person courses. View upcoming courses for:
-
904 views
-
5 likes
-
-
