Subhro

table lookup in sas

7 Table lookup techniques for SAS Programmers

There are a number of techniques for performing these table lookups. These techniques can be radically different both in terms of programming complexity and performance.

Proc Transpose

Flipping the data using Proc Transpose

PROC TRANSPOSE provides the ability to go from a long dataset (where there are multiple rows for a given subject) to a wide dataset (where there are multiple columns for a subject).

Proc Sort Options in SAS

Proc Sort Options in SAS

Sorting the data is always a resource-intensive operation. Therefore, using PROC SORT efficiently can save you both time and computing resources.
There are a number of options associated with PROC SORT that can be used not only to control the performance and capabilities of the procedure but also to the resulting data set.

Proc SQL in SAS

A comprehensive guide to PROC SQL in SAS (15 + Examples)

PROC SQL in SASis a Procedure that combines the functionality of DATA and PROC steps into a single step. PROC SQL can perform sorting of data, creating summaries of data, subsetting, joining (merge), concatenation of datasets, create new or calculated variables, printing the results or create a new table or view all in a single step.

Proc Tabulate

Learn how to create Summary Reports using PROC Tabulate

The Proc Tabulate procedure is used to create tables in SAS. Unlike Proc FREQ, this procedure can handle multiple variables in the row and column expressions. PROC TABULATE has a number of statements that define how this procedure will summarize the data.

Retain In SAS

Using RETAIN in SAS to remember values

RETAIN in SAS is used to “remember” values from previous observations. Variables that do not come from SAS data sets are, by default, set to a missing value during each iteration of the DATA step.

Confidence Interval

Confidence Interval for Population Mean

A confidence interval is constructed from a sample data is a range of values that is likely to include the population parameter with a certain probability.

The objective of a confidence interval is to provide location and precision of population parameters.

Combining data Vertically in SAS

Combining data Vertically in SAS (6 Methods)

Combining datasets vertically involves stacking one or more datasets. Before combining datasets It’s important to understand the descriptor portion or structure and contents of your input data sets.

Receive the latest articles in your inbox

Insert your email signup form below

🤞 Don’t miss these tips!

We don’t spam! Read more about our privacy policy.