Learning SAS? Welcome to the exclusive online community for all SAS learners.

How to implement nodupkeys using proc sql

Reply
Occasional Contributor
Posts: 17

How to implement nodupkeys using proc sql

Hi Experts,

How can I implement nodupkeys option that is available in proc sort in proc sql.

If I use distinct keyword for the Key Variable then only that variable is seen on the output screen. How can I display the entire observation for that key variable.

I have implemented nodupkeys option in data step using first.variable & last.variable option.

Please help.

PROC Star
Posts: 7,492

Re: How to implement nodupkeys using proc sql

Posted in reply to gurpreetkaur

Take a look at:

Ask a Question
Discussion stats
  • 1 reply
  • 288 views
  • 0 likes
  • 2 in conversation