Filtering a table using WHERE

[hipopo]

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 !

[Ksharp]

The function WHERE is unknown

SAS doesn't has function where() .

[Tom]

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)");

[hipopo]

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."

[hipopo · Accepted solution]

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

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

Many thanks 😉