topic Re: Filtering a table using WHERE in SAS Programming

Filtering a table using WHERE

hipopo — Tue, 15 May 2012 14:03:50 GMT

Hi all

Here is the problematic code :

data test;

dsid=open("Work.PB_Y1999_A1_North");

NbDeleted=attrn(dsid,"NOBS");

rc=where(dsid,'Problem=AreaLimits');

DeletedAreaLimits=attrn(dsid,"NLOBSF");

rc=close(dsid);

run;

It says :

ERROR 68-185 The function WHERE is unknown, or cannot be accessed.

Now, the file does exist, has a column called Problem (and it works when I manually filter by entering "where Problem=...." in the top left box).

I use SAS 9.1

Thanks in advance if anyone can help !

Re: Filtering a table using WHERE

Ksharp — Tue, 15 May 2012 14:20:15 GMT

The function WHERE is unknown

SAS doesn't has function where() .

Re: Filtering a table using WHERE

Tom — Tue, 15 May 2012 14:29:33 GMT

Specify the WHERE clause as dataset option when you open the dataset. Also you should use NLOBS instead of NOBS to avoid counting deleted observations.

dsid=open("Work.PB_Y1999_A1_North(where=(Problem=AreaLimits)");

Re: Filtering a table using WHERE

hipopo — Wed, 16 May 2012 11:18:20 GMT

Thanks for your replies.

I think your code misses a bracket, but it still doesn't work :

"Argument 1 to function ATTRN at line ... column ... is invalid."

Re: Filtering a table using WHERE

hipopo — Wed, 16 May 2012 11:22:06 GMT

I actually got the right code !!!! It should be :

dsid=open("Work.PB_Y1999_A1_North(where=(Problem='AreaLimits'))");

Many thanks 😉