BookmarkSubscribeRSS Feed
tmm
Fluorite | Level 6 tmm
Fluorite | Level 6


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;

5 REPLIES 5
art297
Opal | Level 21

One possibility is that cardiac.final9K is compressed on your machine.

Haikuo
Onyx | Level 15

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

art297
Opal | Level 21

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.

Haikuo
Onyx | Level 15

Yes, Art. Can't believe how blind I was.

Haikuo

Ksharp
Super User

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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2733 views
  • 0 likes
  • 4 in conversation