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
The FINFO function can be used to gain a number of file attributes from the Windows file system.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
FINFO,
Filepath,
DOPEN,
DREAD,
DCLOSE,
FOPEN,
FCLOSE,
SAS 9.4,
DNUM;
Posted
July, 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
If we have data that follows a repeating pattern, it is possible to manipulate that data using only the observation number.
Read more...
Posted in
SAS Programming;
Tagged
Base SAS,
MOD Function,
Subsetting,
MODULO;
Posted
June, 2017
by
Amadeus Technical Team
User-written functions created using Proc FCMP can be recursive i.e. they can call themselves. Here is a simple example: a subroutine that changes any number of consecutive commas in a...
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Proc FCMP,
DECOMMA,
Recursive Functions,
Subroutine,
PROC format;
Posted
April, 2017
by
Amadeus Technical Team
This document outlines how to grid enable a SAS program. It also makes recommendations for when to do so, as well as the advantages.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
Grid Enabling,
SAS/GRID;
Posted
March, 2017
by
Amadeus Technical Team
In an age where secure transfer of data becomes increasingly important, we regularly find ourselves being asked to retrieve data via Secure File Transfer Protocol (SFTP).
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming,
SFTP Site;
Posted
March, 2017
by
Amadeus Technical Team
Creating reports that show monetary values is one of the most common tasks that any organisation needs to perform when it comes to prepare a report.
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 2017
by
Amadeus Technical Team
We often use the WHERE option on our input data sets – but did you know you can use it on output datasets too?
Read more...
Posted in
SAS Programming;
Tagged
SAS Programming;
Posted
February, 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