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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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