Re: obs= dsoption does not work with open() function

Chang

You made me curious so I checked the on-line docs (SAS Language Reference:
Dictionary / Functions) and found


Restricti If you specify the FIRSTOBS= and OBS= data set, they are
on: ignored. All other data set options are valid.



so it looks like a published restriction.

Nat

Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977



Chang Chung
<chang_y_chung@HO
TMAIL.COM> To
Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
Discussion" cc
<SAS-L@LISTSERV.U
GA.EDU> Subject
obs= dsoption does not work with
open() function
11/01/2007 05:55
PM


Please respond to
Chang Chung
<chang_y_chung@HO
TMAIL.COM>






hi,

Wondering about if this is a bug. is there any documentation on this? it
will be useful to have a list of dsoptions that works with the open()
function. To quote someone who is very active at other forums, "is my best
bet for help with this might be to contact Tech Support?"

ran on sas 9.1.3. sp4 on win xp.

cheers,
chang

data _null_;
put "NOTE: obs options does not seem to work";
dsid = open("sashelp.class(obs=2)");
link printNames;
rc = close(dsid);

put "NOTE: where seems to work fine";
dsid = open("sashelp.class(where=(name like ""A%""))");
link printNames;
rc = close(dsid);
stop;

printNames:
rc = fetch(dsid);
do while (rc = 0);
name = getvarc(dsid, 1);
put name;
rc = fetch(dsid);
end;
return;
run;
/* on log
NOTE: obs options does not seem to work
Alfred
Alice
Barbara
Carol
Henry
James
Jane
Janet
Jeffrey
John
Joyce
Judy
Louise
Mary
Philip
Robert
Ronald
Thomas
William
NOTE: where seems to work fine
Alfred
Alice
*/



-----------------------------------------
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.