topic PROC SQL OR TABULATE in SAS Procedures

PROC SQL OR TABULATE

JasonNC — Fri, 09 Mar 2012 17:13:05 GMT

Hi,

I mostly do my claculations in Proc Sql but it takes some good amount of steps.I came to know that we can use Proc Tabulate.I just want to know which is the better way and which takes less time if i have huge data.Any suggestions will be appreciated.

PROC SQL OR TABULATE

Augusto — Fri, 09 Mar 2012 17:17:56 GMT

Hi JasonNC

Could you please share your Proc Sql code for we suggest a better solution to you?

Augusto.

PROC SQL OR TABULATE

PGStats — Fri, 09 Mar 2012 17:18:23 GMT

If your data is already sorted as expected by PROC TABULATE then the procedure is quite efficient and can save YOU a lot of time and effort. At least, that's my experience.

PROC SQL OR TABULATE

Haikuo — Fri, 09 Mar 2012 17:34:48 GMT

Efficiency wise, I also suggest you take a look into hash object. After SAS 9.2, Hash is capable to do lots of summary and does support non-unique key.

Regards,

Haikuo

PROC SQL OR TABULATE

Reeza — Fri, 09 Mar 2012 18:46:36 GMT

Depends on what you're calculating.

If you need distinct counts of something SQL will give that you more easily, perhaps HASH as well, but I'm not familiar with that.

Otherwise tabulate is very convenient, but proc means and summary also do very nice summaries. You can also look into the ODS tables to get more customizable output.

PROC SQL OR TABULATE

ballardw — Fri, 09 Mar 2012 20:33:44 GMT

I generally think of SQL for data manipulation and TABULATE for data presentation.

Suppose I want to display some test results with nested leveles of display such as a region and subregions for rows and age-group and gender for columns and cells to represent mean and stand deviation of test scores.

Tabulate will do that quite nicely and present it in a pretty nice looking table. Adding in the ability to group and display data using MULTILABLE formats and/or forcing all formatted values of variables to appear if desired it gets pretty powerful.

You can get output from tabulate but in my experience it is an odd day when I need to.