Proc FCMP has been available to DATA step programmers since SAS version 9.2 and is recognised as a very valuable procedure for generating user defined functions.
Read more...
Posted in
SAS Analytics;
Tagged
SAS Analytics,
SAS Visual Analytics,
Proc FCMP,
Proc SQL;
Posted
October, 2017
by
Amadeus Technical Team
If your SAS environment regularly interacts with SQL databases via ODBC/OLE DB pre-assigned libraries, a common complaint may arise from your SQL DBA team. By default, when a SAS user...
Read more...
Posted in
SAS Administration;
Tagged
SAS SQL,
SAS Administration,
Proc SQL,
Database Connection Management;
Posted
August, 2017
by
Amadeus Technical Team
The following examples demonstrate the basic syntax required to run a SQL Stored Procedure using SAS PROC SQL.
Read more...
Posted in
SAS Programming;
Tagged
SAS SQL,
Proc SQL,
Stored Procedure;
Posted
August, 2017
by
Amadeus Technical Team
There may be occasions where it is necessary to execute a SQL server agent job from SAS. Before this can be achieved, the following prerequisites need to be met:
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
SAS SQL,
Proc SQL,
SQL Server Agent,
SQL;
Posted
July, 2017
by
Amadeus Technical Team
Merging data sets can sometimes be easier using an SQL join, particularly when you have more than two tables to merge.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
Principal Consultant Elena Muriel describes the use of SAS Dictionary tables within the Proc SQL procedure and the DATA step environment.
Read more...
Posted in
SAS Programming;
Tagged
Proc SQL,
SAS Dictionary Tables,
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
Pass-through mode in Proc SQL is most often used to improve efficiency, but that is not the only benefit it can bring.
Read more...
Posted in
SAS Data Management;
Tagged
SAS Data Management,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
The ANY and ALL operators are Proc SQL operators which can be used to compare the result of a query expression against either ANY or ALL of the results returned...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
There are a number of possible ways to extract values from a dataset and store them in a numbered list of macro variables.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team
Among the functions you can use in Proc SQL is PRXMATCH. At a single stroke, this increases the power of the SELECT statement quite dramatically.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
SELECT Statement,
Proc SQL;
Posted
February, 2017
by
Amadeus Technical Team