DBzTech-Technology Dossier

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 a program is executing. SYSPARM should be used when there is a need to control conditional processing within…

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, it is evident it needs to be stored in some temporary memory buffer. This is where the concept…

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 chart using PROC CHART with the PIE statement. Each slice of the pie shows the percentage for a…

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 the right of each bar. Let’s see the output how the same data (as shown in previous posts…

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 , print the data in descending order and reduce the width of the bars by 2 lines. Let’s look…

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 proc chart can be used to generate a bar diagram in mainframe (Z/OS) world.The objective here is to…

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 returns character string with specific characters removed from the original string. The syntax is as follows:COMPRESS(string, characters to…

Reading input file in SAS Mainframe with delimiter option

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 is not provided, these dynamically created variables will appear in the output without a column heading. For example,…

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, filter, join and organize your data efficiently. What is PROC SORT in SAS on Mainframe? PROC SORT is…