Prev: Pivot table in SAS
Next: Work at Home - Earn 20,000 Weekly Without Investment Its Not A Fake, 100% Earning Guarantee
From: mark on 8 Mar 2010 01:19
Hello ,

Could you please suggest me the syntax for the " WHERE ne " if I need
to remove more than two varaibles.

The code :-

where Review ne 50 ,Review ne 40 AND
Review ne 5;

for example doenot work.The problem is how do i remove three
observations with different ranges.

kind regards,
markc
From: Paige Miller on 8 Mar 2010 09:54
On Mar 8, 1:19 am, mark <mark.chas...(a)yahoo.in> wrote:

> Could you please suggest me the syntax for the " WHERE ne " if I need
> to remove more than two varaibles.
>
> The code :-
>
> where Review ne 50 ,Review ne 40 AND
>            Review ne 5;
>
> for example doenot work.The problem is how do i remove three
> observations with different ranges.


Where does not remove variables. Where removes observations.

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com
From: Sidhu Khanna on 8 Mar 2010 14:56
On Mar 8, 7:54 pm, Paige Miller <paige.mil...(a)kodak.com> wrote:
> On Mar 8, 1:19 am, mark <mark.chas...(a)yahoo.in> wrote:
>
> > Could you please suggest me the syntax for the " WHERE ne " if I need
> > to remove more than two varaibles.
>
> > The code :-
>
> > where Review ne 50 ,Review ne 40 AND
> >            Review ne 5;
> Then could you please suggest me hat if i want to remove say, 5 observations 1,5 , 15 and 50 then what code do i use in :

where Review ne 1,Review ne 5 ,Review ne 15 AND
> Review ne 50 ;

as it gives error :-

895 model Score=GHz Processor Disk Battery;
896 where Review ne 16 , Review ne 5 AND Review ne 50
-
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!,
&, *, **,
+, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT,
NE, NOT,
OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
897 ;
ERROR: Syntax error while parsing WHERE clause.
898 run;




> > for example doenot work.The problem is how do i remove three
> > observations with different ranges.
>
> Where does not remove variables. Where removes observations.
>
> --
> Paige Miller
> paige\dot\miller \at\ kodak\dot\com

 | 
Pages: 1
Prev: Pivot table in SAS
Next: Work at Home - Earn 20,000 Weekly Without Investment Its Not A Fake, 100% Earning Guarantee