Joining Data without blank line where data doesn't match

mmagnuson — Mon, 17 Dec 2018 14:50:53 GMT

Hello,

There are different string variables from different months of data that I'm trying to pull to create one sheet of data where there aren't duplicate rows of data. When I do this through a case statement or joining data a blank row shows up for where it does not agree. For example, if someone has two different managers in October and November I want the employee to show only one row of data and have an "October Manager" column and a "November Manager" column. I know that when using numbers you can simply sum the info but with string variables it's proving to be more challenging. I've included a picture that will hopefully shed some light on what I'm looking for.

Thanks for any help.

Re: Joining Data without blank line where data doesn't match

RW9 — Mon, 17 Dec 2018 15:04:18 GMT

Read the data into SAS. Use retain variables to create retain values on the manager columns (or you could transpose the data, sort not missing, then transpose again. Or in fact merge the non-missing row to non-missing row). Then join the data. Then output again. Plenty of examples on here already on how to line up data. If you provide test data in the form of a datastep of all the relevant datasets, I can supply some code, but not here to type in test data.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

topic Re: Joining Data without blank line where data doesn't match in SAS Enterprise Guide

Joining Data without blank line where data doesn't match

Re: Joining Data without blank line where data doesn't match