The Yearcutoff System Option in SAS
The YEARCUTOFF= option lets you specify what century SAS should assign to dates when two-digit years are used.
8 Ways to Calculate Column Total in SAS
You can calculate the Column total in SAS using PROC SQL, PROC MEANS, PROC SUMMARY, PROC TABULATE, PROC UNIVARIATE, and PROC REPORT and also using data step.
How To Specify List Of Variables In SAS?
In SAS, you can quickly specify list of variables in SAS statements like KEEP and DROP statements, the ARRAY statement, and the OF operator for comma-separated arguments to some functions. You can also use variable lists on the VAR statements of any analytic procedures.
Default Sorting Order of Characters in SAS
Sorting Orders for Numeric Variables Numeric variables are sorted from the smallest-to-largest comparison and the sequence is as below. SAS System missing values (shown as a period or special missing value) negative numeric values zero positive numeric values. Sorting Orders for Character Variables PROC SORT uses either the EBCDIC or the ASCII collating sequence when…
Save SAS log to an external file : Proc Printto in SAS
PROC PRINTTO procedure is used to redirect log output and procedure output to files or printers. To save the output in an external file, specify the external file or the fileref in the PROC PRINTTO statement. Syntax: PROC PRINTTO <options>; Options in Proc Printto LABEL= It provides a description for a SAS log or procedure…
Using Proc Contents to describe SAS datasets
Do you want to know the metadata of a SAS dataset? There are many scenarios where you may need to know the metadata of a SAS dataset. It is always essential to understand fully and explore the inputs to SAS-created output. There are various possibilities in determining the position of variables or columns (and other…
How to use the SAS SCAN Function?
SCAN and SCANQ split strings into words. Both functions are similar. However, the SCANQ function has some additional features, and there is a difference in the default delimiter used in these two functions.
SAS Index Function : Definitive Guide
The INDEX function is used to search for a specified string of characters. If any match is found, INDEX function returns 0 or the position of the first occurrence of the string’s first character.
SAS Length Functions : LENGTH / LENGTHN / LENGTHC / LENGTHM.
SAS Length Function: LENGTH is a character function in SAS used to find the length of the character string. There are 4 variations available in SAS to find the length of a string. These are the LENGTH, LENGTHN, LENGTHC and LENGTHM. The primary objective of all the length function is to return the length of the string however there are few variations in how these functions work and return the length.
