Dear Experts,   I have to calculate the date duration in the below-given format. Let me share the sample dataset for a clear view.   data have; input Id r_date :mmddyy10. e_date :mmddyy10.; format r_date e_date mmddyy10.; cards; 101 05/18/2001 09/25/2002 101 09/26/2002 12/12/2003 101 12/13/2003 05/04/2004 108 06/06/1995 08/12/1996 108 08/11/1996 07/10/1999 run; For this data set, I need to process the date duration in the given method. Expected output.   Note : The value of Start_dur in each minimum R_date of IDs is always 0            Each E_dur will calculate the duration of the minimum R_date of corresponding IDs.   Please suggest some ideas to solve the task. Thanks in Advance!   ... View more

Dear Experts,   I have a Questionnaire type dataset to evaluate the value of the boolean type (Y/N) questions. I shared the sample dataset below for better understanding. data aaa; input ID Emp$ Gen$ Q1$ Q2$ Q3$ Q4$ Q5$; cards; 132 Govt M Y N N N N 321 Prvt F N Y Y N N 159 Prvt F Y Y N N N 357 Govt M N N N N Y ; I have to calculate the N(sum) and % of how many Y (Yes) checked. I expect the result as   I tried with Proc Tabulate but it returns partial output. proc tabulate data = aaa; class Q1 Q2 Q3 Q4 Q5 Emp Gen; tables (Q1 Q2 Q3 Q4 Q5)* all, Emp*(Gen); run; Please suggest a solution to solve the given problem. Thanks in advance!  ... View more

Dear Experts,   I used Proc tabulate procedure to solve the tally information of the given (sample dataset) table. But I required a tally of the Percentage columns as 100%. For more details kindly go through the below information. data aaa; input ID age$ sex$ Emp$; cards; 1 18-25 M Govt 2 50-60 F Pvt 6 26-35 F Govt 8 18-25 M Pvt 4 26-35 F Govt 5 36-45 M Govt 9 46-55 M Pvt 3 18-25 M Govt 0 36-45 M Govt ; proc tabulate data = aaa; class age sex Emp; tables age all,Emp*(sex=' ' *(n*f=8. reppctn='%')) all='Total'*(n*f=8. reppctn='%')/rts=10; run; If you run the above code. It results N and % of 9 observations as Gender and Employment wise. But I require a % column to calculate its value as 100% of its gender and employment like the Image given below. Kindly suggest the code which results in an image.   If you require any clarification. I will be glad to help. Thanks in advance!       ... View more

Dear Experts,   I couldn't get the 100% in freq of the age column. Kindly go through the result below for more info. Age_cat Frequency Percent 18-25 120 13.33 26-35 180 20 36-45 180 20 46-55 180 20 56-65 120 13.33 >65 120 13.33 If I sum up the percentage it returns 99.99. There is no missing/ value 0 in the age column. How could I solve it, Please suggest some ideas? Thanks in advance!     ... View more

Dear Experts,   I want to calculate the Surgery_date value from the Surgery_Duration. Kindly go through the given sample dataset. data have; input ID Record_date mmddyy10. Duration DuratIn$.; format Record_date mmddyy10.; cards; 101 03/05/2001 7.6 Years 102 04/02/2001 6 Months 103 03/08/2003 2.06 Years ; Expected OP: ID Record_date Duration DuratIn DateonSurg 101 03/05/2001 7.6 Year 09/05/2008 102 04/02/2001 6 Month 10/02/2001 103 03/08/2003 2.06 Year 03/14/2005   Please Suggest some ideas to solve the case. Much Thanks! ... View more

Dear Experts,   I want to update the missing Height value in my table for the given IDs Kindly go through my sample set for detail.   data have; input ID date mmddyy10. Heigth weight; format date mmddyy10.; cards; 101 12/06/1993 159 67 101 10/08/1994 . 61 101 06/01/2000 . . 102 08/08/2001 . 87 102 07/30/2002 160 . 102 11/03/2004 . 65 ; Expected Result: ID date Heigth weight 101 12/06/1993 159 67 101 10/08/1994 159 61 101 06/01/2000 159 . 102 08/08/2001 160 87 102 07/30/2002 160 . 102 11/03/2004 160 65   Please suggest some ideas to solve the given program. Much Thanks! ... View more

Hi Experts,   I want to merge my data in the below-given format. Kindly help me solve it.     data aaa; input ID date1 mmddyy10. reg$; format date1 date9.; cards; 100 02/10/1990 V 100 05/09/1991 V 100 12/03/2000 V 101 05/05/2000 V 101 08/07/2010 V 101 04/03/2015 V ; data bbb; input ID date1 mmddyy10. reg$; format date1 date9.; cards; 100 02/10/1990 R 100 07/08/1995 R 100 12/03/2000 R 101 01/01/2001 R 101 08/07/2010 R 101 04/03/2015 R ; Required Output :  ID date1 reg 100 10-02-1990 V 100 09-05-1991 V 100 08-07-1995 R 100 03-12-2000 V 101 05-05-2000 V 101 01-01-2001 R 101 07-08-2010 V 101 03-04-2015 V   V - Visit; R - Record  If visit_date same as record_date  then reg should 'V' If record_date not in aaa table then that line should be included in the Current table/New Table with reg value of 'R'.   Please let me know If you required clarification. Thanks in advance!     ... View more