I have a data file that looks like this:
There are many cases where a value for the column "ActualRead" will not exist, and therefore it will be an estimated read that shows up in the "EstimatedReads" column. My question is how do I combine these two columns so that I have a single column that contains the actual reads, and replaces the missing actual reads with the estimated reads in the other column?
P.s. I am a SaS novice. I can handle some programming, but would prefer a solution in EG. Thanks.
The coalesce function will do what you want. e.g.:
data want; set have; actualreads=coalesce(actualreads,estimatedreads); run;
Art, CEO, AnalystFinder.com
data have1;
set have;
ActualReads=ifn(missing(ActualReads)=1, EstimatedReads, ActualReads);
run
Since you call yourself a novice, I thought you might want the simplest version:
data want;
set have;
if ActualReads=. then ActualReads=EstimatedReads;
drop EstimatedReads;
run;
Dropping EstimatedReads might not be a great idea, but I wasn't sure if that was part of the question or not.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.