Adding more data through SAS

[SChander]

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,

[SAS_Cares]

Let us know if this helps!

Creating new columns: https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=p1ju3u1ef9w6pln103et2l56rtsv.htm&doc...

Data Columns: https://go.documentation.sas.com/?docsetId=proc&docsetTarget=n108rw6boklvmbn1n9fpz9jxwkyj.htm&docset...

Altering Columns:  https://go.documentation.sas.com/?docsetId=sqlproc&docsetTarget=p0rdzn3mhqxl2zn13uvxkjkt1svq.htm&doc...

[Tom]

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;