c**********5
发帖数: 653 | 1 Hi,
Could you help me with code?
Thanks a lot.
Raw data :(per each id we follow up to 60 minutes and measure temp in each
minute.
Id Minute Temp
1 1 31
1 2 32
1 3 36
1 4 35
1 5 33
1 6 32
1 7 30
1 8 30
1 9 33
1 10 34
1 | D******n
发帖数: 2836 | 2 %macro mm(dat,ub);
title "1
proc sql;
select id,avg(temp) as AVG_TEMP,max(temp) as MAX_TEMP from &dat where minute
<=&ub group by id;quit;
%mend;
%mm(data,5);
%mm(data,10);
%mm(data,60); | c**********5
发帖数: 653 | 3 Hi,
thank you so much.
That's wonderful
. After that I got the 12 subdataset and I merge them by proc sql; |
|
