data tq84_numbers; input val 1- 2 nam $ 4- 9 ; datalines; 1 one 2 two 3 three 4 four 5 five 6 six 7 seven 8 eight 9 nine ; proc sort data = tq84_numbers out = tq84_numbers_sorted; by nam; run; proc print data = tq84_numbers_sorted; run;
data tq84_ds; length num_name $ 10; num_name = "one" ; num_val = 1; output; num_name = "two" ; num_val = 2; output; num_name = "three"; num_val = 3; output; num_name = "four" ; num_val = 4; output; num_name = "five" ; num_val = 5; output; num_name = "six" ; num_val = 6; output; num_name = "seven"; num_val = 7; output; num_name = "eight"; num_val = 8; output; num_name = "nine" ; num_val = 9; output; run; proc sort data=tq84_ds; by num_name; run; proc print data=tq84_ds; run;