BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
xiaolufan
Calcite | Level 5

at line 84, there are two errors that variables not found, how to fix this problem?

alos, how to make a proc sgplot order with two scatters, which is first scatter - x=residual1 y=education; second scatter - x=predicted1 y=education;

 

 

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 filename PS4SAS '/folders/myfolders/Econ';
57 /* Establish an extra library named PS4SAS in the Econ folder of My Folders. */
58 data mydata;
59 infile '/folders/myfolders/Econ/nlsextract.raw';
60 input age married education central south indcode occcode union experience tenure hours weeks wage smsa;
61 /* Attach an external file of demographic and workplace variables. */
 
NOTE: The infile '/folders/myfolders/Econ/nlsextract.raw' is:
Filename=/folders/myfolders/Econ/nlsextract.raw,
Owner Name=sasdemo,Group Name=sas,
Access Permission=-rw-rw-r--,
Last Modified=18Oct2016:15:16:14,
File Size (bytes)=40752
 
NOTE: 566 records were read from the infile '/folders/myfolders/Econ/nlsextract.raw'.
The minimum record length was 68.
The maximum record length was 72.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.MYDATA has 283 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.02 seconds
 
62 proc means;
 
63 /* Get the mean of the education variable is 12.85159. */
 
NOTE: There were 283 observations read from the data set WORK.MYDATA.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.10 seconds
cpu time 0.10 seconds
 
64 proc freq;
 
65 tables married;
66 /* For married, there is 36.75% for 0; 63.25% for 1, which is married, and no value was missing for married, total 283
66 ! observations. */
 
NOTE: There were 283 observations read from the data set WORK.MYDATA.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.05 seconds
cpu time 0.05 seconds
 
67 data mydata; set mydata;
 
68 experience2=experience*experience;
69 /* Get the new variable which is the square of experience variable. */
70 if wage gt 0 then lnwage=log(wage);
71 /* Get the new variable which is the log of the wage variable.*/
 
NOTE: There were 283 observations read from the data set WORK.MYDATA.
NOTE: The data set WORK.MYDATA has 283 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
 
72 data mydata; set mydata;
 
73 if hours ge 25;
74 /* Restrict the average hours of a week greater or equal 25. */
 
NOTE: There were 283 observations read from the data set WORK.MYDATA.
NOTE: The data set WORK.MYDATA has 240 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
 
75 proc sgplot data=mydata;
 
76 scatter x=education y=lnwage;
77 /* Because I use the MacBook SAS university edition, it does not support statement 'proc gplot; plot lnwage*education;'
77 ! therefore, I use sgplot to instead of the 'gplot' statement. */
 
78 proc reg data=mydata;
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.27 seconds
cpu time 0.16 seconds
 
NOTE: There were 240 observations read from the data set WORK.MYDATA.
 
79 model lnwage = education;
80 output r=residual1;
81 output r = residual1 p = predicted1;
 
NOTE: The data set WORK.DATA21 has 240 observations and 17 variables.
NOTE: The data set WORK.DATA22 has 240 observations and 18 variables.
NOTE: PROCEDURE REG used (Total process time):
real time 1.77 seconds
cpu time 0.86 seconds
 
82 proc print data=mydata;
 
 
NOTE: There were 240 observations read from the data set WORK.MYDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.41 seconds
cpu time 1.38 seconds
 
83 proc sgplot data=mydata;
 
84 scatter x=residual1 y=education;
ERROR: Variable RESIDUAL1 not found.
85 scatter x=predicted1 y=education;
ERROR: Variable PREDICTED1 not found.
86 run;
 
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SGPLOT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
 
87
88 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
100
1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

The variables residual1 , prdeicted1 are created by proc reg (log line 78) with input mydata, output data21 and data22;

 

The ERROR mesage relates to proc sgplot (log line 83) with input mydata.

 

To fix the error choose one of the above output datasets (dtata21 or data22).

 

View solution in original post

1 REPLY 1
Shmuel
Garnet | Level 18

The variables residual1 , prdeicted1 are created by proc reg (log line 78) with input mydata, output data21 and data22;

 

The ERROR mesage relates to proc sgplot (log line 83) with input mydata.

 

To fix the error choose one of the above output datasets (dtata21 or data22).

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1188 views
  • 0 likes
  • 2 in conversation