topic Re: Adding more data through SAS in New SAS User

Adding more data through SAS

SChander — Fri, 10 May 2019 17:00:34 GMT

Hi everyone,

I want to add more data columns in SAS data. Please help me out.

for example;

I have data of 13k patients, there is missing hemoglobin value in the data. How can I add new column which also match to patient's other data.

Thanks,

Re: Adding more data through SAS

SAS_Cares — Fri, 10 May 2019 17:59:37 GMT

Let us know if this helps!

Creating new columns: https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=p1ju3u1ef9w6pln103et2l56rtsv.htm&docsetVersion=9.4&locale=en

Data Columns: https://go.documentation.sas.com/?docsetId=proc&docsetTarget=n108rw6boklvmbn1n9fpz9jxwkyj.htm&docsetVersion=9.4&locale=en

Altering Columns: https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=p0rdzn3mhqxl2zn13uvxkjkt1svq.htm&docsetVersion=9.4&locale=en

Re: Adding more data through SAS

Tom — Fri, 10 May 2019 18:51:09 GMT

Where are these hemoglobin values going to come from?

Normally you would not ADD a variable to an existing dataset.

The normal way would be create a dataset that has the data for the new variable and merge the two datasets to make a NEW dataset that has the NEW structure. Make sure both datasets have the proper key variables so the values of hemoglobin are adding into the right observations of the old dataset.

So for example if your existing data is called HAVE and each row is uniquely identified by the variable PATIENT and you have created a new dataset called HEMOGLOBIN that has the new variable with the hemoglobin values and also has the PATIENT variable then you can make an new dataset called WANT that has all of the data together.

data want;
  merge have hemoglobin  ;
  by patient;
run;