I get the following error when running this code: (FYI, the code runs fine on 2 other machines that have the same OS and same SAS version as me)
ERROR: The POINT= data set option is not valid for the data set CARDIAC.FINAL9K, the data set
must be accessible by observation number for POINT= processing.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set CARDIAC.FINAL9K.
The code:
options compress=NO reuse=yes;
data cardiac.final9K2;
set cardiac.final9K nobs=last_obs;
by mbr_sys_id;
if prov_mpin_pci=1 and fst_srvc_dt<=&enddt3-30 then do;
wb = fst_srvc_dt + 1;
we = fst_srvc_dt + 30;
do pt = _N_ + 1 to last_obs;
set cardiac.final9K(Keep= mbr_sys_id fst_srvc_dt nat_stemi nat_nstemi nat_cabg nat_pci
rename=(mbr_sys_id=mem fst_srvc_dt=dt nat_stemi=stemi nat_nstemi=nstemi
nat_cabg=ncabg nat_pci=npci))
point=pt;
if mbr_sys_id ne mem or dt > we then leave;
if dt >= wb and dt<=we then fu_30 = sum(fu_30, ncabg, npci);
if dt >= wb and dt<=we and nat_stemi=1 then Stemi_FU_30 = sum(Stemi_FU_30, ncabg, npci);
if dt >= wb and dt<=we and nat_nstemi=1 then nStemi_FU_30 = sum(nStemi_FU_30, ncabg, npci);
end;
output;
end;
if we =. then we=fst_srvc_dt;
if wb=' ' then wb=fst_srvc_dt;
if we=wb then output;
drop wb we mem dt ncabg npci pt nstemi stemi;
run;
One possibility is that cardiac.final9K is compressed on your machine.
Not sure if it will solve your problem, doesn't hurt to try. check your system option compress=, if it is yes, then point= will cause errors. set it back to : compress=NO.
Haikuo
Haikuo,
The OP already did that in their initial option statement. However, right after that line (if this is indeed the problem), creating and using a new copy of the dataset might correct the problem.
Yes, Art. Can't believe how blind I was.
Haikuo
Maybe your dataset can't be accessed consecutively.
creating and using a new copy of the dataset might correct the problem.
data cardiac.final9K2_new;
set cardiac.final9K ;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.