[FIXED] How do I use Proc Transpose to flip my data from several rows into columns?

Issue

I'm working with a CSV file that contains survey information. An example of the data would be this:

Original Data Example

I'm looking to write a Proc Transpose in SAS to change all of the data so it's in one row with new columns so it looks like this:

Transposed Data Example

Thanks in advance

Solution

Your TRANSPOSE should be

by Survey_ID Question_Num;
id Key_2;
var Value;

Answered By - Richard

Answer Checked By - Timothy Miller (PHPFixing Admin)