abhishekdagarit

Creating a list

A list is like a super data type that can hold any other data type inside it.

# Vector with numerics from 12 up to 100
my_vector <- 12:100 

# Matrix with numerics from 1 up to 8
my_matrix &lt;- matrix(1:8, ncol = 2)

abhishekdagarit

Merging datasets in SAS

The process is straight forward.

Data 1

data d1;
input name$ age;

abhishekdagarit

SQL select statement

Select

Simplest Select satament

proc sql;
select * 

abhishekdagarit

Global statements in SAS

List of global statements in SAS

1. title
2. options
3. footnote

Properties of global statements in SAS

abhishekdagarit

Frequency in SAS

Used using the proc freq statement

complete frequency table

proc freq data=work.test;
run;

abhishekdagarit

Special cases

Maximum number of decimal places

proc print data=work.temp maxdec=2;
run;

labels in SAS

abhishekdagarit

Calculating mean in SAS

To calculate mean simply use proc means

proc means data = work.test;
var ratings;
run;

abhishekdagarit

Sum of single variable

Simply write sum followed by the variable name.

proc print data=test;
sum salary;
run;

abhishekdagarit

Sort function in SAS

By

Basic sort function. Uses by.

proc sort data=work.test;
by Salary;

abhishekdagarit

SAS rules

Case sensitive

SAS in not case sensitive.

proC PrinT daTa = woRK.IntrO;
WHerE Rating = 2;
run;