Hello,
Anyone can help me how i can use first obs and obs option in SAS Visual Analytics in Query builder?
Thanks in Advance.
"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.
"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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.