Hi All, I have following four date. Can anyone tell me what should be the code to calculate Total_Day=(Last_Day-Start_Day) - (Hold_Resume-Hold_Start) Start_Day        Hold_start               Hold_Resume          Last_Day Jan-01-2014     Jan-05-2014            Jan-10-2014             Jan-12-2014 Feb-01-2014                                                                 Feb-12-2014 Mar-01-2014                                    Mar-10-2014            Mar-12-2014 I wrote the following code, but it's not working: data out; set Have; Total_Day = (Last_Day -Start_Day)-(Hold_Resume-Hold_start); run; ... View more

Hi All, I have the following table. can anyone help me with the code so that I can get student list (and their course) who has taken English 1 or English 2 first. I have written the following code, but t's not working. data have; set out; if first.Course='English 2' or if first.course='English 1'; run; Student_ID        Course 101                   English 2 101                   Math 1 101                   Math 3 102                   English 1 102                   Math 2 102                   Math 2 103                   Math 2 103                   English 1 104                   English 1 104                   Math 3 My expected output would be: Student_ID        Course 101                   English 2 101                   Math 1 101                   Math 3 102                   English 1 102                   Math 2 102                   Math 2 104                   English 1 104                   Math 3 ... View more

Hi All, I have two table (table 1 and table 2) Can anyone tell me how to merge two table by adding right table (table 2 in my example) data to the first record of the left table (table 1 in my example) only. I wrote the following code, but it writes the right table info beside all left table observations. Data output; merge table1(in=a) table2(in=b); by ID; if a=1; run;           TABLE 1 (data is sorted by ID and then date) ID            Date 101     Jan-01-2015 101     Jan-05-2015 101     Jan-07-2015 102     Feb-01-2015 102     Feb-06-2015 103     Mar-01-2015          TABLE 2 ID            City 101     Dallas 102     Texas 103     Chicago                  OUTPUT ID            Date             City 101     Jan-01-2015     Dallas 101     Jan-05-2015     101     Jan-07-2015 102     Feb-01-2015    Texas 102     Feb-06-2015 103     Mar-01-2015    Chicago ... View more

Can anyone tell me the code how to create a new variable (Day_Diff) and calculate the day difference between Start_Date and End_Date of the following table? My dates are Numeric and Date9. format. ID    Start_Date  End_Date 1     12/01/2014  12/14/2014 1     01/01/2014  01/06/2014 1     01/01/2014  01/06/2014 1     10/01/2012  10/05/2012 2     01/01/2014  01/05/2014 2     12/01/2014  12/03/2014 2     12/01/2014  12/07/2014 2     02/11/2014  02/15/2014 2     01/01/2014  01/11/2014 I would much appreciate your help. Thanks, ... View more