Using proc transpose to transform multiple categories of a treatment variable?

[sas_user124]

Hello, so I had a variable called treatmenttype with 3 categories: medication, other, and diet. In a previous step, I used a count function to split this where there are now 3 columns, one for each treatment type. each participant had 2 of the treatment types combined, so this was splitting that out. Now, 

Using proc transpose,

how can I transform each of those treatment categories from wide to long? I want to properly name the new variables and drop what is unneccessary. Once it is done, I want there to be a new treat_type column with medication, other, diet as the option and then a y_n column incidcating whether it was used, with 1 or 0.

Please help, I am so confused

[ballardw]

At least give us the variable names and types. Better is actual example data as transpose has some tricky behaviors in some cases, like repeats of the ID variable that may cause issues.

IF the treatments are all of the same type then something like:

Proc transpose data=have out=trans;
  by id;
  var surgery medication other;
run;

MAY work.

The output if there is a single observation per ID will have variables ID _name_ and Col1 by default. _name_ would have the name of the variable as the value, Surgery Medication or Other and Col1 the value of the original value.

If you have multiple observations per ID then you need really need to provide example data and what expect the resulting output to look like as otherwise you are going to end up with multiple Col variables and that may not match what you want.