Thank you!! ... View more

The flag variable is giving ' . ' in cases where the diff is less than 30 days. For cases where there is no readmission and diff is null it should give flag as 0. please help!!! ... View more

I have complex queries already performed on tables and inputting huge data through data step from tables will complicate the entire process. So I am looking out for a solution which can resolve this issue. ... View more

Thanks Reeza. But, I was wondering if I can integrate the tables with the data step without inputting values again... ... View more

Thanks.   But I already have all the data as tables inputted in sas and this is a new variable in the select statement along with 5 other variables which are flagged.    So I am specifically inclined in trying a solution in proc sql statement.        ... View more

That's just a sample health data .   I would like to create a flag variable in proc sql.    I am trying to calculate the difference in date from the first discharge date and the readmission date. If it is less than 30 days then the flag should be 1.     intck('day',dt_admission, dt_discharge) would give the difference for each particular row  but not readmission date.   ... View more

Thank you! But there are so many errors in flag creation. My date columns have null values ie missing values in the table..   1.When I use this command with proc sql,   intck('day', dt_discharge,dt_death) le 30 as flg_30d ,   when dt_death has missing values it should give 0 as output but it is returning 1.     2. Also, flg_30d or flg_rf  as flg_x_30d cannot be used as such in proc sql right?   I suppose I should use the entire expressions intck('day', dt_discharge,dt_death) le 30 or intck('day', date_of_discharge, death_date) le 60 as flg_60d as flg_x_30d   in proc sql to flag those variables.   3. There is another expression in intck('day', dt_discharge,dt_admission) where I have to find the difference between discharge date and second successive admission date to hospital. So how would I find second instance of  dt_admission ?   kindly help....   ... View more

This code is not working.     I have used it like this     proc sql; create table Table3 as select *, condition= 'R3' as flg_rf  from table2; select * from Table3;   I have to create 5 dummy variables..     ... View more

I have another doubt.. Can I write flag variables using proc sql code? If yes how?   Thanks a lot for being patient.   ... View more

Thanks a lot Reeza!! It worked!! ... View more

Thank you. it worked ... View more