topic Re: How to calculate a division with 2 values in the same column filtered by quarters weeks SAS VA in New SAS User

How to calculate a division with 2 values in the same column filtered by quarters weeks SAS VA

Hidetsu — Fri, 03 May 2019 17:34:01 GMT

Hello, i have this problem. I need to divide vales in a column with the same values in another column filtered by a week quarter of a week of the year.

Like this:

The Weeks (Semana 15 - 11) are in numeric format.

I need it to be like that

Re: How to calculate a division with 2 values in the same column filtered by quarters weeks SAS VA

PaigeMiller — Fri, 03 May 2019 17:42:48 GMT

SAS doesn't work like Excel, where this type of division between two numbers in a column is easy.

In order for us to help you, please show us your SAS data set, preferably as a SAS data step created via this method: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Also, it seems from your screen captures, that you are talking about ROWs and not COLUMNs, could you clarify this?