Hi all, I need to calculate  SAS dates 3 month before and 3 month after given dates but not adding or subtracting 90 days  For example, I would like to know the dates (3 month before and after) using the given dates   3 month before Given date 3 month after 10/1/2017 1/1/2017 4/1/2017 11/1/2017 2/1/2017 5/1/2017 12/1/2017 3/1/2017 6/1/2017   Adding or subtracting 90 days do not give me the same dates with different months. Does anyone know how to calculate these types of dates?   Thanks! ... View more

Hi, I have a dataset of items and their prices.   Items    Price  a           10 b           1000 c            200 d            500   How do I create a table that shows items by descending order of price?   Items    price b          1000 d          500  c          200 a          10   Thanks for your help! ... View more

Hi , I need to create one dataset (only female)  from multiple datasets ( all contains same variables ) I  received. They are large files and I will be using same code to subset. What is the most efficient way to do this?   I thought of two ways to do this    method1 : subset each dataset and concatenate 10 smaller datasets data want1; (repeat 10 times) set have1; if female; run    data want_final set want1 want2 want3 want4 want5 want6 want7 want8 want9 want10; run;   method2; subset all at once   data final; set have1 have2 have3 have4 have5 have6 have7 have8 have9 have10; if female; run;   I am actually not sure if method2 is even correct way to subset data.   I am  open to any suggestions. Thanks!!     ... View more

Hi, I have a dataset I want to identify if two events occurred on the same date. I am not sure how to even start.   My data look like this ID  date      event1  event2 1   4/5/05     1             1 1   4/5/05     0             1 1   4/6/05     0             0 2   5/1/05     1             1 2   5/2/05     0             1  2   5/2/05     1             0   I would like to add a flag like this ID  date      event1  event2        Flag 1   4/5/05     1             1              1 1   4/5/05     0             1              1 1   4/6/05     0             0              0 2   5/1/05     1             1              0 2   5/2/05     0             1              1 2   5/2/05     1             0              1   Thanks much! ... View more

Hi, I have a dataset that I want to generate individual level dataset. I could do this by proc sort, data (retain, first.id) but I think proc sql would be more efficient in coding (some may not agree with this). Thanks   Currently I have ID    flag1 flag2  flag3 1     1       0         1 1     0       1         0 2     1       1         0 2     0        1        0   I would want the output to look like ID    flag1 flag2  flag3 1     1          1       1 2     1          1       0     ... View more

Hi, I need to find the closest prior event date ( from have 2) to index date( from have 1). so that the final dataset has ID, index date, and event date, one line per ID   I found some codes with Proc SQL but their codes didn't get me what I need. Thanks for your help.   data have1; input ID      index_dt; datalines; 15269  01/16/10 18658  07/31/08 23227  06/18/10   data have2; input ID    event_dt; datalines; 15269  01/15/10 15269  10/10/10 15269  09/02/10 15269  10/12/10 15269  04/28/10 15269  08/07/10 15269  05/13/10 15269  05/31/10 18658  06/13/08 18658  06/14/08 18658  06/19/08 18658  07/05/08 18658  07/14/08 18658  08/05/08 18658  03/02/09 23227  01/28/10 23227  03/30/10 23227  04/17/10 23227   04/18/10   Final dataset should look like; ID             index_dt           event_dt 15269      01/16/10           01/15/10 18658      07/31/08          07/14/10 23227     06/18/10            04/14/10     ... View more

Hi, I am trying to merge two datasets, But not getting the result I need.   Dataset1                                Dataset2 ID      Date                             ID           Date 1        1/2/15                           1            2/9/16 1        2/3/16                           1            2/20/16 1        3/3/16                           1            4/4/17 1       4/5/17 1       5/5/16 My code was (after sorting both datasets by ID)   data want; merge dataset2 dataset1; by id; run;   My result contains only dataset2 with none of the dataset1. I don't see anything wrong with this code.  I also tried to switch the order of the dataset such that my code was   data want; merge dataset1 dataset2; by id; run;   Then I get 3 lines from dataset2 and last 2 lines from dataset 1 as if I can only have maximum of 5 lines when I merge the dataset. Any thoughts on this problem?    Thanks     ... View more