Hi all I have a code that looks like this: %let var=1; proc phreg data=have ; strata country; class sex ; model time*event&var(0)=factor&var age weight / rl; ods output parameterestimates = CorrelationEstimate&var; run; The reason why I am using a macro variable is that I need to repeat this code 20 times, with the "var" value from 1 to 20. I have been doing this manually by changing the number and re-running the code. There should however be a way to "loop" through numbers 1 to 20 and re-run the code automatically Any tips? Appreciated Best reg ... View more

Hi I appreciate some help with this task, which I find a bit challenging I have two tables: 1- Table 1: Containing patients and their diagnosis coded according to ICD code system (the table has several thousand rows in reality) Patient Diagnosis JOHN A1 ALEX A12 ZAK K12 RICHARD A25 SAM G3 MANNY H2 2- Table 2: basically contains a number of ICD diagnosis groups, for the sake of simplicity let us say we have three columns A, B, C each of which has rows representing a number of ICD diagnosis codes, here is a simplification: Group A Group B Group C A12 A21 C13 A25 A33 J12 H12 G1 A1 K12 K77 L5 G1 J12 A12 D3 A25 G3 What I would like to do is to create a third table which is essentially Table 1 plus three more columns each for group A, B and C. The code would then go through every row and see if the ICD diagnosis in table 1 fits any of the diagnoses in Groups A, B and C and if so it would fill the corresponding cell with 1 otherwise 0. Here is the final table just to explain: Patient Diagnosis Group A Group B Group C JOHN A1 0 0 1 ALEX A12 1 0 1 ZAK K12 1 0 0 RICHARD A25 1 1 0 SAM G3 0 0 1 MANNY H2 0 0 0 Could anyone please suggest how this can be done? The tables in reality are of course much much larger Best regards ... View more

Hi Imagine we have the following SAS table: Treatment Date1 Date2 Date3 Effect 1 12/03/2002 02/02/2012 0 3 2 01/11/2009 2/10/2011 0 2 2 21/08/2013 29/03/2012 2/10/2012 1 1 11/10/2015 0 26/12/2014 3 I am trying to get the "earliest" date in each row that is not equal to zero the following code will not woke because the empty cells are coded as 0 proc sql; create table want as select min (Date1, Date2, Date3) as min_date from have; quit; Any ideas on how to do that (without replacing all zeros with missing values)? best regards Am ... View more

Hi all I just need help on this (rather annoying) issue which I (as a beginner) am not able to figure out how to solve Many times when I run graphics, and when I am done with the graphics and want to move ahead to other procedures, I end up having a problem. Sas displays error message in the results windows about "This page cant be displayed" This is an example of a procedure I just ran: ods html file='groups' path='C:\temp\'; ods graphics on / width=8in imagefmt=html dpi=300 imagemap=on  border=off; proc sgplot data=cat1; vbar Disease /response=pct group=NIS groupdisplay=cluster; xaxis label=' Disease Stage'; yaxis label='Percent'; run; This code runs perfectly and the image is saved as I wanted in the temp file. But somehow this messes up all results afterwards than cant be displayed in SAS Tried searching without luck, some suggestion didnt work for me The only solution I have now is to restart SAS Any ideas? Best regards ... View more