1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 /* Generated Code (IMPORT) */
74 /* Source File: nhanes_1.csv */
75 /* Source Path: /folders/myfolders/AFTER_MIDTERM/output/MIDTERM_Second */
76 /* Code generated on: 12/8/19, 12:53 PM */
77
78 %web_drop_table(PG2.IMPORT);
79 FILENAME REFFILE '/folders/myfolders/AFTER_MIDTERM/output/MIDTERM_Second/nhanes_1.csv';
80 run;
81 PROC CONTENTS DATA=WORK.IMPORT; RUN;
ERROR: File WORK.IMPORT.DATA does not exist.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.
82 PROC IMPORT DATAFILE=REFFILE
83 DBMS=CSV
84 OUT=WORK.IMPORT;
85 GETNAMES=YES;
86 RUN;
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
WARNING: Physical file does not exist, /folders/myfolders/AFTER_MIDTERM/output/MIDTERM_Second/nhanes_1.csv.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.06 seconds
cpu time 0.05 seconds
87
88 data nhanes1;
89 set mylib.nhanes;
ERROR: Libref MYLIB is not assigned.
90 keep SEQN RIAGENDR RIDAGEYR RIDRETH1 DMQMILIT DMDBORN DMDCITZN DMDYRSUS DMDEDUC2 DMDMARTL
91 INDHHINC WTMEC2YR SDMVPSU SDMVSTRA SDDSRVYR INDFMPIR BMXWT BMXHT BMXBMI HSD010 DBQ720--DBQ890;
92 run;
WARNING: The variable SEQN in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable RIAGENDR in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable RIDAGEYR in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable RIDRETH1 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMQMILIT in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMDBORN in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMDCITZN in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMDYRSUS in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMDEDUC2 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable DMDMARTL in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable INDHHINC in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable WTMEC2YR in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable SDMVPSU in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable SDMVSTRA in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable SDDSRVYR in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable INDFMPIR in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BMXWT in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BMXHT in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable BMXBMI in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable HSD010 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: Starting variable DBQ720 and ending variable DBQ890 of double-dash list do not exist.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NHANES1 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
93 /*Deleting Missing Observations*/
94 /* Example of if-then statement */
95 data nhanes2;
96 set nhanes1;
97 if nmiss( of _numeric_ ) then delete ;
_____
71
ERROR 71-185: The NMISS function call does not have enough arguments.
98 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NHANES2 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.01 seconds
99
100 proc sort data=nhanes2 out=nhanes_1 nodup nodupkey;
101 by SEQN;
ERROR: Variable SEQN not found.
102 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NHANES_1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
103
104 proc export data=nhanes_1 outfile="folders/myfolders/New/nhanes_1.csv" dbms=csv replace;
105 run;
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
NOTE: No variables in data set WORK.NHANES_1.
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.08 seconds
cpu time 0.05 seconds
106
107 proc copy in=work out=mylib;
108 select nhanes_1;
109 run;
ERROR: Libref MYLIB is not assigned.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.
110
111 proc means data=mylib.nhanes_1 mean min max;
ERROR: Libref MYLIB is not assigned.
112 var RIDAGEYR DMDYRSUS INDHHINC INDFMPIR WTMEC2YR SDMVPSU SDMVSTRA BMXWT BMXHT BMXBMI;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
113 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
114
115 proc freq data=mylib.nhanes_1;
ERROR: Libref MYLIB is not assigned.
116 tables RIAGENDR RIDRETH1 DMQMILIT DMDBORN DMDCITZN DMDEDUC2 DMDMARTL HSD010 DBQ720--DBQ890;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
117 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
118
119 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
131