topic Re: Add observations to a variable in SAS Programming

Add observations to a variable

Malathi13 — Thu, 09 Aug 2018 20:45:57 GMT

Hi,

I need some help in adding rows (observations) of one column to the other column from the same table. I have a table with two variables (see below).

Type of call Categories

MVA Cardiac

Trauma Cardiac

No Respiratory

MVA Cardiac

NO Neuro

MVA Neuro

Trauma Cardiac

I want to add type of call to Categories so the output should look like

Type of Call Categories

No Cardiac

Cardiac

No Respiratory

Cardiac

NO Neuro

Neuro

Cardiac

MVA

Trauma

Can anybody please help me getting this output?

Thank you

Re: Add observations to a variable

mkeintz — Thu, 09 Aug 2018 21:05:42 GMT

What are the rules you wish to use to get from table1 to table2? Please explain clearly.

Re: Add observations to a variable

Malathi13 — Fri, 10 Aug 2018 14:59:00 GMT

Hi,

I'm using only one table, the two columns are from the same table and I'm trying to add observations from column1 to column2.

Re: Add observations to a variable

mkeintz — Fri, 10 Aug 2018 17:57:31 GMT

OK, so you're trying append column 1 values to column 2, but you have not explained:

Which values to append, since you have apparently excluded some.
What order you want those appended values to have
By what rule did you get an output row of "NO" and "CARDIAC"

We cant' read you mind, which is why we need clear and complete description of the task.

Also, you can help yourself if you put the starting data in the form of a sas data step, with a data set name, ,an input statement, datalines statement, and the data.