topic How to add a new column in existing dataset in SAS Programming

How to add a new column in existing dataset

AdityaKir — Fri, 23 Sep 2016 14:52:25 GMT

Hello,

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

data sumOut;
set work.dresssales1;
sumvar=sum(_29_8_2013,_31_8_2013);
run;

I want to add the value that is stored in sumvar to a new dataset Retail. How do I do this ?

Regards,

Aditya

Re: How to add a new column in existing dataset

ballardw — Fri, 23 Sep 2016 15:07:31 GMT

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-data-AKA-generate/ta-p/258712 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.

Re: How to add a new column in existing dataset

JaneEslinger — Wed, 30 Aug 2017 16:56:53 GMT

Without the information @ballardw asked for it is difficult to answer your question @AdityaKir. The code you provided already creates and adds a new column. However, it appears that you want to take the new variable sumvar, which is in the data set SumOut, and add it to a data set called Retail.

If SumOut contains only one record this code will add the sumvar value to every observation in Retail:

data Retail
set Retail;
if _n_=1 then set SumOut(keep=sumvar);
run;

If SumOut contains multiple records and an id variable this code will merge the sumvar value to the matching id value in Retail:

data Retail;
merge Retail SumOut(keep=id sumvar);
by id;
run;