topic Re: standard deviation of ROA with a rolling window of the past five years in SAS Programming

standard deviation of ROA with a rolling window of the past five years

joon1 — Tue, 19 Mar 2019 05:24:27 GMT

Dear Madam/Sir,

I would like to construct standard deviation of ROA with a rolling window of the past five years.

After referring several comments in this forum, I made the following command and had the error messages.

proc sql;

create table m24 as select *, (std(a.roa) from have where a.fyear between

a.fyear-6 and a.fyear-1 and a.gvkey) from m23 as a;

quit;

Any of your help will be highly appreciated.

Sincerely,

Joon

Re: standard deviation of ROA with a rolling window of the past five years

PeterClemmensen — Tue, 19 Mar 2019 06:54:26 GMT

What errors does the code generate?

Re: standard deviation of ROA with a rolling window of the past five years

joon1 — Tue, 19 Mar 2019 14:29:26 GMT

The error messages are as follows:

proc sql;

497 create table m24 as select *, (std(a.roa) from have where a.fyear
between

----

79

498 a.fyear-6 and a.fyear-1 and a.gvkey) from m23 as a;

-

22

76

ERROR 79-322: Expecting a ).

ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *,
**, +, -, /, <, <=,

<>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE,
GET, GROUP, GT, GTT,

HAVING, IN, INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET,
NOT, NOTIN, OR, ORDER,

OUTER, UNION, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

Re: standard deviation of ROA with a rolling window of the past five years

ballardw — Tue, 19 Mar 2019 22:08:15 GMT

Please post LOG results in a code box opened using the forum's {I} icon. As you can see the forum reformats text making the diagnostics from the error message move and making it very hard to read.

Also it should cut down on the extra blank lines.

The underscore characters should appear under where SAS detects the error.

Re: standard deviation of ROA with a rolling window of the past five years

joon1 — Wed, 20 Mar 2019 14:52:51 GMT

Thank you so much for your response

I have attached the word file containing the error log. Your advice will be highly appreciated.

Thanks

Joon