I swear I don't why people resort to excel when they have access to SAS . Aside from the ugly code, the answer is within a couple of lines of modifications: FILENAME f TEMP; * allocate a temporary file ; DATA FINAL_Last1 (KEEP=Summing); SET FINAL_Last; FILE f; * write to temporary file ; Summing= Z1s||y1s||X1||Z2s||y2s||Z3s||X2||Z4s||y3s||Z5s||X3||y4s||Z6s; PUT 'eval=' summing $QUOTE. ';' summing= '; OUTPUT;'; * write this out ; RUN; PROC FSLIST FILEREF=f; RUN; * this is so you can look at the code ; DATA results; * data set with the answer ; %include f; * this includes the code we're going to write ; RUN;
... View more