Yes. It's great help! Thank you very much for your quick response. Tran ... View more

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  ... View more

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 ... View more

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  ... View more

  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 ... View more

Thank you very much ... View more

I tried to multiply the two weight before runing proc freq and it worked. I will double check it the result is correct. Thank you. ... View more

SAS failed to multiply the two weights. WTS_M is the first survey weight, weightas is the weight I created.   proc freq data=cch2; 226 tables MED_050*agecat/norow; 227 weight WTS_M*weightas; - 22 200 ERROR 22-322: Syntax error, expecting one of the following: ;, /. ERROR 200-322: The symbol is not recognized and will be ignored. 228 run; Thank you ... View more

Thank you for your response. The weight from the first survey is very complicated and created by that national survey. I don't know in details how it was created, but only have its code. I try to multiply these two weights but it did not work. Is there anyway that I can use these two weights?  Thank you ... View more