topic Re: A code to create a new variable in Statistical Procedures

A code to create a new variable

Almutairi — Tue, 01 Sep 2020 08:39:30 GMT

Hi,

Kindly, I would like to create a code that measures sales volatility (SalesVol) which is computed as the standard deviation of annual sales (sales) divided by the average total assets (AvgTA) over the prior seven years (requiring at least three non-missing observations).

Your assistance is highly appreciated.

Re: A code to create a new variable

PeterClemmensen — Tue, 01 Sep 2020 09:34:40 GMT

What does your data look like? What have you tried already?

Re: A code to create a new variable

Almutairi — Wed, 02 Sep 2020 10:20:08 GMT

I managed to calculate the average but failed to do the standard deviation of the new variable (SalesVol) over the previous seven years (requiring at least three non-missing observations). I am attaching a sample of my data.

proc sort data=data1; by ID year; run;

proc sort data=data1; by id year;

data data1 (compress=yes); set data1; by ID year;

n+1;

if first.id then n=1;

lag_TA = lag(TA);

if n = 1 then do; lag_TA =.; end;

AvgTA = (TA+ lag_TA)/2;

SalesVol = sales/ AvgTA;

Run;

Re: A code to create a new variable

Almutairi — Sun, 06 Sep 2020 07:22:34 GMT

Hi,

I still have not received an answer to my question. Can anyone help, please?

Re: A code to create a new variable

Kurt_Bremser — Sun, 06 Sep 2020 08:19:14 GMT

Start by providing usable example data in a data step with datalines, so we can recreate your data with a simple copy/paste and submit. Excel spreadsheets tell us nothing about column attributes, and are not downloadable in corporate environments where security measures block them.