topic Re: Error: File work.data does not exist in New SAS User

Error: File work.data does not exist

gioitran — Wed, 19 Jan 2022 05:32:13 GMT

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

Re: Error: File work.data does not exist

Kurt_Bremser — Wed, 19 Jan 2022 07:06:47 GMT

Please post the complete log of both steps into a window opened with this button:

Re: Error: File work.data does not exist

gioitran — Wed, 19 Jan 2022 18:53:39 GMT

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

Re: Error: File work.data does not exist

SASKiwi — Wed, 19 Jan 2022 19:45:59 GMT

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.

Re: Error: File work.data does not exist

gioitran — Wed, 19 Jan 2022 19:52:43 GMT

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

Re: Error: File work.data does not exist

SASKiwi — Wed, 19 Jan 2022 20:09:22 GMT

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;

Re: Error: File work.data does not exist

gioitran — Wed, 19 Jan 2022 20:29:40 GMT

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

Re: Error: File work.data does not exist

SASKiwi — Wed, 19 Jan 2022 21:19:11 GMT

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.

Re: Error: File work.data does not exist

gioitran — Wed, 19 Jan 2022 21:51:52 GMT

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

Re: Error: File work.data does not exist

andreas_lds — Thu, 20 Jan 2022 06:45:43 GMT

How much memory is assigned to the virtual windows environment?