I'm about to pull my hair out over this one. 😃
I've set up the following code:
=================
LIBNAME NH3 'E:\NHANES III\DATA';
PROC SORT DATA=NH3.EXAM;
by SEQN;
PROC SORT DATA=NH3.ADULT;
by SEQN;
DATA NH3.DEMO1_NH3;
merge NH3.EXAM
NH3.ADULT;
by SEQN;
PROC CONTENTS DATA = NH3.DEMO1_NH3 varnum;
RUN;
=============================
with the following results:
120 LIBNAME NH3 'E:\NHANES III\DATA';
NOTE: Libref NH3 was successfully assigned as follows:
Engine: V9
Physical Name: E:\NHANES III\DATA
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 10:11.61
cpu time 2.11 seconds
121 PROC SORT DATA=NH3.EXAM;
ERROR: File NH3.EXAM.DATA does not exist.
122 by SEQN;
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
123 PROC SORT DATA=NH3.ADULT;
ERROR: File NH3.ADULT.DATA does not exist.
124 by SEQN;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
125 DATA NH3.DEMO1_NH3;
126 merge NH3.EXAM
127 NH3.ADULT;
ERROR: File NH3.EXAM.DATA does not exist.
ERROR: File NH3.ADULT.DATA does not exist.
128 by SEQN;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set NH3.DEMO1_NH3 may be incomplete. When this step was stopped there
were 0 observations and 0 variables.
WARNING: Data set NH3.DEMO1_NH3 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
129 PROC CONTENTS DATA = NH3.DEMO1_NH3 varnum;
130 RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
============================
As a sanity check - here is the file name info for the two files (using copypath):
E:\NHANES III\DATA\adult.dat
E:\NHANES III\DATA\exam.dat
=================
what am I doing wrong??
... View more