https://communities.sas.com/t5/New-SAS-User/Reformatting-data-within-a-data-step/m-p/518590#M3587 <PRE><CODE class=" language-sas">data have; input id reading spelling math science; cards; 1 45 38 31 42 ; proc transpose data=have out=want(rename=(_name_=Type col1=score)); by id; var reading--science; run; </CODE></PRE> Tue, 04 Dec 2018 21:47:05 GMT novinosrin 2018-12-04T21:47:05Z https://communities.sas.com/t5/New-SAS-User/Reformatting-data-within-a-data-step/m-p/518587#M3586 <P>I'm very new to sas and I'm having quite a bit of trouble with reformatting a data set I have.&nbsp;</P><P>&nbsp;</P><P>I'm using a small data set that contains an id number and then scores for reading, spelling, math, science. The first line of the data set is set up as follows:</P><P>&nbsp;</P><PRE>id reading spelling math science 1 45 38 31 42</PRE><P>I would like to reformat it using a data step to look like this:&nbsp;</P><PRE>id type score 1 reading 45 1 spelling 38 1 math 31 1 science 42</PRE><P>Thank you for any advice in the right direction!</P> Tue, 04 Dec 2018 21:40:30 GMT https://communities.sas.com/t5/New-SAS-User/Reformatting-data-within-a-data-step/m-p/518587#M3586 smilegirl01 2018-12-04T21:40:30Z https://communities.sas.com/t5/New-SAS-User/Reformatting-data-within-a-data-step/m-p/518590#M3587 <PRE><CODE class=" language-sas">data have; input id reading spelling math science; cards; 1 45 38 31 42 ; proc transpose data=have out=want(rename=(_name_=Type col1=score)); by id; var reading--science; run; </CODE></PRE> Tue, 04 Dec 2018 21:47:05 GMT https://communities.sas.com/t5/New-SAS-User/Reformatting-data-within-a-data-step/m-p/518590#M3587 novinosrin 2018-12-04T21:47:05Z