topic Re: How do I create a simulated data set with a y variable with slope and intercepts? in SAS Programming

How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 22:55:47 GMT

I am trying to make a simulated data set for x and y. I was able to create the x but am having trouble making the y. Where I am stuck is there is an intercept between 5 and 10 and a slope between 10 and 20.The below is the code I have used to create x and what I have as a base to create y.

the exact question is:

The variable y should be a linear function of x with an intercept between 5 and 10 and a slope between 10 and 20. Please

note that the intercept and slopes are constants.

data norm4 (keep=x);
call streaminit(0);
do i=1 To 20;
x= rand("uniform");
output;
end;
run;

proc reg;
model y=mx+b;
do m=10 To 20 b=5 To 10;
run;

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:23:29 GMT

@fanellm1 wrote:

I am trying to make a simulated data set for x and y. I was able to create the x but am having trouble making the y. Where I am stuck is there is an intercept between 5 and 10 and a slope between 10 and 20.The below is the code I have used to create x and what I have as a base to create y.

the exact question is:

The variable y should be a linear function of x with an intercept between 5 and 10 and a slope between 10 and 20. Please

note that the intercept and slopes are constants.

data norm4 (keep=x);
call streaminit(0);
do i=1 To 20;
x= rand("uniform");
output;
end;
run;

So, y is a function of x. The formula is y=intercept + slope * x

In your data step, you need to program this. Give it a try.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:27:52 GMT

Thanks Paige!

Do I then need to define the slope and intercept somewhere?

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:30:19 GMT

Yes or no. Either. Depends on what you mean by "define". Give it a try.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:33:22 GMT

Paige,

This is what I tried:

data norm4 (keep=x);
call streaminit(0);
do i=1 To 20;
x= rand("uniform");
output;
end;
run;

but am getting the error:

ERROR 12-63: Missing '=' for option KEEP.

ERROR 22-7: Invalid option name Y.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:36:29 GMT

Show us the actual SAS log, the entire log, not just the error messages. Please click on the {i} icon and paste your log as text into that window, this maintains the spacing and formatting in the log and makes it easier for us to view and understand.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:38:27 GMT

Paige,

Here is the log window:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data norm4 (keep y=intercept+slope*x);

____ _

12 12

ERROR 12-63: Missing '=' for option KEEP.

ERROR 22-7: Invalid option name Y.

74 call streaminit(0);

75 do i=1 To 20;

76 x= rand("uniform");

77 do intercept=5 TO 10;

78 do slope=10 To 20;

79 output;

80 end;

81 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

83 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:39:34 GMT

Please click on the {i} icon and paste your log as text into that window, this maintains the spacing and formatting in the log and makes it easier for us to view and understand.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:41:55 GMT

The "I" icon where and paste it into what window?

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:45:54 GMT

It's in the icon bar when you type your message, sixth from the left.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:47:41 GMT

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data norm4 (y=intercept+slope*x);
                        _
                        22
 ERROR 22-7: Invalid option name Y.
 
 74         call streaminit(0);
 75         do i=1 To 20;
 76         x= rand("uniform");
 77         do intercept=5 TO 10;
 78         do slope=10 To 20;
 79         output;
 80         end;
 81         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 82         
 83         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 95

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Fri, 06 Sep 2019 23:55:16 GMT

So you have some basic programming errors here.

You can't put programming or mathematics in DATA statement itself.

The formula to compute Y has to go after x, intercept and slope are mentioned, otherwise the formula can't be evaluated.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:56:19 GMT

Paige,
I am not sure how to mention x, intercept and slope.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

fanellm1 — Fri, 06 Sep 2019 23:57:22 GMT

Do I have to use the proc reg function first?

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PaigeMiller — Sat, 07 Sep 2019 00:03:02 GMT

@fanellm1 wrote:

Paige,
I am not sure how to mention x, intercept and slope.

but your code did mention x intercept and slope.

Do I have to use the proc reg function first?

No you are not computing a regression here.

Re: How do I create a simulated data set with a y variable with slope and intercepts?

PGStats — Sat, 07 Sep 2019 04:21:56 GMT

Are you saying that you want 6x11 = 66 sets of data points, one set for every combination of slope and intercept? Should the Ys have some error (noise) added to them?