Help with cleaning up data set

[slivingston]

I am working with an interesting data set, however I am having difficulty cleaning it up due to certain imported formatting issues I am encountering.

The data set is expanded with multiple columns indicating response to surveys. I am trying to condense the data set columns in SAS to have responses to each question unique to each column.I am a little confused on where to start for the coding. For instance:

Data set now:
Grade
K 1 2 3 4
1
2
3
4
4

____________________
I would like to have

Grade
1
2
3
4
4

Any ideas?

I have attached a sample data set in XLS format. Any help would be greatly appreciated!

[geosun]

LESSON 3: WIDE FILE AND RESULTING TRANSPOSED NARROW FILES

support.sas.com

edit: actually no just do:

%macro create(n)
%do i=1 %to &n.;
data &i.;
set data(keep=&i.);
rename &i.=grade;
run;
%end;
%mend;
%create(12)

then merge them together with 1 to 1 reading

data all;
set 1;
set 2;
....
run;