Works, and at the beginning it is ok, but please make three changes.
1. first, it's a _n_ search, not a datetime search.
In the original set B, a few observations may be missing (no temperature measurement) and I want the subsets of Table B to be equal.
in my code:
set A;
if _n_ = &i then do;
call symput("datetime" , datetime);
call symput("Nr" , Nr);
end;
run;
data _null_;
set B;
if datetime = &datetime then do;
call symput("nrdb" , _n_);
end;
run;
data B_temp;
set B;
if (&nrdb + 1) <= _n_ <= (&nrdb + 10);
datetime = INTNX('second',datetime,- 60);
run;
2. secondly, it is transposed every 10 observations (depends on the sampling range). in the garden set B there is still a variable pressure.
data B_temp;
do i = 1 to 10;
set B_temp;
array temperature_ temperature_1 - temperature_10;
temperature_[i] = temperature;
end;
drop i;
run;
3. third, dividing table B into separate tables depending on the variable "Nr"
