I am trying to display a specific subset of variables from my data set HypAnl.HypPrimAnl. I have a variable called COCd that is a numerical variable. I am trying to just display the observations where COCd = 2, without actually showing the COCd variable. How would I do that using the code I have below?
title1 "Subjects Who Died From Heart Failure";
proc print data = HypAnl.HypPrimAnl;
label;
id SSN;
var WtLb BMI SBP;
label SSN = 'Soc Sec Number'
WtLb= 'Subject Weight'
BMI = 'Body Mass Index'
SBP = 'Systolic Blood Pressure';
Try a where statement. Add this to your PROC PRINT.
where COCd = 2;
Perfect, that works out great! I was just unsure exactly what to use in a PROC PRINT.
You can use a WHERE statement in almost every procedure. You can use a WHERE clause as a data set option on any data set (or at least almost every data set). Examples:
proc print data=sashelp.class(where=(sex='F')); run;
proc sort data=sashelp.class out=class(where=(sex='F')); by age; run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.