Hi folks, what does the error message mean? With a smaller data set, it works fine.
NOTE: FC2._PLS18DAT 17M datasets, <100 class-values
57 ods graphics on;
58 proc pls data=FC2._pls18dat nfac=3
59 plot=(VIP ParmProfiles XLoadingProfiles);
60 class VGP TAET9_NIVEAU WOHNBL;
61 model DB2_WSG_KK = VGP TAET9_NIVEAU WOHNBL;
62 run;
ERROR: UNABLE TO ACCESS MESSAGE 27648.20771
ERROR: Invalid group number
ERROR: UNABLE TO ACCESS MESSAGE 29255.294
ERROR: Invalid group number
… * 100
ERROR: UNABLE TO ACCESS MESSAGE 33789.26305
ERROR: Invalid group number
ERROR: Unable to restore '3864455' from template store!
NOTE: The SAS System stopped processing this step because of errors.
We got a workaround from the SAS TechSupport: In SAS9.4, it is likely that the 17 million observations overtax the observation scatterplot in PLS's correlation loadings plot, which is created by default. With plot(only)= this plot can be switched off.
proc pls data=FC2._pls18dat nfac=3 plot(only)=(VIP ParmProfiles XLoadingProfiles);
class VGP TAET9_NIVEAU WOHNBL;
model DB2_WSG_KK = VGP TAET9_NIVEAU WOHNBL;
run;
Hi folks, what does the error message mean? With a smaller data set, it works fine.
Explain exactly what you mean by this. What smaller data set, what are the sizes of the data set and how many variables in the model when it works fine. What larger data set, what are the sizes of the data set and how many variables in the model when it doesn't work fine. How many class variables in the model when it does work? How many class variables in the model when it doesn't work?
Hi Paige,
Thanks for the quick response. The question originally comes from a colleague of mine and here is his answer:
Class Vars:
The small data set on which it works has 1 million records and on which it does not work 17 million records.
Followup question
Are there more variables when you run the larger data set, or the same number of variables?
It is actually only the number of records that are different. All other parameters are the same:
So I have not seen this error before, but obviously it is related to the number of records in your data set. I would discuss this with SAS tech support.
Okay, Paige .. I'm going to discuss this with Tech Support. Thank you for your help!
The procedure us trying to access an error message but cannot find it. Presumably, there is no error for the smaller data and so the procedure does not need to access the error.
Please give tech support your version of SAS by submitting
%put &SYSVLONG4;
and copy/paste from the SAS log.
We got a workaround from the SAS TechSupport: In SAS9.4, it is likely that the 17 million observations overtax the observation scatterplot in PLS's correlation loadings plot, which is created by default. With plot(only)= this plot can be switched off.
proc pls data=FC2._pls18dat nfac=3 plot(only)=(VIP ParmProfiles XLoadingProfiles);
class VGP TAET9_NIVEAU WOHNBL;
model DB2_WSG_KK = VGP TAET9_NIVEAU WOHNBL;
run;
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.