Hi   I have 740 firms and I want to attach dates of trading days from June 8th 2020 till July 17th 2020 with these firms. Hence, each firm needs to have a time series of daily dates (Panel data). I want to create a list of dates for these trading days in mmddyy10. format. Is there any SAS code which can help me in this regard? Thanks ... View more

Hi I want to create a sequence of unique numbers in a column, but each number must repeat 5 times (i.e. same number in 5 rows). For example number 1 in first five rows, then number 2 must again repeat five times and so on. Please help. Thanks ... View more

Hi    I have a dataset with weekly observations for all variables. The format of "Date_week" is "mmddyy10." For every variable, I have one observation per week, but it is not necessarily the last working day of the week.    I want to find out "week number" for every month. I have used following code, but it does not give me the exact week number for the dates that are not the last working day (Friday) of a week.    Please guide me in this regard. Thanks.   data tmp1; set tmp; Week = ceil( day(Date_week) / 7); run; ... View more

Hi I am struggling to find a code that can help me combining two datasets i.e. one and two.   data one; input X Y $ Z; datalines; 1 a 0.1 1 b 0.2 1 c 0.5 2 c 0.8 2 d 0.5 2 e 0.7 ; data two; input Y $ R; datalines; a 5 b 6 c 9 d 7 e 2 f 4 ; data Want; input X Y $ Z R; datalines; 1 a 0.1 5 1 b 0.2 6 1 c 0.5 9 1 d . 7 1 e . 2 1 f . 4 2 a . 5 2 b . 6 2 c 0.8 9 2 d 0.5 7 2 e 0.7 2 2 f . 4 ; run; Kindly guide me in this regard. Thanks ... View more

Hi   I have a dataset with dummy variables created for different IDs and Time (using proc glmmod). I have more than 1000 IDs. I want to rename all the columns of ID dummy variables from " ID_10001 ID_10002 ID_10006 ID_10010 ID_11114 "  to  " ID1 ID2 ID3 ID4 ID5 " and so on.    Looking for a code that can help me achieving this purpose.   data have; input Y X1 X2 ID_10001 ID_10002 ID_10006 ID_10010 ID_11114 Year_2005 Year_2006 Year_2007 ; datalines; 1010 100 0 1 0 0 0 0 1 0 0 1022 250 0 1 0 0 0 0 0 0 1 1134 180 0 0 1 0 0 0 0 0 1 1014 450 1 0 0 1 0 0 1 0 0 2526 450 1 0 0 1 0 0 0 1 0 1014 300 0 0 0 1 0 0 0 0 1 4012 999 0 0 0 0 1 0 1 0 0 3179 850 1 0 0 0 1 0 0 1 0 1012 720 0 0 0 0 1 0 0 0 1 3175 800 0 0 0 0 0 1 1 0 0 ; run; ... View more

Hi I have a dataset with some missing monthly dates. Please see below:   data have; input ID DATE: MMDDYY10. PERMNO SHARES; format DATE MMDDYY10.; datalines; 1 01/31/2012 10107 100 1 01/31/2012 10145 250 1 01/31/2012 11340 180 1 03/31/2012 10145 450 1 03/31/2012 25267 450 1 04/30/2012 10145 300 2 12/31/2015 40125 1000 2 12/31/2015 31799 850 2 03/31/2016 40125 720 2 03/31/2016 31799 800 ; run; I want to complete all missing months in a year with all the observations of the previous month.   data want; input ID DATE: MMDDYY10. PERMNO SHARES; format DATE MMDDYY10.; datalines; 1 01/31/2012 10107 100 1 01/31/2012 10145 250 1 01/31/2012 11340 180 1 02/28/2012 10107 100 1 02/28/2012 10145 250 1 02/28/2012 11340 180 1 03/31/2012 10145 450 1 03/31/2012 25267 450 1 04/30/2012 10145 300 2 12/31/2015 40125 1000 2 12/31/2015 31799 850 2 01/31/2016 40125 1000 2 01/31/2016 31799 850 2 02/28/2016 40125 1000 2 02/28/2016 31799 850 2 03/31/2016 40125 720 2 03/31/2016 31799 800 ; run; Please guide in this regard. Thanks. ... View more