How does the code execute in back end in Proc SQl???

Reply
Contributor
Posts: 63

How does the code execute in back end in Proc SQl???

How does the code execute in back end in Proc SQl???

In data step we have input buffer and pdv. what about in Proc SQL. Can any one let me know?

Valued Guide
Posts: 3,208

Re: How does the code execute in back end in Proc SQl???

There will be no PDV

With a remote DBMS you could get into the generated SQL sqltrace

Local you could see some of buffers of the SAS-datasets.   

---->-- ja karman --<-----
Super User
Posts: 17,899

Re: How does the code execute in back end in Proc SQl???

A database professional’s best friend - The SAS Training Post

The link above may help, but it also depends on your what's in your backend.

Are you connected to a SQL Server, if so what type? Or are you working on a desktop with native sas datasets?

Ask a Question
Discussion stats
  • 2 replies
  • 447 views
  • 0 likes
  • 3 in conversation