SASCRUNCH TRAINING
  • Home
  • SASĀ® Certification Training
    • SAS Certified Specialist Exam Training Program
    • How to Prepare For SAS Certified Specialist Base Programming Exam
  • Online Courses
    • Practical SAS Training Course for Beginners
    • Proc SQL Course
    • SAS Project Training Course
    • Logistic Regression (Credit Scoring) Modeling using SAS
  • Articles
    • Get Started >
      • 18 Free Resources to Help You Learn SAS
      • SAS Tutorial
      • How to Install SAS Studio
      • How to Learn SAS Fast
    • Data Import >
      • Importing Excel Spreadsheet
      • Importing CSV Files
      • Importing Text Files
    • SAS Functions >
      • CAT, CATT, CATS, CATX Functions
      • If-Then-Else statement
      • TRIM Function
      • STRIP Function
      • YEAR, MONTH, DAY Functions
      • Compress Function
      • Do-Loop
      • SCAN Function
      • LIKE Operator
      • INDEX Function
    • Data Manipulations >
      • The Ultimate Guide to Proc SQL
      • Proc Datasets
      • Dictionary Tables
      • Dealing with Missing Values
      • Proc Compare
      • Proc Transpose
      • RETAIN Statement
      • SAS Formats
      • SAS Arrays
    • Statistical Analysis >
      • Proc Means
      • Proc Freq
      • Proc Tabulate
    • Machine Learning >
      • Predicting Fish Species Using K-nearest Neighbor in SAS
      • Classify Product Reviews on Amazon Using Naive Bayes Model in SAS
    • Informational Interviews >
      • How to get a Clinical Trial/Research job without experience
      • Senior Recruiter at a Fortune 500 Retail Company
      • Manager, Non-profit Health Services Research
      • HR Manager
      • Quantitative Analyst
  • Services
    • The Ultimate Job Search Automation Services
    • Statistical Consulting
    • SAS Project or Assignment Help
    • Data Import Services
    • Data Manipulation and Reporting Services
  • In-class Training
    • SAS Training for Job Seekers
  • Guest Lecture
  • Sample Resume
  • About us
  • Contact Us
x
Picture
Need help studying for the new
SAS Certified Specialist Exam?
Get access to:
  • Two Full Certificate Prep Courses
  • ​300+ Practice Exercises
Start your free training now
How to Prepare for the SAS Certified Specialist Base Programming Exam
Picture
40 Most Common SAS Statements, Functions and Procedures


I. SAS Steps

1. DATA Step

Function: to create SAS data sets
Picture
2. PROC Step

Function: to perform data manipulation, statistical analysis and report / graph production
Picture

II. SAS Statements

3. Libname Statement

Function: to create a SAS library
Picture
4. Input and Datalines statement

Function: create a SAS data set with specified contents
Picture
5. Filename statement

Function: to specify the external data file


Picture
6. Infile statement

Function: to read in an external data file
Picture
7. Set statement

Function: to copy the contents from one data set into another
Picture
8. If-then statement

Function: set conditional statement to execute different functions
Picture
9. Keep, drop statement

Function: to keep only the variables needed in the data set
Picture
10. Merge statement

Function: to merge multiple data set into one
Picture

III. SAS Functions

11. Sum function

Function: to add up values
Picture
12. Basic mathematical operation

Function: to perform basic mathematical operations
Picture
13. Random Variable (Exponential)

Function: to create a random value from an exponential distribution


Picture
14. Random Variable (Uniform)

Function: to create a random value from a uniform distribution
Picture
15. Square / Square Root

Function: to calculate square and square root of a numeric value
Picture
16. Combine character variable

Function (double stroke): to combine two character values
Picture
17. Substr

Function: to extract partial text from a character value
Picture
18. Trim / Compress

Function: to remove trailing space (TRIM) or to remove all spaces (COMPRESS) from a character value 
Picture
19. Index

Function: to identify the position where the specified text is found from a character value
Picture
20. Upcase, lowcase, propcase

Function: to convert the character value into upper case (UPCASE), lower case (LOWCASE) or proper case (PROPCASE)

Note: Proper case = Upper case in the first letter of each word and lower case in the rest
Picture
21 Label

Function: to change the label of the variable
Picture
22. Length

Function: to change the length of the variable
Picture
23. Format

Function: to change the format of the variable
Picture
24. ABS

Function: to convert the numeric value into an absolute value
Picture
25. INPUT

Function: to convert a character value into a numeric value
Picture
26. PUT

Function: to convert a anumeric value into a character value
Picture
27. Log

Function: to convert the numeric value into logarithm
Picture
28. Mean, Min, Max

Function: to compute the mean, minimum and maximum of a set of numeric values
Picture
29. Rename

Function: to rename a variable
Picture
30. Round / Floor

Function: to round a numeric value

Picture

IV. SAS Procedures (PROC Step)

31. Proc Sort

Function: to sort a data set
Picture
32. Proc Transpose

Function: to convert rows into columns in a data set
Picture
33. Proc Freq

Function: to compute frequency count and percentage of a variable
Picture
34. Proc Means

Function: to compute summary statistics such as mean, standard deviation and median
Picture
35. Proc GChart

Function: to create pie chart or histogram
Picture
36. Proc Reg

Function: to perform regression analysis
Picture
37. Proc GLM

Function: to perform general linear modeling
Picture
38. Proc Gplot

Function: to plot graphs
Picture
39. Proc Print

Function: to print the content of the data set
Picture
40. Proc Report

Function: to create a report from the data set

Picture
Copyright © 2012-2019 SASCrunch.com All rights reserved.
  • Home
  • SASĀ® Certification Training
    • SAS Certified Specialist Exam Training Program
    • How to Prepare For SAS Certified Specialist Base Programming Exam
  • Online Courses
    • Practical SAS Training Course for Beginners
    • Proc SQL Course
    • SAS Project Training Course
    • Logistic Regression (Credit Scoring) Modeling using SAS
  • Articles
    • Get Started >
      • 18 Free Resources to Help You Learn SAS
      • SAS Tutorial
      • How to Install SAS Studio
      • How to Learn SAS Fast
    • Data Import >
      • Importing Excel Spreadsheet
      • Importing CSV Files
      • Importing Text Files
    • SAS Functions >
      • CAT, CATT, CATS, CATX Functions
      • If-Then-Else statement
      • TRIM Function
      • STRIP Function
      • YEAR, MONTH, DAY Functions
      • Compress Function
      • Do-Loop
      • SCAN Function
      • LIKE Operator
      • INDEX Function
    • Data Manipulations >
      • The Ultimate Guide to Proc SQL
      • Proc Datasets
      • Dictionary Tables
      • Dealing with Missing Values
      • Proc Compare
      • Proc Transpose
      • RETAIN Statement
      • SAS Formats
      • SAS Arrays
    • Statistical Analysis >
      • Proc Means
      • Proc Freq
      • Proc Tabulate
    • Machine Learning >
      • Predicting Fish Species Using K-nearest Neighbor in SAS
      • Classify Product Reviews on Amazon Using Naive Bayes Model in SAS
    • Informational Interviews >
      • How to get a Clinical Trial/Research job without experience
      • Senior Recruiter at a Fortune 500 Retail Company
      • Manager, Non-profit Health Services Research
      • HR Manager
      • Quantitative Analyst
  • Services
    • The Ultimate Job Search Automation Services
    • Statistical Consulting
    • SAS Project or Assignment Help
    • Data Import Services
    • Data Manipulation and Reporting Services
  • In-class Training
    • SAS Training for Job Seekers
  • Guest Lecture
  • Sample Resume
  • About us
  • Contact Us