I'm trying to run proc mixed with a variable (drug) that has three components to it (drugs a, b, and c). How do I change the code to run proc mixed ONLY on drugs a and b?
PROC MIXED DATA=lec2.fevlong ORDER=DATA;
CLASS pid drug timehr;
MODEL y=drug timehr drug*timehr/S CHISQ;
REPEATED timehr /TYPE=UN SUBJECT=pid R RCORR;
RUN;
Without seeing actual values of the variable drug this is just a generic response:
Add a WHERE statement.
PROC MIXED DATA=lec2.fevlong ORDER=DATA;
WHERE data in ('drug a' 'drug b');
CLASS pid drug timehr;
MODEL y=drug timehr drug*timehr/S CHISQ;
REPEATED timehr /TYPE=UN SUBJECT=pid R RCORR;
RUN;
Without seeing actual values of the variable drug this is just a generic response:
Add a WHERE statement.
PROC MIXED DATA=lec2.fevlong ORDER=DATA;
WHERE data in ('drug a' 'drug b');
CLASS pid drug timehr;
MODEL y=drug timehr drug*timehr/S CHISQ;
REPEATED timehr /TYPE=UN SUBJECT=pid R RCORR;
RUN;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.