Help using Base SAS procedures

Data Point Error

Reply
Regular Contributor
Regular Contributor
Posts: 238

Data Point Error


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;

PROC Star
Posts: 7,364

Re: Data Point Error

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

Respected Advisor
Posts: 3,124

Re: Data Point Error

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

PROC Star
Posts: 7,364

Re: Data Point Error

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.

Respected Advisor
Posts: 3,124

Re: Data Point Error

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

Haikuo

Super User
Posts: 9,687

Re: Data Point Error

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;

Ask a Question
Discussion stats
  • 5 replies
  • 435 views
  • 0 likes
  • 4 in conversation