topic Re: proc transpose problem in New SAS User

proc transpose problem

PierreYvesILY — Tue, 30 Jun 2020 11:06:03 GMT

hello,

I have the following type of dataset:

I would like to transpose the column VERWEND_ZWECK_CLUSTER to obtain a table:

here are the values of the Column 'Quote' used as values for each VERWEND_ZWECK_CLUSTER value, which are used as column names in the target dataset.

How can I proceed?

thanks in advance

Kurt_Bremser — Tue, 30 Jun 2020 11:21:51 GMT

Sort by the first three variables, and use those in the BY statement of PROC TRANSPOSE.

Use quote in VAR, and verwend_zweck_cluster as ID.

PierreYvesILY — Tue, 30 Jun 2020 12:31:53 GMT

thank you Kurt, case solved.