topic Hi Need to Transpose and add labels from an existing variable in SAS Programming

Hi Need to Transpose and add labels from an existing variable

biglerc — Wed, 28 Oct 2020 15:48:14 GMT

Hi everyone,

I have been struggling with this for a couple days, so hope somebody out there has done this before.

I have a dataset that is currently vertical, and I want to transpose it to be horizontal. That's no problem with PROC TRANSPOSE. The tricky part is that after the data is transposed, I need to assign labels to the new variables from a field that existed in the initial data.

Currently I have something like this:

variable_name field_label

INV Physician

INST Institution

I have transposed the dataset to this:

INV INST

Dr Joe Hospital1

Dr Jane Hospital2

What I am not sure how to do is assign the values from field_label to the INV and INST variables after the transpose. I have 397 rows in the intial dataset, and it can change in the future, so I really want to be able to do this dynamically.

Any suggestions?

Thanks!

Re: Hi Need to Transpose and add labels from an existing variable

Reeza — Wed, 28 Oct 2020 15:52:46 GMT

IDLABEL option in PROC TRANSPOSE.

proc transpose data=.....;
...
idlabel field_label;
...
run;

@biglerc wrote:

Hi everyone,

I have been struggling with this for a couple days, so hope somebody out there has done this before.

I have a dataset that is currently vertical, and I want to transpose it to be horizontal. That's no problem with PROC TRANSPOSE. The tricky part is that after the data is transposed, I need to assign labels to the new variables from a field that existed in the initial data.

Currently I have something like this:

variable_name field_label

INV Physician

INST Institution

I have transposed the dataset to this:

INV INST

Dr Joe Hospital1

Dr Jane Hospital2

What I am not sure how to do is assign the values from field_label to the INV and INST variables after the transpose. I have 397 rows in the intial dataset, and it can change in the future, so I really want to be able to do this dynamically.

Any suggestions?

Thanks!

Re: Hi Need to Transpose and add labels from an existing variable

biglerc — Mon, 15 Mar 2021 21:19:51 GMT

Thank you so much, Reeza! Sorry for my delay in replying!