SAS (language)

See also: SAS

The process control language of SAS is a computer programming language of fourth generation (L4G) published by SAS Institute. Acronym SAS comes from " Statistical Analysis System". There has existed for more than thirty years.

Currently (since 2004), SAS is with version 9, which corresponds to a major change in the software because it integrates a new conceptual brick intended to be established in the world of the software of decisional Informatique.

It is thus necessary to dissociate SAS Foundation which represents L4G only and SAS BI, which integrates specific applicatifs.

SAS Foundation (or SAS V9)

The traditional software is composed of a whole of modules making it possible to meet the following needs by the programming:

  1. Creation and management of analytical databases

  2. Treatments of the databases
  3. Creation and diffusion of listing and summarys report.

L4G has done nothing but grow rich for 30 years without modifying the code since. The advantage is that the programs are always carried out since creation, but no standardization could be brought.

The modules Foundation are the following:

Delivered obligatorily during the hiring:

  • Base SAS
  • SAS Undertaken Guide (richer Windows interface allowing to exploit " Wizards" rather than the seizure of code)

According to the needs:

  • OLAP (to generate cubes within the framework of a use of MOLAP)
  • SAS/ACCESS (1 specific module by Database)
  • SAS/FSP (for the creation of interface)
  • SAS/ASSIST
  • SAS/CONNECT (for work into customer-server)
  • SAS/GRAPH (to create graphs)
  • SAS/IML (allowing to code linear algebra)
  • SAS/STAT (giving access to all the statistical procedures)
  • SAS/ETS (giving access to all the procedures of temporal analysis)

Language SAS is based of three parts:

The stages DATED. They make it possible to meet the needs corresponding to creation and management for databases, fundamental brick of any information system. A stage creates or modifies a table of observations. In column are generally an identifier and indicators and in lines, the subjects observed. For example, a table can contain the list of the customers of a bank.

The Procedures have each one their objective: one makes it possible to sort a table, the other to count the lines or to synthesize the indicators… or simply to print the table or a sample.

The MACRO language is a language making it possible to automate the treatments.

It is available under MVS, UNIX, LINUX and Microsoft Windows.

SAS BI (or SAS 9)

The offer of SAS 9 makes it possible at SAS to provide applicatifs LTE and of reporting WEB. In all the cases, the applicatif one consists of an graphical interface (workshop).

SAS Data Integration Studio is an offer on brick LTE of the decisional chain. The workshop makes it possible to conceive a whole of tasks for the creation of an information system.

SAS Web Carryforward Studio makes it possible to conceive a whole of reporting accessible by the Web.

Example of code SAS

The stage DATED following made a copy from dated set " origine" towards " copie" by taking only the observations which answer clause WHERE: Copy DATED; SET origin; WHERE sale > 100000; RUN; The stage is included/understood in the following way:

CREATE the TABLE copies; BY READING origin; Where the SALES ARE HIGHER than 100000; CARRY OUT;

The following procedure exports the data towards a file xls: PROC DATA=Copie EXPORT OUTFILE= " C:\temp\copie.xls " DBMS=EXCEL REPLACES; SHEET=" NomDeLaSheet" ; RUN; The macro following one optimizes the procedure of importation into important same file xls the sheet vente1 vente2 vente3 vente4: %macro brol (max); %do i= 1% to max; PROC IMPORTATION OUT= WORK.origine DATAFILE= " U:\temp\origine.xls " DBMS=EXCEL REPLACES; SHEET=" vente&i" ; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %end; %mend; %brol (4)

See too

Internal bond

  • R free software of statistical analysis.

External bond

  • company SAS
  • company SAS

Random links:Chemical nickel-plating | Hugot | Russian communist left | Link rail | Bruno Bazile | Columbiana,_Alabama