BookmarkSubscribeRSS Feed
krg1140
Calcite | Level 5
  1. Which observation (reference the GVKEY) has the greatest difference between predicted audit fees and actual audit fees?

 

I can sort the data by ascending or descending order but then it throws the value off of the correct observation #

 

What code can I run to give me an output of the largest absolute value difference from my resiudal from this regression output:

 

/* Part 3 Step 13 */

proc reg data=reg.Complete_Data;
model laf=BIGN CITY_SPEC restatement_issue MATWEAK LAT CATA OCF LOSS SALE SALE_GROWTH;
output out=reg.reg1 p=plaf r=resid;
run;
quit;

1 REPLY 1
sbxkoenk
SAS Super FREQ

Hello,

 

As always there are multiple solutions to this, but why don't you use an ID statement?

The variables listed in the ID statement are displayed beside each observation. These variables can be used to identify each observation.

 

Koen

 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 647 views
  • 0 likes
  • 2 in conversation