Following displays the type of processing being used. The last data step was just done to see if generation dataset would be created. It was.
data test.sample (genmax=5);
x=4;
y=5;
output;
run;
data _null_;
call sleep(60,1);
run;
Proc SQL;
Update test.sample
Set x=7
Where y=5;
quit;
data _null_;
call sleep(60,1);
run;
proc sql;
insert into test.sample
values(10,34)
values(45,33);
quit
;
data _null_;
call sleep(60,1);
run;
proc sql;
delete from test.sample
where x=45;
quit;
data _null_;
call sleep(60,1);
run;
data test.sample;
set test.sample;
if x=10 then y=4;
run;
After running the above code, the only datasets in the library were
Oct 7 15:32 sample#001.sas7bdat
Oct 7 15:33 sample.sas7bdat
Log indicated records were updated, inserted and deleted.
Thanks for help.
... View more
