topic Re: Subset data in SAS Programming

Subset data

aabbccwyt — Thu, 26 Sep 2019 22:42:29 GMT

Hi, please help me with the code for the following problem.

Create a temporary SAS table (I named it sportoutput), read in the worksheet (Sport_List)from the library. Subset the data for a given sport of your choice and use a macro variable to specify the sport. Also, subset data where Sport is Football, Soccer, Basketball or Table Tennis.

Here is what I have so far:

data sportoutput;
set Sport_List;
run;

%Let Sport=Basketball;
proc print data=Sport_List;
where Sport="Basketball";
run;

Thank you so much!

Re: Subset data

ChrisNZ — Thu, 26 Sep 2019 22:52:50 GMT

The way you point to the excel worksheet is wrong. You must define a library. Read your course notes again.

Re: Subset data

sustagens — Fri, 27 Sep 2019 03:13:02 GMT

/*This subsets data where Sport is Football, Soccer, Basketball or Table Tennis*/
data Sport_List_Football Sport_List_Soccer Sport_List_Basketball Sport_List_Table_Tennis;
set Sport_List;
if Sport="Football" then output Sport_List_Football;
if Sport="Soccer" then output Sport_List_Soccer;
if Sport="Basketball" then output Sport_List_Basketball;
if Sport="Table Tennis" then output Sport_List_Table_Tennis;
run;

Re: Subset data

Reeza — Fri, 27 Sep 2019 04:09:46 GMT

PRINT only displays your data, subset your data means create a new dataset with certain, specific, records from the main data set.

Your use of macro variables is incorrect.

Here's a tutorial on filtering data:

https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&page=1&q=filter

And here's a tutorial on macros/macro variables:

UCLA introductory tutorial on macro variables and macros

https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

Tutorial on converting a working program to a macro

This method is pretty robust and helps prevent errors and makes it much easier to debug your code. Obviously biased, because I wrote it 🙂 https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Examples of common macro usage

https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716