topic Re: How to shorten SAS dataset output in SAS Programming

How to shorten SAS dataset output

sasstatstudent — Wed, 02 Feb 2022 23:58:51 GMT

Hello, I'm having trouble figuring out how to reduce my PROC REG procedure dataset table to only contain jackknife residuals greater than 2. Here is my my code (libname removed for privacy) and my dataset table output, saved as a PDF file, since the table was too big to post here (500 observations). Thanks in Advance!

data assignm2p1;
set shr.eclsksub;
run;
proc reg data=assignm2p1;
model c1rgscal= c1r4rscl c1r4mscl / r influence vif;
output out=assignm2p1 rstudent=jackknife h=leverage cookd=influence;
run;
quit;
proc print data=assignm2p1;
where (abs(jackknife)>2);
var jackknife leverage influence ;
run;

Re: How to shorten SAS dataset output

Reeza — Thu, 03 Feb 2022 00:15:10 GMT

@sasstatstudent wrote:

Hello, I'm having trouble figuring out how to reduce my PROC REG procedure dataset table to only contain jackknife residuals greater than 2. Here is my my code (libname removed for privacy) and my dataset table output, saved as a PDF file, since the table was too big to post here (500 observations). Thanks in Advance!
data assignm2p1;
set shr.eclsksub;
run;
proc reg data=assignm2p1;
model c1rgscal= c1r4rscl c1r4mscl / r influence vif;
output out=assignm2p1 rstudent=jackknife h=leverage cookd=influence;
run;
quit;
proc print data=assignm2p1;
where (abs(jackknife)>2);
var jackknife leverage influence ;
run;

1. You gave the output data set the same name as your input data set. You have replaced the data set now, which is a bad idea. Give it a different name.

2. You do filter the data set in the PRINT, so that seems to work correctly.

If you want the output data set filtered you can add that WHERE statement directly to the OUTPUT statement as well.

proc reg data=assignm2p1;
model c1rgscal= c1r4rscl c1r4mscl / r influence vif;
output out=residuals (where=(abs(jackknife)>2) rstudent=jackknife h=leverage cookd=influence;
run;
quit;

proc print data=residuals;
run;

Some good guides on how to control ODS output:

https://blogs.sas.com/content/iml/2015/05/26/suppress-ods.html

https://blogs.sas.com/content/iml/2018/11/19/select-ods-tables-wildcards-regular-expressions-sas.html

https://blogs.sas.com/content/iml/2013/04/08/pointcounterpoint-ods-select.html

Re: How to shorten SAS dataset output

sasstatstudent — Thu, 03 Feb 2022 01:31:41 GMT

Thanks for the tip. I copied and pasted your edit onto my code. Unfortunately it didn't work, as it gave me the Errors shown below (In the meantime, I'll look at the webpages you linked in your reply):

Re: How to shorten SAS dataset output

Reeza — Thu, 03 Feb 2022 02:16:12 GMT

The log told you what was wrong twice, MIssing ')' and Expecting a ) in red.

Add an extra bracket.

Obviously without your data I can't test the code.

@sasstatstudent wrote:

Thanks for the tip. I copied and pasted your edit onto my code. Unfortunately it didn't work, as it gave me the Errors shown below (In the meantime, I'll look at the webpages you linked in your reply):