Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SAS Reporting
Mike, I've been using SAS in a mainframe environment for the last 15 years
and its a great reporting tool in the hands of a programmer or a "power
user". It has extensive cross tabulation capabilities - it's PROC TABULATE
is a bit hairy to learn but once you get the hang of it you'll love it. PROC
SUMMARY is another that you should look at. Procedural logic and multiple
result sets are well catered for. I haven't used it against Oracle so can't
comment on that aspect.
>We are investigating the idea of using SAS to report against Oracle
>and other databases and would appreciate your thoughts on the idea.
>
>The reporting requirements we anticipatie using SAS to accomplish
>are fairly complex, high volume production reports, requiring
>procedural logic, involving the use of more than one result set,
>and are more of a "crosstab" format than simple listings.
>
>Programmer types will be developing the SAS reports as opposed to
>end-users. We do not anticipate using SAS as an adhoc query tool
>in any way.
>
>SAS would be running on a host on some deployments,
>while other sites will have SAS running on client machines
>accessing host data.
>
>In general, how would say SAS compares to other
>tools to report against various databases?
>
>Thanks in advance, Mike
>mdipardo_at_soli.inav.net
>
>
Received on Fri Jan 12 1996 - 15:41:18 CST
![]() |
![]() |