Hello Experts,
I’m runing this code :
proc sql;
create table test2 as select distinct a.NO_POLICE, sum(MT_EA) as Encours,
a.S_TYPE_SUPPORT, a.D_VALO from test as a
group by a.NO_POLICE, a.S_TYPE_SUPPORT, a.D_VALO;
run;
to get the data like this:
POLICE
Encours
S_TYPE_SUPPORT
D_VALO
X070704733
5501.856756
UC
09MAR2022:00:00:00
X070709982
13748.71306
UC
09MAR2022:00:00:00
X070715392
73757.139242
TXGAR
09MAR2022:00:00:00
X070715392
12415.318992
UC
09MAR2022:00:00:00
X080175233
500040.2903
TXGAR
09MAR2022:00:00:00
But I would like to represent my result in this way :
POLICE
UC
TXGAR
D_VALO
X070704733
5501.856756
09MAR2022:00:00:00
X070709982
13748.71306
09MAR2022:00:00:00
X070715392
12415.318992
73757.139242
09MAR2022:00:00:00
X080175233
500040.2903
09MAR2022:00:00:00
Do you know please, the best way to do that ?
Thank you for your help !
... View more