topic how to use First obs and obs option in SAS VA in SAS Visual Analytics

how to use First obs and obs option in SAS VA

Laxesh7 — Mon, 27 Nov 2017 14:43:32 GMT

Hello,

Anyone can help me how i can use first obs and obs option in SAS Visual Analytics in Query builder?

Thanks in Advance.

Re: how to use First obs and obs option in SAS VI

RW9 — Fri, 24 Nov 2017 15:33:00 GMT

"Query Builder" utilises SQL technology. SQL does not have any concept of first and last, nor in fact of observation order. You must logically find a certain row. So for instance if in a datastep you had first and last of dates within ID, and they were sorted sequentially and they were unique, the "first" row would logically be identified by date=min(date) group by id. The "last" record would be logically identified by date=max(date) group by id. It is irrelevant to the SQL parser if the "last" record appears as first, or second or anywhere in the data, only logical identification is used.

Re: how to use First obs and obs option in SAS VI

Laxesh7 — Fri, 24 Nov 2017 15:43:24 GMT

Thankyou for your answer.

This will help me i am sure.