BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
hhchenfx
Barite | Level 11

Hi,

I use the sashelp.stocks as the input file and I want to run regression of

Close = Volume

For a given day, say 27Feb2023, I want to run this regression on 30 rows including 27Feb2023.

The output I want to have is date, stock, predicted value and residual value as in the code below.

Can you please help?

Thank you,

HHC

proc reg noprint data=sashelp.stocks outest=want_test;
by stock;
    model close = volume;
    output out=want (keep = stock date predicted residual) p=predicted r=residual;
run;
quit;

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
hhchenfx
Barite | Level 11

Thanks for you suggestion.

 

proc sort data=sashelp.stocks out =have ; by stock descending date;run;

data have; set have ;
by stock;
if first.stock then n=0;
n+1;
run;

proc sql;
create table full
as select a.stock, a.date , b. date as _date, b.close, b.volume
from have as a left join have as b
on a.stock=b.stock and a.n<=b.n<=a.n+30
order by a.stock,  a.date , b.date;
quit;

proc reg noprint data=full outest=want_test;
by stock date;
    model close = volume;
    output out=want (keep = stock date predicted residual) p=predicted r=residual;
run;
quit;

View solution in original post

2 REPLIES 2
hhchenfx
Barite | Level 11

Thanks for you suggestion.

 

proc sort data=sashelp.stocks out =have ; by stock descending date;run;

data have; set have ;
by stock;
if first.stock then n=0;
n+1;
run;

proc sql;
create table full
as select a.stock, a.date , b. date as _date, b.close, b.volume
from have as a left join have as b
on a.stock=b.stock and a.n<=b.n<=a.n+30
order by a.stock,  a.date , b.date;
quit;

proc reg noprint data=full outest=want_test;
by stock date;
    model close = volume;
    output out=want (keep = stock date predicted residual) p=predicted r=residual;
run;
quit;

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 391 views
  • 1 like
  • 2 in conversation