This is my current code which prints the tables I need and the output I need. However, I have 2 issues:
First, my labels just aren't showing up in anything. I cannot put them in the print step as my prompt calls for having the labels in the data step. I've tried moving them around and they just aren't sticking.
Second, I need to make it so rather than using a where statement (which I know is very inefficient I just wanted a placeholder to get my table) in my MIschools print and a where statement in my blowouts print, I need to do those in my data step. I cannot get my data step to give me proper output when I try doing these processes in the data step.
Here is my current code:
data rosebowl
(keep= year winteam winpts loseteam losepts mov)
MIschools
(keep= year winteam winpts loseteam losepts mov)
blowouts
(keep=year winteam mov);
set rose_raw;
Year = year(date);
MOV = WinPts-LosePts;
label WinPts='Winning Score'
LosePts='Losing Score'
WinTeam='Winning Team'
LoseTeam='Losing Team'
MOV='Margin of Victory';
run;
proc print data=rosebowl;
run;
proc print data=MIschools;
where winteam="Michigan" or loseteam="Michigan"
or winteam="Michigan State" or loseteam="Michigan State";
run;
proc print data=blowouts;
where MOV >= 21;
run;
You have to tell Proc print to use the label on the Proc statement
proc print data=MIschools label;
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.
Ready to level-up your skills? Choose your own adventure.