Hi everyone, I started using SAS 9.3 just today so if this is a funny question for you it is not for me I am trying to merge data from 2 different sheets in an excel file( I managed to import them to SAS). Below is my code and the error I got. Could you please help me fix it? Thanks, PROC IMPORT OUT= study4s DATAFILE= "C:\Users\sbaskentli\Desktop\Dr.Chugani_SAS\study4s.xls" DBMS=EXCEL REPLACE; SHEET="ut"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run; PROC IMPORT OUT= study4s2 DATAFILE= "C:\Users\sbaskentli\Desktop\Dr.Chugani_SAS\study4s.xls" DBMS=EXCEL REPLACE; SHEET="mturk"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run; /*Merging Data by Subject*/ proc sort data=ut; by uniqueid; proc sort data=mturk; by uniqueid; data combined; merge ut mturk; by uniqueid; run; ERROR I GOT: 22 /*Merging Data by Subject*/ 23 proc sort data=ut; by uniqueid; ERROR: File WORK.UT.DATA does not exist. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 24 proc sort data=mturk; by uniqueid; ERROR: File WORK.MTURK.DATA does not exist. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 25 data combined; 26 merge ut mturk; ERROR: File WORK.UT.DATA does not exist. ERROR: File WORK.MTURK.DATA does not exist. 27 by uniqueid; 28 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.COMBINED may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more