Hi I have been using the excellent post by Sanjay to create Forest plots with SAS: http://blogs.sas.com/content/graphicallyspeaking/2013/01/06/forest-plot-with-sas-9-3/#comment-15665 However, I wonder if it is possible to improve this further, can anyone please suggest a way to make the size of the square in the middle of the lines proportional to the subgroup? Best regards ... View more

Hi I am trying to get the betas and the odds ratio from a conditional logistic regression as follows: ods output CLOddsWald=log1 Parameterestimates=Est1; proc logistic data=test ; strata crb; class race sex; model case(event='1')= race sex age /  rl; by category; run; For some reason the proc logistic is failing to produce the log1 table with odds ratios, the other table Est1 is produced correctly. This code, however,  works perfectly well without the strata option, ie the conditional regression where both output tables are generated!. Any idea? Best regards ... View more

Hi A question please, i have a table containing a large number of observations, the table ( a case-control study) looks like this Header 1 Header 2 Header 4 A 23 43 A 86T 80 A 87 77 A 78 776 A 48 5 D 23 22 D 77 1 D 16 3 D 99 4 C 65 5 C 555 6 C 7 7 C 09 7 what i want is to create another table that would only include the first three observations in each group in the first columns (Header 1), here is the output Header 1 Header 2 Header 4 A 23 43 A 86T 80 A 48 5 D 23 22 D 77 1 D 16 3 C 65 5 C 555 6 C 7 7 Any help is appreciated er of ... View more

Hi all Can anyone please advice me how to correct this code, I am basically trying to create and combine serial tables %macro repeat_comb(levels=); %do var=1 %to &levels; %let j=&var-1; proc sql; create table s&var as select a.*,b.flag as L&var from s&j as a left join tableD as b on a.class like b.L&var; quit; %end; %mend; %repeat_comb(levels=8) The problem is in creating the second variable (j) and using it to refer to tables s&j which is returing error Best regards ... View more

Hi A quick question. I have several datasets (HR1, HR2, HR3,.....HR 20) I need to combine a number of these tables using (data..set) according to certain criteria, since this is a repetitive task I chose to build a macro like this %macro repeat_set(n=); %do var=1 %to &n; Data j; if &var=1 then do;            set HR&var;            end; else if &var gt 1 then do;            set j HR&var;     end; run; %end; %mend; The reason why I am doing this is that the new dataset 'J' dose not exist from the beginning, so while looping, the idea is when the code takes the first HR set (HR1) it will create 'j' using the following: data j; set HR1; run; and for the consequent sets, like HR2 , it will do data j; set j HR2; run; and so on So when I do a %repeat_set(n=1); the code executes correctly BUT, when I do anything larger than 1, ex %repeat_set(n=5); The code combines only tables HR2-HR5. It seems as if HR1 contribution to the new set 'j' is "deleted" during the process. Any suggestions? Best regards ... View more