I have an excel sheet that is structured as below. After importing, I need to get the 'Codex' values to start at Code1 for every observation. (ie. need to shift some of these to the left.) Suggestions

[uabcms]

ID	Code1	Code2	Code3	Code4	Code5	Code6	Code7	Code8
1								64721
2	36860	35465
3	45565
4			12545	45665	25785
5		12546	12562	15485	84556	24566	58585	32656
6			54545	14652

[ballardw]

Save the sheet as csv;

data want;

     infile "where you saved the csv" delimiter=',' missover;

     input id code1-code8 ;

run;

[uabcms]

That was easy.   Thanks very much.