SAS Programming

Please download to get full document.

View again

of 55
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Similar Documents
Information Report
Category:

Arts & Culture

Published:

Views: 0 | Pages: 55

Extension: PDF | Download: 0

Share
Description
SAS Programming
Tags
Transcript
  © 2009 IBM Corporation  Z/OS SAS 9.2 Mainframe's Basic SAS Programming   Author:  Venkata Rama RajeshDB2 DBA for Z/OSvmallina@in.ibm.com © Copyright IBM Corporation, 2017  © 2009 IBM Corporation Objectives 1. Introduction2. File processing 3. SAS – File allocation 4. SAS Procedures5. Variables & Arrays6. Macros & Macro statements7. SAS – DB2 interface8. SAS – TSO interface9. SAS – REXX interface10. SAS – ISPF interface11. SAS – Z/OS functions12. E-mail through SAS  3 days3 days © Copyright IBM Corporation, 2017  © 2009 IBM Corporation Introduction - What is SAS (S tatistical Analysis System) ? The SAS is a programming language used for statistical analysis, It can read in data from common spreadsheets, datasets and databases and output can put in datasets, tables, graphs, and as HTML and PDF documents. The SAS has compilers are available in Windows, Linux, UNIX and Z/OS. How to execute SAS  //SAS01 EXEC SAS //SYSIN DD * OPTIONS NOCENTER; DATA  RAJU; YEAR = YEAR(TODAY()); MONTH = MONTH(TODAY()); DAY = TODAY() ; PROC PRINT DATA=RAJU;   Here the PROC specified at EXEC step will have SAS compiler logic. Which will used to compile and execute the SAS program coded in SYSIN © Copyright IBM Corporation, 2017  © 2009 IBM Corporation Introduction - SAS Fundamentals ● Every instruction in SAS program should by ended with semi-colon (;) ● SAS is the combination of set of global statements, DATA  and PROC steps. ● We can use data step for file reading , file processing, file writing, computing values for new variables, using SAS buit-in functions and so on. ● The names of data steps are user defined. (except _NULL_ step) ● Some of the uses of PROC step or procedure step is mentioned below  – Print variables used in data step (PROC PRINT step),  – Execute SQL statements (PROC SQL step)  – Execute TSO commands like LISTCAT (PROC IDCAMS step)  – To sort the data (PROC SORT step)  – Used to draw graphs/plots (PROC PLOT step)  – To Histograms and bar charts (PROC CHART step) ● The names of PROC steps are pre-defined. © Copyright IBM Corporation, 2017  © 2009 IBM Corporation Introduction - Sample SAS program //SAS01 EXEC SAS  //SYSIN DD * DATA  RAJU; YEAR = YEAR(TODAY()); MONTH = MONTH(TODAY()); DAY = TODAY() ; PROC PRINT DATA=RAJU; PROC PRINT output in FT12F001   → This SAS program has one data step and one PROC step  → Raju is user-defined name for the data step  → PROC PRINT step will print all the variables in data step RAJU. PROC PRINT is a special type of PROC step, which will used for print. © Copyright IBM Corporation, 2017
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x