Sie befinden sich aktuell in den Business Intelligence Blog-Archiven für den folgenden Tag 10.1.2007.
- Abstract (1)
- Geomapping (2)
- SAS Code (9)
- SAS Macros (2)
- SAS Procedures (3)
- SQL (1)
- SQL - Oracle (1)
- 26.4.2008: Export SAS data into XML File
- 18.11.2007: Import external data or files into SAS using wildcards
- 8.11.2007: SAS Enterprise Guide 4.x & Autoexec.sas
- 25.2.2007: Sample Size Calculation
- 20.1.2007: SAS: Contour Plot with PROC GCONTOUR
- 15.1.2007: SAS: Using GOTO Statement in Macro Steps
- 12.1.2007: Using email functions with SAS
- 11.1.2007: SAS: Geomapping Process (Maps based on ZIP Code)
- 11.1.2007: SAS: Import and Export Data
- 10.1.2007: Key Functions in Oracle SQL
BI News
SAS Forum
SAS Programming
Archive für 10.1.2007
Key Functions in Oracle SQL
10.1.2007 von Thomas-Degenhardt.
Here you find a really good link to a documentation for the key functions in Oracle SQL (e.g. “to_char”). The description contains the most important date, number and string functions.
Check out: Harvard Documentation
Geschrieben in SQL, SQL - Oracle | 1 Kommentar »
SAS: SQL Pass Through
10.1.2007 von Thomas-Degenhardt.
With this SAS Program you are able to connect to a database with SQL Pass Through via ODBC. The advantage is, that the SQL Statement will be processed by the resources of the database. The disadvantage is, that you cannot use SAS specific functions which are not supported by the database sql language.
–
proc sql;
connect to odbc (dsn=”…” user=”…” password=”*****”);
create table my_table as
select * from connection to odbc
(
select
…
from
…
where
…
);
disconnect from odbc;
quit;
Geschrieben in SAS Procedures, SAS Code | 1 Kommentar »