Hi all,   In my data, I'm combining data rows with the same interval value. Since the interval is a specific time frame in a day, I do first sort the data for day and after that for starttime. But when I do so, the first statement doesn't work and the data is not combined. I think that it has to do something with the by statement in combination with the first and last statement.     proc sort data=lot.data2; by day starttime; run; option locale=en_US; data lot.data2intervals (drop=eat_sec dmintake_g starttime rename=(sumsec=Eat_sec sumdmintake=dmintake_g timegrp1=starttime)); length interval 8 dmintake_g 8 timegrp1 $48 mcount 8 day 8 eat_sec 8; set lot.data2; by day starttime interval; retain sumdmintake 0; retain timegrp1; retain sumsec 0; if first.interval then do; sumdmintake=0; timegrp1=put(timehours,nldatm48.); *nldatm48. ; sumsec=0; end; sumdmintake=sumdmintake+dmintake_g; sumsec=sumsec+eat_sec; if last.interval then do; output; end; run;   mcount starttime day eat_sec dmintake_g interval 8 3:46:49 9 1171 100 1 1 6:50:06 9 1544 150 2 2 9:35:23 9 1380 10 3 3 12:04:51 9 1261 400 4 4 14:31:59 9 1175 700 5 5 18:20:41 9 2810 42 6 6 19:45:39 9 1158 785 6 7 22:15:21 9 1501 33 7 8 3:02:41 10 906 183 1 1 6:48:12 10 1650 6400 2 9 5:15:45 10 291 1100 2 2 9:51:50 10 1598 6100 3 3 11:07:00 10 963 4000 4 4 15:23:30 10 515 180 5 5 18:15:44 10 2829 1170 6 6 20:28:08 10 1318 540 7 7 22:05:39 10 1686 690 7 1 9:22:37 11 2883 12 3 2 11:05:39 11 1303 100 4 3 14:46:54 11 947 300 5 4 17:13:04 11 2176 100 5 5 19:49:31 11 1142 450 6 6 21:05:01 11 1071 450 7 7 21:55:15 11 1306 520 7 This is the data.         ... View more

Hi all,   I would like to transfom my dataset for further analysis. The goal is to get the data together with the same selectionnumber, to summate the intervals with the same selection numbers, except for the last interval with that selectionnumber. In stead of the interval, the seconds of that line needs to be used in the place of the interval in the summation. I can't get it working.   BR, Joost   /* input dataset */ data test(drop=datetm rename=(datetm1=datetm)); length cownum 8 datetm $ 16 interval 8 selectionnm 8 seconds; infile datalines dsd dlm="09"x; input cownum datetm $ interval selectionnm seconds; /* As datetime is in character,it needs to be traslated into datetime */ datetm1=input(datetm,datetime.); format datetm1 nldatm48.; cards; 11 13MAR20:09:10:41 14 1 10 11 13MAR20:09:10:55 46 1 20 11 13MAR20:09:11:41 60 1 35 11 13MAR20:09:12:41 35 2 28 14 13MAR20:09:10:41 120 1 50 14 13MAR20:09:12:41 60 2 10 14 13MAR20:09:13:41 60 3 40 14 13MAR20:09:14:41 35 3 30 ; run; ... View more

Hi everbody,   I would like to transform my dataset for further analysis, as in the document attached. The goal is to get the data together with the same selectionnumber. The cownumber and the datetime needs do stay the same, but the seconds need to be summated.  I can't get this working.    Which code / sas function is needed for this?       ... View more

Hello everybody,   I am curve fitting with normal (gaussian) and weibull distributions. I have a large dataset and some settings work better with the data than others. That is why I want to print the fit statisics in the output data so I can see it easily, in stead of scrolling through all the results. How can I do this?   Thank you!   Joost ... View more