Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Programming
- /
- SAS Procedures
- /
- error: variable residual1 not fount

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 10-18-2016 08:03 PM
(935 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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).__

1 REPLY 1

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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).__

**Don't miss out on SAS Innovate - Register now for the FREE Livestream!**

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

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.