BookmarkSubscribeRSS Feed
dash
Obsidian | Level 7
Hi all,
Can anybody tell me the difference between pass through facility and libname access method, proc report and proc tabulate. I am unabke to differentiate
Thanks in advance
3 REPLIES 3
LinusH
Tourmaline | Level 20
There are tons of papers and documentations on both these issues. The best way to figure out what to use is learning by doing.

Short: if you need for some reason (or are more familiar with) native RDBMS syntax, you need to use explicit pass thru. Libname access (implicit pass-thru) would work for most scenarios, and lets you be more flexible in what data source you are using.

For standard cross tabular reports TABULATE would be a normal choice. If you need more customization with layout, calculated values, conditional processing etc, REPORT is the tool.

/Linus
Data never sleeps
Doc_Duke
Rhodochrosite | Level 12
In addition to Linus's comments, I'd add that the SAS/Access for Relational Databases document has several hundred pages of detailed information on those two methods.

One major note, in using the (explicit) pass-through, you must write your SQL code in the syntax of the target database. In LIBNAME access to RDMS, you use SAS/SQL syntax and SAS does the translation. SAS also makes the decision as to whether to pass-thru to the DBMS or to bring the tables to the SAS server.
Ksharp
Super User
In addition to Linus's comments, I'd add that the SAS/Access for Relational Databases document has several hundred pages of detailed information on those two methods. 🙂

The most differernt with these is : Libname statement is only accept Standard SQL , but Pass thru can accept all the expansion about SQL(that means you can use tremendous SAS's functions and other facility), Libname has more efficient than Pass thru,So I recommend to use Libname especially for very large table.

About proc tabulate and proc report, proc tabulate 's best advantage is to generate lots of summary statistical estimator for lots of variable,proc report 's best advantage is to beautifully build report and have more control to report.


Ksharp

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 688 views
  • 0 likes
  • 4 in conversation