I have a dataset A;
Data A;
input pet$ owner$;
cards;
Pet owner
cat w1
cat w2
cat w3
dog w4
dog w5
; run;
How can I make it like something below? That is to keep only the first.pet
Pet owner
cat w1
w2
w3
dog w4
w5
Thanks so much!
p***7 发帖数: 535
2
I tried data A;
set A;
if first.pet then pet=pet;
else pet= '';
run;
it doesn't work