topic Re: Data Point Error in SAS Procedures

Data Point Error

tmm — Sat, 28 Jul 2012 10:51:29 GMT

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;

Re: Data Point Error

art297 — Sat, 28 Jul 2012 12:57:48 GMT

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

Re: Data Point Error

Haikuo — Sat, 28 Jul 2012 13:05:35 GMT

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

Re: Data Point Error

art297 — Sat, 28 Jul 2012 13:32:02 GMT

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.

Re: Data Point Error

Haikuo — Sat, 28 Jul 2012 16:18:53 GMT

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

Haikuo

Re: Data Point Error

Ksharp — Mon, 30 Jul 2012 04:28:15 GMT

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;