Using the data in Sample1 how do you identify the participants in DMV? I do not see any information that indicates where anyone is from.
You likely do not need to add any variables at all. You can create analysis groups in data based on a single variable using a custom format.
Something like:
proc format library=work;
value $dmv
'MD', 'VA', 'DC' = 'DMV'
other= 'non DMV'
;
run;
Then use the format for your state variable in procs such as freq, means, ttest etc.
Proc freq data=Sample01_Runners ;
tables state;
format state $dmv.;
run;
If /then /else (or Select when or Case when) will be needed if two or more variables are involved.
... View more
