Hi all, I really need your advice asap to create intervals of 3 months between 2 dates for all ids : begin_date and final_date. For the example provided (see file attached), the 2 dates are within 3 months of each other, but I could have the final_date in the analysis anywhere from 1 to 12 or more months apart.   The example provided is for id=604. It has  begin_date, final_date, event_number, event_date. All the dates had a format of yymmdd10. I first converted the  'begin_date' into a sas date callled 'begin_date2' to use the intnx function. Below is my code:   I created 2 start and end dates ..int1start, int1end, int2start, int2end and 2 intervals p_int1 and p_int2 . I gave the interval a value of '1' or '0' : '1' if the final_date was between the start and end dates for the interval and '0' if the final_date was absent between the start and end dates for the interval.   I would like to know if there is faster way to do this. How can I ask for the final_date to determine the 'last end date' for the 'last interval? Basically, how can stop creatung the interval dates? The final_date has to be within the last interval period. Also, can I create these interval start and end dates using macro and also the intervals p_int1 etc.? Please let me know and do look at the attachment for the end result of the code below.  I would like to know about a shorter way to accomplish the same.Thanks.   SAS CODE: begin_date2=begin_date; /* converted into a sas date*/   int1start=begin_date2 ; int1end=intnx('month',begin_date2,3,'same')-1 ;   int2start=intnx('month',int1end,0,'same')+1 ; int2end=intnx('month',int2start,3,'same')-1 ;   format int1start int1end int2start int2end yymmdd10.;   if int1start le final_date_new lt int1end then p_Int1=1 ; else if int2start le final_date_new lt int2end then p_Int2=1 ;   format int1start int1end int2start int2end yymmdd10.;       I also wanted to add that these intervals have to be determined for many others ids in the dataset. ... View more

Hi all, I need your advice asap to create intervals of 3 months between 2 dates : begin_date and final_date. For the example provided, the 2 dates are within 3 months of each other, but I could have the final_date in the analysis anywhere from 1 to 12 or more months apart.   The example provided is for an id=604. It has  begin_date, final_date, event_number, event_date. All the dates had a format of yymmdd10. I first converted the  'begin_date' into a sas date callled 'begin_date2' to use the intnx function. Below is my code:   I created 2 start and end dates ..int1start, int1end, int2start, int2end and 2 intervals p_int1 and p_int2 . I gave the interval a value of '1' or '0' : '1' if the final_date was between the start and end dates for the interval and '0' if the final_date was absent between the start and end dates for the interval.   I would like to know if there is faster way to do this. How can I ask for the final_date to determine the 'last end date' for the 'last interval? Basically, how can stop creating the interval dates just after I reach the final_date? The final_date has to be within the last interval period. Also, can I create these interval start and end dates using macro and also the intervals p_int1 etc.? Please let me know. I attached the end result of the code below.  I would like to know about a shorter way to accomplish the same.Thanks.   begin_date2=begin_date; /* converted into a sas date*/   int1start=begin_date2 ; int1end=intnx('month',begin_date2,3,'same')-1 ;   int2start=intnx('month',int1end,0,'same')+1 ; int2end=intnx('month',int2start,3,'same')-1 ;   format int1start int1end int2start int2end yymmdd10.;   if int1start le final_date_new lt int1end then p_Int1=1 ; else if int2start le final_date_new lt int2end then p_Int2=1 ;   format int1start int1end int2start int2end yymmdd10.;      I also have determine these intervals for many others ids in the original dataset.   Look forward to your replies. Thanks. ... View more

I need to select obervations which are groupd by variable 'id', where the values for the 2nd variable 'Assignment' is identical i.e 'Z' at all instances of the 'date variable for the id i.e id=2. Please see table below of the original dataset and final dataset needed. Any suggestions on how I can go about this? Please advise.   Original_dataset     ID Assignment Date 1 Z date1 1 D date2 1 B date3 1 B date4 2 Z date1 2 Z date2 2 Z date5 3 Z date2 3 M date4 3 Z date6       Final dataset     ID Assignment Date 2 Z date1 2 Z date2 2 Z date5 ... View more

Hi All, I am creating a sas dataset from a sql database that contains ids(ID) for different years (variable=Yr). In it, I have a variable called 'A' with specific values. There is another column 'B' which has values related to a specific value in column A. i.e for A='E' the values in B are 'E1', 'E2',' E3', 'E4', 'E5' and 'E6'. The dataset looks as follows.     ID Yr A B 1 1 2001 E E1 2 2 2001 E E1 3 2 2001 E E2 4 3 2001 E E1 5 1 2002 E E1 6 2 2002 E E3 7 3 2002 E E2 8 3 2002 E E3 9 3 2002 E E4 10 3 2002 E E5 11 3 2002 E E6    I have to create new variables for each unique value in varibale 'B' using conditonal logicand assign a value of 'Y' if a particular value is selected in varibale 'B', such as : if A='E' then do; if B='E1' then S1='Y'; else if B='E2' then S2='Y'; else if B='E3' then S3='Y'; else if B='E4' then S4='Y'; else if B='E5' then S5='Y'; else if B='E6' then S6='Y'; end;   After doing that and sorting by ID and Yr I get:   ID Yr A B S1 S2 S3 S4 S5 S6 1 1 2001 E E1 Y           2 1 2002 E E1 Y           3 2 2001 E E1 Y           4 2 2001 E E2   Y         5 2 2002 E E3     Y       6 3 2001 E E1 Y           7 3 2002 E E2   Y         8 3 2002 E E3     Y       9 3 2002 E E4       Y     10 3 2002 E E5         Y   11 3 2002 E E6           Y     Now I need to set all the missing values for S1 to S6 to 0 and create the final dataset which has to have a single records for each unique id for each unique year, illustrated in the table below:     ID Yr S1 S2 S3 S4 S5 S6 1 1 2001 Y N N N N N 2 1 2002 Y N N N N N 3 2 2001 Y Y N N N N 4 2 2002 N N Y N N N 5 3 2001 Y N N N N N 6 3 2002 N Y Y Y Y Y   I tried using arrays but I am not getting the correct data: %let crit= S1 S2 S3 S4 S5 S6;   array temp (*) $1 &crit; length &crit $1 ; by id yr; if first.yr; do x=1 to dim(temp); if temp(x) = '' then temp(x) = 'N'; end;   I am not sure what is worong with the array. Please adise and of any other way to accomplish the final dataset.  ... View more