BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Laxesh7
Fluorite | Level 6

Hello,

 

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

 

Thanks in Advance.

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

"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.

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

"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.

Laxesh7
Fluorite | Level 6
Thankyou for your answer.

This will help me i am sure.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 1394 views
  • 1 like
  • 2 in conversation