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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.