Most of mainframe programmers know how and why to use ‘)’ or ‘))’ ‘((‘ as line command in dataset. But when you need to shift only specific columns in a dataset, say…
Concatenate all generations of GDGs in LIFO or FIFO
If you need to concatenate GDG generations in JCL, Mainframe developers have a straightforward way to reference all datasets within a Generation Data Group at once. However, it is critical to know…
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,…
Understanding SMS-Management Class, Storage Class, and Data Class in JCL
If you’re working in a z/OS mainframe environment, understanding Storage Management Subsystem (SMS) parameters is essential for writing efficient, clean, and maintainable JCL. When SMS is enabled, it automatically manages many dataset…
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
CALCULATED Keyword in PROC SQL in SAS Mainframe
In SAS PROC SQL, you can dynamically create new variables and assign them names using the AS keyword. Once a variable has been created, the CALCULATED keyword in PROC SQL can be…
How to Use PROC SQL in SAS on a Mainframe (z/OS)
What Is PROC SQL in SAS? When working with SAS on the mainframe, one of the most powerful tools available is PROC SQL. Understanding how to use PROC SQL on Mainframe systems…