I have a dataset
columns: A B C D
APPLE BALL 123 .
APPLE BALL . 123
I WANT AN OUTPUT TO BE LIKE FOLLOWING
A B C D
APPLE BALL 123 123
How can I solve this in single step ? Thanks
If it takes just column A to determine a unique observation:
data want;
update have (obs=0) have;
by a;
run;
If it takes the combination of both columns A and B, switch to:
data want;
update have (obs=0) have;
by a b;
run;
In any case, the data need to be in sorted order to be allowed to use the BY statement.
If it takes just column A to determine a unique observation:
data want;
update have (obs=0) have;
by a;
run;
If it takes the combination of both columns A and B, switch to:
data want;
update have (obs=0) have;
by a b;
run;
In any case, the data need to be in sorted order to be allowed to use the BY statement.
I figured out a way. Thank you.
@purveshrana for completion, please post the solution or mark one here as correct.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.