@eer_seer wrote:
Thank you.
One question: I see the ":" after the test_score in the "VAR" statement and I assume that acts as a function to call up all of the vars that start with "test_score". I named each test score simply with a number, but, if I need to transpose a differently named test for each ID, do I simply call each one out, like so?:
proc transpose data=scores out=test; by id; var ACT_COMP_SCORE ACT_READ_SCORE ACT_ENG_SCORE ACT_MATH_SCORE SATI_COMP_SCORE SATI_MATH_SCORE SATI_VERB_SCORE SATR_MATH_SCORE SATR_VERB_SCORE SCA; run;
The list might also be made as
Var Act: SAT: SCA ;
but the order would tend to be alphabetic by variable name and use all variables whose names start with the specific characters. So if you had other variables like ACTBB they would be included. But you could use ACT_: which would skip any variables that didn't have the _.
Or if the variables are contiguous, adjacent column order numbers, you could use:
VAR ACT_COMP_SCORE -- SCA;
Note that is 2 dash characters.
Plus you can mix the lists with both the : for some variables and a -- for others. Plus if you have variable names that have a common name with a numerical suffix you can use Var1 - Var10 as a list which would exclude Var11, Var12, Var13 (if such variables exist).
... View more
