You are correct this was just the begging part of my code. Below is my working code. And this is a learning exercise. This code does work without the macro variables. Once I get to the proc SQL step below and every step after is where I would need all the following tables I described. The steps proceeding my proc SQL code also work I just had to copy the beginning part of my code and run it again for the other form. I Which almost doubled my code and made it really long. I would like to try and avoid what I am doing in the picture above my code.   /* Import Data */ /* Questions 1-2 */ %LET A = A; %LET A = B; PROC IMPORT OUT=Form&A DATAFILE="/home/brandonbayles881/EPG194/Form&A..csv" DBMS=csv REPLACE; GETNAMES=YES; RUN; PROC IMPORT OUT=Domains_Form&A DATAFILE="/home/brandonbayles881/EPG194/Domains Form&A..csv" DBMS=csv REPLACE; GETNAMES=YES; RUN; DATA Results&A; SET Form&A; Form="Form &A"; ARRAY Form&A(*) Q1-Q150 _CHARACTER_; ARRAY key(*) K1-K150 _CHARACTER_; ARRAY match(*) M1-M150 _NUMERIC_; RETAIN K1-K150; IF Student="KEY" THEN DO i=1 to 150; key(i)=Form&A(i); END; ELSE DO QuestionNum=1 to 150; IF key(QuestionNum)=Form&A(QuestionNum) THEN match(QuestionNum)=1; ELSE match(QuestionNum)=0; Scores=match(QuestionNum); OUTPUT; END; KEEP Student QuestionNum Scores Form; RUN; PROC PRINT NOOBS DATA=Results&A; RUN; TITLE "FINAL FORM"; PROC SQL; CREATE TABLE FINAL_FORM_&A AS SELECT Student, Results&A..QuestionNum, Scores, DomainNum, Form FROM Results&A INNER JOIN Domains_Form&A ON Results&A..QuestionNum=Domains_Form&A..QuestionNum; QUIT; PROC PRINT DATA=FINAL_FORM_&A; RUN; PROC SQL; CREATE TABLE COMBINED AS SELECT* FROM FINAL_FORM_A UNION ALL SELECT * FROM FINAL_FORM_B; Format Student 9.; QUIT; PROC PRINT DATA=COMBINED; RUN; PROC MEANS DATA=COMBINED MEAN SUM NONOBS; VAR Scores; CLASS Student DomainNum; ID Form; OUTPUT OUT=COMBINED_TABLE (DROP=_TYPE_ _FREQ_) SUM=score MEAN=Student_Percentage; RUN;   ... View more

Thank you for the tip. Sorry, I don't think I was super clear in my description above. So in the code above, I am trying to import 4 data sets not just two separate ones. Overall when all is said and done I would like to have FORMA, FORMB, Domains_FormA, and Domains_FormB. Using what was suggested gives me Domains_FormB and FORMA as my output.  ... View more

Or should I run one and then the other? Would that give me both outputs? If I have just one Macro statement and change the variable to B for example after I run it for A? ... View more

Thanks. That makes sense. How would you fix this then so it runs both forms?   ... View more

That worked. Thank you.   ... View more