Prev: Proc Insightr Running Error
Next: Pivot table in SAS
From: mark on 7 Mar 2010 23:32
Hello All,

I want to remove an observation from the data.Suppose that I'm
predicting Y from A,B and C and that I initially removed say D from
the analysis.Now , if I want to not have the observation, say 50 in my
analysis then in the WHERE condition what variable I must use.

The code I used is :-

proc reg data="c:\sasreg\crime";
model Y=A B C;
where D ne "50";
run;
quit;

My question is that since D is not in my model then will that delete
observation 50 from the model I'm interested in.

Kind Regards,
markc
From: "Swank, Paul R" on 9 Mar 2010 12:35
No, it will remove all observations where D is equal to 50.

Dr. Paul R. Swank,
Professor and Director of Research
Children's Learning Institute
University of Texas Health Science Center-Houston


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of mark
Sent: Sunday, March 07, 2010 10:33 PM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: using WHERE syntax in the Regression to delete an observation

Hello All,

I want to remove an observation from the data.Suppose that I'm
predicting Y from A,B and C and that I initially removed say D from
the analysis.Now , if I want to not have the observation, say 50 in my
analysis then in the WHERE condition what variable I must use.

The code I used is :-

proc reg data="c:\sasreg\crime";
model Y=A B C;
where D ne "50";
run;
quit;

My question is that since D is not in my model then will that delete
observation 50 from the model I'm interested in.

Kind Regards,
markc
 | 
Pages: 1
Prev: Proc Insightr Running Error
Next: Pivot table in SAS