Transposing rows and columns with variable names


New Member
I'm new to this forum so my apologies if this is done incorrectly. Here is my problem-
I have a SAS dataset with few columns and many rows and different types of variables. I need to literally just transpose these so that the entries in the first column become the variable names. Proc transpose will exchange the data but then the column names are col1, col2, etc instead of the variable names I need.
I also have the data in an Excel file and I tried transposing there and then importing to SAS but it will only import about 300 columns and I have around 1400.
Any help is greatly appreciated.