09-23-2016 10:52 AM
I want to add new columns to an existing dataset. The new column should contain the data from another dataset.
Here it looks like this
I want to add the value that is stored in sumvar to a new dataset Retail. How do I do this ?
09-23-2016 11:07 AM
Do you have variables in both data sets to identify which records are supposed to align such as a product identifier, store identifier, dates or possibly multiple variables? If you have those key variables are combinations of them duplicated within one or both of the data sets?
It would be better to provide examples of BOTH data sets. This link https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... has instructions on how to make data step code to replicate the data that you can post here or attach as a TEXT file.
It is also a very good idea to provide an example of what your are looking for as a result in case your narrative description is incomplete.