Hi,   I am running GENMOD. It gives me a warning  as below:      WARNING: Iteration limit exceeded.   The outcome results look unreasonable. What can I do?   Best regards, Qinghe Yin   WARNING: Iteration limit exceeded. ... View more

Hi,   I find that in proc sql the "full join" of 2 sets depends on the order. I did the following experiement:   data a; do i=1 to 2; x="a"; output; end; data b; do i=2 to 3; y="b"; output; end; proc sql; create table a_full_join_b as select * from a full join b on a.i=b.i; run; proc sql; create table b_full_join_a as select * from b full join a on a.i=b.i; run;   The results are as blow:   a_full_join_b:   1 1 a   2 2 a b 3 .   b   b_full_join_a:   1 .   a 2 2 b a 3 3 b     What I want is: 1 1 a   2 2 a b 3 3   b   How I get it with proc sql?   I know that in this particular case we can use merge. but my real problem is many to many. merge does not work well.   Thanks a lot.   Qinghe           ... View more

Hi there,   Below is my program: data hosp_proc12a; merge hosp12 (in=a) procd; by record_id; if a; if procedure_no=. then procedure_no=0; else if 5 <= procudure_no <=9 then procudure_no =5; else if procudure_no >=10 then procudure_no=10;   keep record_id indig procedure_no age_grp; run ;   For missing value, I can get a 0. but for other values, there is no change at all. I still have values like 8, 11, 13, 18 in there. I tried to to define a new variable: data hosp_proc12a; merge hosp12 (in=a) procd; by record_id; if a; if procedure_no=. then procd_no=0; else if 1 <= procudure_no <=4 then procd_no =procudure_no ; else if 5 <= procudure_no <=9 then procd_no =5; else if procudure_no >=10 then procud_no=10;   keep record_id indig procedure_no age_grp; run ;   But this time I can only get procd_no=0 when procedure_no is missing and procd_no is missing when procedure_no take other values.   Why this can happen? WHat I need to do?   Qinghe  ... View more

Hi there,   I have got the following error message:   "557: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 557-185: Variable fisrt is not an object. ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 131.12k OS Memory 14892.00k Timestamp 01/14/2016 10:32:49 AM   ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 5, 10 ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro HP3067 will stop executing."   The macro is as belw:   %macro HP3067(yr1, yr2, yr3); data HP; set hosp_proc&yr2 hosp_proc&yr3; %sort(HP, Indig); data HP; set HP; by indig; if fisrt.indig then do; %do i=1 %to 5, 10; p&i=0; %end; total=0; end; total+1; %do i=1 %to 5, 10; if procedure_no=&i then p&i+1; %end; %do i=1 %to 5, 10; pct&i=p&i/total* 100; %end; pt=100; if last.indig then output; run; %mend;   Anyone can tell me what I did wrong? Thanks.   qinghe ... View more

Hi,   I have got the following information in the log: NOTE: Invalid argument to function YRDIF at line 21 column 18. NOTE: Invalid second argument to function SUBSTR at line 26 column 9. NOTE: Invalid second argument to function SUBSTR at line 27 column 9. The lines 21 to 27 ar as below: 21 age_at_131015 = yrdif(birth_date, '13oct2015'd, 'act/act'); 22 if age_at_131015 <5 then age_grp="0-4"; 23 else if age_at_131015 <15 then age_grp="5-14"; 24 else age_group="15+"; 25 if substr(Indigenous_status, 1, 1)="A" or substr(Indigenous_status, 1, 1)="T" then Indig=1; 26 else if substr(compress(Indigenous_status), 1, 4)="NOTA" then Indig=2; 27 else if substr(compress(Indigenous_status), 1, 4)="NOTS" then Indig=9;   What I did wrong?   Thanks.   qinghe ... View more