Hi, I was trying to make the first return of each day equals to 0 and keep the rest returns unchanged. 'Return' is the variable that I calculated based on price.    Here is the sample of Have: data have; input Interval Return date ：ddmmyy10. ; datalines; 1 23 03/09/2012 2 32 03/09/2012 1 45 04/09/2012 2 12 04/09/2012 3 56 04/09/2012 1 43 05/09/2012 1 76 06/09/2012 2 43 06/09/2012 3 34 06/09/2012 4 54 06/09/2012 1 39 07/09/2012 1 54 08/09/2012 2 43 08/09/2012 1 65 10/09/2012 run; Want: data Want; input Interval Return date ：ddmmyy10. ; datalines; 1 0 03/09/2012 2 32 03/09/2012 1 0 04/09/2012 2 12 04/09/2012 3 56 04/09/2012 1 0 05/09/2012 1 0 06/09/2012 2 43 06/09/2012 3 34 06/09/2012 4 54 06/09/2012 1 0 07/09/2012 1 0 08/09/2012 2 43 08/09/2012 1 0 10/09/2012 run; Here is the code I tried: Proc sort data=Have; By Date Interval; Run; Data Want; Set Have; By Date Interval; if first.Date or first.Interval then Return = 0; run; I got all the returns turned to 0. Is there any suggestion? Thank you in advance. ... View more

Hi, I would like to retrieve one value from one column to create a new column and keep this value constant through the new column. Here is the have and want. I appreciate any advice. Thank you! data have; input _NAME_ $6. COL1; datalines; date1 17167 s1_bm1 0.011909 s1_bm2 -0.000674 s1_bm3 -0.000645 s1_bm4 0.002035 s1_bm5 0.029314 s2_bm1 0.019645 s2_bm2 0.012246 s2_bm3 0.013749 s2_bm4 0.006763 s2_bm5 0.022934 s3_bm1 0.035394 s3_bm2 0.027839 s3_bm3 0.017082 s3_bm4 0.03592 s3_bm5 0.006751 s4_bm1 0.041027 s4_bm2 0.033723 s4_bm3 0.01814 s4_bm4 0.023475 s4_bm5 0.018217 s5_bm1 0.019427 s5_bm2 0.008693 s5_bm3 0.007499 s5_bm4 0.000978 s5_bm5 0.035601 Mkt_RF 0.014 SMB 0.001 HML -0.0011 num 1 Run; data want; input _NAME_ $6. COL1 date number; datalines; date1 17167 17167 1 s1_bm1 0.011909 17167 1 s1_bm2 -0.000674 17167 1 s1_bm3 -0.000645 17167 1 s1_bm4 0.002035 17167 1 s1_bm5 0.029314 17167 1 s2_bm1 0.019645 17167 1 s2_bm2 0.012246 17167 1 s2_bm3 0.013749 17167 1 s2_bm4 0.006763 17167 1 s2_bm5 0.022934 17167 1 s3_bm1 0.035394 17167 1 s3_bm2 0.027839 17167 1 s3_bm3 0.017082 17167 1 s3_bm4 0.03592 17167 1 s3_bm5 0.006751 17167 1 s4_bm1 0.041027 17167 1 s4_bm2 0.033723 17167 1 s4_bm3 0.01814 17167 1 s4_bm4 0.023475 17167 1 s4_bm5 0.018217 17167 1 s5_bm1 0.019427 17167 1 s5_bm2 0.008693 17167 1 s5_bm3 0.007499 17167 1 s5_bm4 0.000978 17167 1 s5_bm5 0.035601 17167 1 Mkt_RF 0.014 17167 1 SMB 0.001 17167 1 HML -0.0011 17167 1 num 1 17167 1 Run;   ... View more

Hi, I'd like to remove all the observations of one date whenever the If condition meets. For example, if 'OilCount >= 8' then all the observations of that date are removed (rather than the observations that meet 'OilCount >= 24' within that date.) I appreciate any advice. Thank you. data have; input OilCount date ：ddmmyy10. ; datalines; 0 03/09/2012 6 03/09/2012 0 04/09/2012 5 04/09/2012 1 04/09/2012 4 05/09/2012 5 06/09/2012 3 06/09/2012 6 06/09/2012 8 06/09/2012 11 07/09/2012 3 08/09/2012 2 08/09/2012 4 10/09/2012 run; data want; input OilCount date ：ddmmyy10. ; datalines; 0 03/09/2012 6 03/09/2012 0 04/09/2012 5 04/09/2012 1 04/09/2012 4 05/09/2012 3 08/09/2012 2 08/09/2012 4 10/09/2012 run;   ... View more