Hi,
I have the table as below:
ID | A | B | C | D | E | F |
27 | saf | dsdf | ||||
27 | ||||||
27 | ddf | cdf | dfd |
In the above table ID is the primary Key. I need to obtain summary based upon ID and obtained like below table:
ID | A | B | C | D | E | F |
27 | saf | ddf | cdf | dfd | dsdf |
Please let me know your thought
Regards,
GK
data want;
update have(obs=0) have;
by id;
run;
data want;
update have(obs=0) have;
by id;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.