Sometimes, we prefer to sort variables manually with a custom sort order rather than alphabetically or Numerical sequence.The first solution is to create user-defined formats that map the DelayCategory to a number that represents the order in which the records will appear.

You can read zip files in SAS without having to decompress the file first. SAS will first unzip the file and then input the data set through the zip engine.

This post will you to create zip files or unzip files using SAS. There 3 different methods you can use to zip or unzip files. All the method requires that NOXCMD is enabled in your SAS system.

If you want to check if a string is numeric in SAS in a simple and fast

One way ANOVA is a  parametric test . It compares the means of two or more independent groups to…

Often Programmers are required to find if an object exists in SAS for validation or to execute certain codes dynamically. This article will help you to find if a specific object exists in SAS. The types of objects include datasets, external files, open libraries, file references, macros, macro variables, formats, informats, and specific variables in a dataset.

The YEARCUTOFF= option lets you specify what century SAS should assign to dates when two-digit years…

This example shows you how to Import multiple Excel files in SAS with the same variable names from a folder and then merge data from all the data sets into a single one. Data Step Method to Import multiple Excel files in SAS Using SAS Macro to Import multiple Excel files in SAS The 2nd [...]

This article explains the data summarization by rows and columns and how you can use Predicates in…

In SAS, the order of variables in a data set is based on the order in which the variables were created. There are several reasons you may want to reorder variables names in a SAS data set. You can change the position of a variable in a SAS dataset with any of the following statements. ATTRIB, ARRAY, FORMAT, INFORMAT, LENGTH, and RETAIN.