vchfurereyt

‎02-08-2018

Calcite | Level 5

Member since

1 Posts
3 Likes Given
0 Solutions
0 Likes Received

Follow vchfurereyt

How do I combine multiple numeric columns into one?

6576

‎01-24-2018 11:48 AM

Activity Feed for vchfurereyt

Liked Re: How do I combine multiple numeric columns into one? for art297. ‎01-24-2018 12:34 PM
Liked Re: How do I combine multiple numeric columns into one? for PeterClemmensen. ‎01-24-2018 12:34 PM
Liked Re: How do I combine multiple numeric columns into one? for Astounding. ‎01-24-2018 12:34 PM
Posted How do I combine multiple numeric columns into one? on SAS Enterprise Guide. ‎01-24-2018 11:48 AM

Posts I Liked

Subject

Likes

Author

Re: How do I combine multiple numeric columns into one?

Re: How do I combine multiple numeric columns into one?

Re: How do I combine multiple numeric columns into one?

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.

Likes given to

User

Likes Count

Online Status	Offline
Date Last Visited	‎02-08-2018 01:06 PM