Re: SAS and BI: getting the variable rules by obs

LineMoon · Posted 09-30-2015 06:29 PM

I have a sas data toto.

==> It contains the variables: V1, V2, ....Vn, W

==> I want to get the rule of W, I know that W can be

From obs = 1 to u

w= Vi+Vj*Vm+Vg+.....

From obs=u+1 to n

w=e*Vp*Vy+Vh

.................

I am looking for an automatic solution to identify the rules of the variable W for every observation.

Thank you

Quentin · Posted 10-01-2015 09:48 AM

It's not clear to me what you want. I suggest you add a sample dataset (maybe with just V1 V2 V3 W, and about 10 observations), and the solution you would want from that dataset.

BASUG is hosting free webinars Next up: Mark Keintz presenting History Carried Forward, Future Carried Back: Mixing Time Series of Differing Frequencies on May 8. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

LineMoon · Posted 10-01-2015 06:43 PM

I want to extract the rules of W by observations

Quentin · Posted 10-01-2015 07:18 PM

Sorry, still not clear to me what you mean by that. Again, I think showing some example data and desired result might help.

BASUG is hosting free webinars Next up: Mark Keintz presenting History Carried Forward, Future Carried Back: Mixing Time Series of Differing Frequencies on May 8. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

SAS and BI: getting the variable rules by obs