Dear Experts,   I want to visualize my data as a horizontal format with summing the year value.  For example :  data lkj; input ID yearof; cards; 132 2004 132 2004 132 2005 321 2010 321 2010 321 2015 run; Required OP   ID 2004 2005 2010 2015 132 2 1 . . 321 . . 2 1   Kindly help me to transform in the given format. Thanks in advance! ... View more

Hi experts,  I trying to sum up my analysis table using Proc Tabulate. Kindly gothrough the given sample method in detail.  I want to sum up the Gender variable at the end of OP.   data have; input Type$ Grp$ Sex$; cards; 1 G F 1 G M 3 O F 3 P M 3 G F 4 P M 7 G M 7 G F ; proc tabulate data = have; class Type Grp Sex; tables Type, Grp*Sex ALL; keylabel n=' '; run;   The result shares the perfect OP values but I required it in the right side displayed tabular format. Please help me to sum up the Sex variable as the last column in the table. I tried a lot but nothing works well. Thanks in advance!     ... View more

Hi experts,  I'm trying to align my analysis in a particular format but my code won't work. I need your suggestion to align in the given format. Kindly go through the below sample. data have; input age$5. Grp$ arg$; cards; 18-25 G a 18-25 G b 18-25 O c 18-25 P a 18-25 G c 26-35 P b 26-35 G a 26-35 G a ; proc tabulate data = have; class age Grp arg; tables age*Grp, arg; run;   The result shares the perfect OP values but I required it in the right side displayed tabular format. Please help me to rearrange the table. I tried a lot but nothing works well. Thanks in advance! ... View more

Hi experts,   I need a clarification in the following sample data set. I need to update the followup dates in separate column. data aaa; input ID date mmddyy10.; format date mmddyy10.; cards; 10003 09/26/2003 10003 05/15/2004 10003 01/09/2007 10003 07/05/2007 ; Expected Output +---------+-----------------+---------------+ | id         | date             | follow_up   | +---------+-----------------+---------------+ | 10003 | 2003-09-26 | 2004-05-15 | | 10003 | 2004-05-15 | 2007-01-09 | | 10003 | 2007-01-09 | 2007-07-05 | | 10003 | 2007-07-05 | .                  | +---------+----------------+----------------+   Please suggest some idea to organize the followup date as given above. Thanks in advance! ... View more

Hi Experts,   Please have a look at the given sample dataset. data Want; input ID Visit_count Ht Wt; cards; 11 1 . . 11 2 . . 11 3 . . 11 4 . . 11 5 . . 23 1 . . 23 2 . . 23 3 . . 23 4 . . 65 1 . . 65 2 . . run; data Have; input Id date mmddyy10. Height weight; format date mmddyy10.; cards; 11 05/04/2000 156 98 11 04/06/2000 156 94 11 08/08/2001 157 92 23 07/06/2010 187 65 23 12/10/2010 187 68 23 04/05/2011 187 . 23 11/15/2012 187 70 65 10/07/2015 166 84 65 12/12/2016 167 86 ; I have to update the Ht and Wt in want table from have. But I need to update it through order wise of date. The 1st date noted as VisitCount = 1, 2nd date noted as visitcount =2 and so on... If the Height/Weight value is null on that Visit it remains null. I could do it for a small dataset. But I have more than 500 visits for some IDs. I think update using the loop is the only solution. I expect my OP as ID Visit_count Height weight 11 1 156 98 11 2 156 94 11 3 157 92 11 4 . . 11 5 . . 23 1 187 65 23 2 187 68 23 3 187 . 23 4 187 70 65 1 166 84 65 2 167 86 As well I need to update some other parameters from different tables using the same pattern. Please help me to solve it.   Thanks in advance!   ... View more