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 !
I actually got the right code !!!! It should be :
dsid=open("Work.PB_Y1999_A1_North(where=(Problem='AreaLimits'))");
Many thanks 😉
The function WHERE is unknown
SAS doesn't has function where() .
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)");
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."
I actually got the right code !!!! It should be :
dsid=open("Work.PB_Y1999_A1_North(where=(Problem='AreaLimits'))");
Many thanks 😉
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.