how to add "limit 1" to SQL query

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

how to add "limit 1" to SQL query

proc sql;

  select * from blah

  limit 1;

Q: How can I limit the amount of output? Typically I add "limit 1", but that doesn't seem to work.

Thanks for reading!

jp


Accepted Solutions
Solution
‎05-02-2013 01:40 PM
Contributor
Posts: 25

Re: how to add "limit 1" to SQL query

Posted in reply to carterson2

All Replies
Solution
‎05-02-2013 01:40 PM
Contributor
Posts: 25

Re: how to add "limit 1" to SQL query

Posted in reply to carterson2

oops, I found it

sas - Limiting results in PROC SQL - Stack Overflow

proc sql outobs=1;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 911 views
  • 0 likes
  • 1 in conversation