Hi guys, I am trying to concatenate two variables(var1 and var2) . Can anyone suggest me how this can be done   var1  var2           Var3 Q1     Q3            Q1,Q3   The final output should be like var3.   Thaks in advance ... View more

I have a data table that stores each year, month and day value as ints: year | month | day2009 | 1 | 1 2008 | 12 | 2 2007 | 5 | 5 I need to convert it to datetime value, because I need to use it in a datetime between operation. How could I do this? ... View more

Hello,   I want to get each date with non-missing dates.   My approach is if I can replace missing dates to the previous no-missing value,  However, I'm having difficulty to replace these missing value.,   I appreciate any help.     data test; input subid$ startdate enddate; datalines; XYZ-123-001-001  2013-04-04 2013-04-05 XYZ-123-001-001  2013-05-23 . XYZ-123-001-001  2013-06-07 2013-06-13 XYZ-123-001-001  2013-06-09 2013-06-15 XYZ-123-001-001  2013-07-07 . XYZ-123-001-001  2013-07-27 . XYZ-123-001-001  2013-08-07 2013-08-13 ... View more