The first part of the code works but the second part does not work, return 0 observations: proc sql;
create table post30 as
select a.Id, b.rx, b.rx_date, a.d_date, b.rx_date-a.d_date as days_after_disch
from disch as a
join drugs as b
on a.id=b.id
where 0< (b.rx_date-a.d_date) < 30;
quit;
... View more
One issue with the code, it produces duplicates of the same id-rx combination for the same rx_date; id rx_name rx_Date 1 a 05/01/2004 1 a 05/01/2004 1 a 05/01/2004 I tried to proc sort nodupkey by id, rx_name after the code you provided but is there a way to avoid this from the first place? thanks!
... View more
Thanks Reeza, this is exactly what I wanted which is rx during the 30 days pre and rx within the 30 days post. I tried it and it works perfect! Lilly
... View more
I want two seperate datasets; dataset A, rx_name within 30 days before d_date id rx_name 1 c dataset b, rx_name within 30 days post : id rx_name 1 a
... View more
id d_date rx_name rx_date h_date
1 3/2/2005 a 3/4/2005 2/29/2005
1 b 4/4/2005
1 c 2/25/2005
1 d
1 e
1
1
1
1
2
2
2
2
3
3
3 I have the following data where h_date is hospitalization date and d_date is discharge date. Each rx_name happen in the corresponding rx_Date. I am trying to find rx_name that happened within 30 day before h_date. Also, I want seperately to find rx_name that happaned within 30 days after d_date. Thanks.
... View more
I have the following data, multiple observation per id. several s_Date, one adm_date per id, I want to do the following: if hf=1 and the s_date is before adm_date then delete all observation for that id. id s_date hf adm_Date
1 1/1/2005 1 2/2/2004
1 7/7/2005 0
2 4/3/2004 0
2 2/2/2005 1 6/7/2005
2 0
3 0
3 4/4/2006 1 8/8/2005
3
... View more
I am trying to remerge two datasets under the following conditions: dataset1: more than one observation per id and multiple date per id id date age sex 1 .. 2... 3... 4 4 5 I created dataset 2 and selected distint id and the min(date) dataset 2, one observation per id id min_date 1 2 3 Now I want to remerge the data back to get all the other variables, how can I create an inner joint statement using both id and min(date) to get the other information specific to that date in the original dataset
... View more
Hi Jag, the code did not work on the original dataset. You specified count assuming I have the same ICD-9 code but I can have different one not necessarly the one I want.
... View more
i am trying to find id with 12 months of continous enrollment (no gap) before and after date_h. Each id can have multiple enrollment period (several start_e and end_e dates). In this example only id 1 should be included (have 12 months before and 12 months after). id 2 will be excluded because there was a gap in coverage between 8/8/2006 and 1/1/2007 id 3 will be excluded because there was 12 months of continous enrollment before but not after date_h
id start_e end_e date_h
1 1/1/2005 1/1/2006 2/8/2008
1 2/3/2006 4/5/2013
2 5/7/2005 8/8/2006 4/5/2007
2 1/1/2007 2/2/2012
3 5/9/2005 5/9/2007 1/1/2007
3 6/4/2008 7/7/2012
... View more
I am also trying to find id with 12 months of continous enrollment (no gap) before and after date_h. Each id can have multiple enrollment period (several start_e and end_e dates). In this example only id 1 should be included (have 12 months before and 12 months after). id 2 will be excluded because there was a gap in coverage between 8/8/2006 and 1/1/2007 id 3 will be excluded because there was 12 months of continous enrollment before but not after date_h. id start_e end_e date_h
1 1/1/2005 1/1/2006 2/8/2008
1 2/3/2006 4/5/2013
2 5/7/2005 8/8/2006 4/5/2007
2 1/1/2007 2/2/2012
3 5/9/2005 5/9/2007 1/1/2007
3 6/4/2008 7/7/2012
... View more
