At times we need to reference all the generations of a GDG and it is important to know which generation is read first if GDG base is given as input in JCL….
Author: DBZtech
ERROR: (DB2M011E) The column cannot contain missing values in SAS Mainframe
This is a typical error in SAS which occurs when a variable gets calculated, i.e. it is the result of some arithmetic expression. Furthermore if this column is used to insert in…
How to Use SYMPUT for Symbolic Variables in SAS Mainframe
SYMPUT is a routine that is called inside the data step to produce a symbolic variable, ie assigns a value produced in a DATA step to a macro variable. The variable can…
Understanding SYSPARM in SAS Mainframe
SYSPARM is an automatic variable in SAS which allows information to be passed from the operating environment to SAS program steps and it provide means of accessing or using the string while…
Input Buffer and Program Data Vector in SAS Mainframe-Print _N_ and _Error_
The Data step’s function in SAS program is to bring or format the raw data into a structure or a layout as defined in the INPUT keyword. To bring it into shape,…
Management class,Storage class,Data Class in JCL
These are the parameters which are in effect only if SMS is enabled in Z/OS Environment. These parameters of storage management subsystem(SMS) helps in simplifying JCLs, i.e., the JCL takes predefined values…
SAS Mainframe – Create PIE Chart using SAS
With the proc chart procedure, the PIE statement will create the PIECHART. The size of a pie represents the percentage that of category of data. In SAS, you can create a pie…
SAS Mainframe Tutorial: Creating Horizontal Bar Diagrams
To achieve horizontal bar diagrams, HBAR has to be used in PROC CHART statements. One feature of HBAR is that, it automatically returns the frequency, cumulative frequency, percentage, and cumulative percent to…
SAS Mainframe Tutorial: Adding Reference Lines in Bar Diagrams
In this post we will see how to add the reference lines in the bar diagrams. Continuing with the previous example, we will have reference lines at intervals 1 and 2 ,…
Generate Bar Diagrams using PROC CHART in SAS Mainframe
Using the PROC CHART option one can generate few graphs(vertical and Horizental) in mainframe or possibly print it to PDF document via the ODS option. In this post, we will see how…
SAS Mainframe Tutorial on COMPRESS and COMPBL Functions
The COMPRESS Function in SAS is used to remove specific characters from a string. In general dealing with Blanks can be challenging, but SAS provides few functions to do this efficiently. COMPRESS…
SAS Mainframe Tutorial: Reading Delimited Data using DLM and DSD
Reading input file in SAS Mainframe with delimiter option
Using CALCULATED in PROC SQL in SAS Mainframe
Creating New Variables in PROC SQL (SAS) Using the CALCULATED Keyword In PROC SQL (SAS), you can dynamically create new variables within your query and assign them a name. If a name…
How to Use PROC SQL in SAS on a Mainframe (z/OS)
When working with SAS on the mainframe, one of the most powerful tools you have is the PROC SQL procedure. Unlike traditional DATA steps or sorting workflows, PROC SQL lets you query,…
PROC SORT in SAS on Mainframe (z/OS)
Running SAS on a mainframe environment like z/OS allows you to process massive enterprise datasets with high performance. Among the most commonly used SAS procedures are PROC SORT, which help you sort,…