Proc SQL

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Proc SQL

In SAS , Mainly Data Step Works on Program Data Vector ( PDV) .

 

In SAS , Then how Proc SQL Works ( backend Operations) ?


Accepted Solutions
Solution
4 weeks ago
Super User
Super User
Posts: 9,599

Re: Proc SQL

Posted in reply to saikiran_nemani

In SAS , Mainly Data Step Works on Program Data Vector ( PDV) .

 -- In datastep, this always works using PDV

 

In SAS , Then how Proc SQL Works ( backend Operations) ?

  -- SAS implements a ANSI parser and compiler which you can access through a procedure.  It operates like any other ANSI SQL compiler.  You can see it processing by adding the options _tree and _method:

http://www2.sas.com/proceedings/sugi30/101-30.pdf

You will also find a lot of information in the docs:

http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#titlepage.htm

View solution in original post


All Replies
Solution
4 weeks ago
Super User
Super User
Posts: 9,599

Re: Proc SQL

Posted in reply to saikiran_nemani

In SAS , Mainly Data Step Works on Program Data Vector ( PDV) .

 -- In datastep, this always works using PDV

 

In SAS , Then how Proc SQL Works ( backend Operations) ?

  -- SAS implements a ANSI parser and compiler which you can access through a procedure.  It operates like any other ANSI SQL compiler.  You can see it processing by adding the options _tree and _method:

http://www2.sas.com/proceedings/sugi30/101-30.pdf

You will also find a lot of information in the docs:

http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#titlepage.htm

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 96 views
  • 1 like
  • 2 in conversation