Data step output

mysasusername — Tue, 10 Nov 2020 17:45:47 GMT

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;

Re: Data step output

Reeza — Tue, 10 Nov 2020 17:52:58 GMT

You need to add the LABELS option to your PROC PRINT statement to have the labels show. I'll also usually add NOOBS to suppress the row numbers.

proc print data=blowouts labels noobs;

I don't understand your second question, it would help if you showed your data as well as your code - fake data is perfectly fine.
Ideally you show what you have and what you want as the output.

Re: Data step output

ballardw — Tue, 10 Nov 2020 17:53:22 GMT

You have to tell Proc print to use the label on the Proc statement

proc print data=MIschools label;

topic Re: Data step output in SAS Programming

Data step output

Re: Data step output

Re: Data step output