From: "White, Svend A." on
=20

I'm a SAS newbie with a report that needs to create a dataset depending
on the options selected by the user. There are 4 scenarios (i.e., user
choice combinations), but only one of them is working. The other three
throw an error like this:

=20

"ERROR: Write access to member DEVDATA3.SURG_07.DATA is denied.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=3D0 and will continue to check statements. This
may cause NOTE: No observations in data set.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds"

=20

I've tested the code separately and all 4 of the following code snippets
work fine from the command line:

#1 (works) proc sort data=3Dsurg.surg_06; by UID; run;
data uid06;
set surg.surg_06; by UID;
if first.UID; run;

=20

#2 proc sort data=3Dsurg.surg_07; by UID; run;
data uid07;
set surg.surg_07; by UID;
if first.UID; run;



#3proc sort data=3Dsurg.surg_06; by pk_event; run;
data pk06;
set surg.surg_06; by pk_event;
if first.pk_event; run;



#4 proc sort data=3Dsurg.surg_07; by pk_event; run;
data pk07;
set surg.surg_07; by pk_event;
if first.pk_event; run;


If one works, shouldn't they all?

=20

Thanks.

=20

Svend

=20