Hello,
I am learning modified poisson regression and stopped in the middle due to the error: work.data does not exist. My code is:
proc genmod data=out1 DESCENDING;
class b6_3c a24_6c;
model had_2c = a1 b6_3c a24_6c/dist=poisson link=log;
repeated subject=b6_3c/type=unstr;
ods output GEEEmpPEst=est;
run;
data estimate;
set est;
if Parm ='b6_3c';
run;
ERROR: File WORK.EST.DATA does not exist.
I could not tell what happened and really need your help.
Thank you very much
George
Please post the complete log of both steps into a window opened with this button:
175 proc genmod data=out1 DESCENDING; 176 class b6_3c a24_6c; 177 model had_2c = a1 b6_3c a24_6c/dist=poisson link=log; 178 repeated subject=b6_3c/type=unstr; 179 ods output GEEEmpPEst=est; 180 run; NOTE: The DESCENDING option applies only to the multinomial distribution with ordinal response. NOTE: Algorithm converged. ERROR: The SAS System stopped processing this step because of insufficient memory. NOTE: PROCEDURE GENMOD used (Total process time): real time 1.78 seconds cpu time 1.72 seconds 181 data estimate; 182 set est; ERROR: File WORK.EST.DATA does not exist. 183 if Parm ='b6_3c'; 184 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.ESTIMATE may be incomplete. When this step was stopped there were 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
Thank you very much Kurt for your response.
I saw message about issufficient memory. I used Mackbook pro 2015 so not sure it is the reason or not.
I am learning to generate prevalence ratio instead of odds ratio.
Best
George
Add this statement - options fullstimer; - at the top of your program and rerun it. It will then report on memory usage. Please post this log.
Please see the new log with your option.
185 options fullstimer; 186 proc genmod data=out1 DESCENDING; 187 class b6_3c a24_6c; 188 model had_2c = a1 b6_3c a24_6c/dist=poisson link=log; 189 repeated subject=b6_3c/type=unstr; 190 ods output GEEEmpPEst=est; 191 run; NOTE: The DESCENDING option applies only to the multinomial distribution with ordinal response. NOTE: Algorithm converged. ERROR: The SAS System stopped processing this step because of insufficient memory. NOTE: PROCEDURE GENMOD used (Total process time): real time 1.48 seconds user cpu time 0.54 seconds system cpu time 0.92 seconds memory 1964129.46k OS Memory 1992092.00k Timestamp 2022-01-19 11:50:11 AM Step Count 8 Switch Count 3
thank you
As you can see SAS is using all available memory of around 2GB. Are you using 32 or 64-bit SAS on your PC? Only 64-bit SAS can go beyond around 2GB. How much memory does your PC have? Also please post the log from this:
proc options option = memory;
run;
I used SAS 64 bit for window, X64_10PRO platform. I run option =memsize as it did not accept option=memory.
239 proc options option = memsize; 240 run; SAS (r) Proprietary Software Release 9.4 TS1M4 MEMSIZE=2147483648 Specifies the limit on the amount of virtual memory that can be used during a SAS session. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 20.84k OS Memory 29428.00k Timestamp 2022-01-19 12:23:07 PM Step Count 17 Switch Count 0
Sorry, should have been this:
proc options group = memory;
run;
You didn't say how much memory your PC has. You could try setting - MEMSIZE = 8GB - which has to be done in your SAS CONFIG file or as a command line option.
Sorry for missing infor. My Mac pro memory is 8GB (1867 MHz) with processor 2.9 HGz dual core intel core I5.
I run SAS on window so don't know it affects memory or not.
I will try to reset memory for SAS
Thank you
How much memory is assigned to the virtual windows environment?
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.