Sometimes we prefer to show the analyzed data in a format which is different from the format in which it is already present in the data set. For example we want to add the dollar sign and two decimal places to a variable which has price information. Or we may want to show a text variable, all in uppercase. We can use FORMAT to apply the in-built SAS formats and PROC FORMAT is to apply user defined formats. Also a single format can be applied to multiple variables.

Syntax

The basic syntax for applying in-built SAS formats is −

format variable name format name

Following is the description of the parameters used −

• variable name is the variable name used in dataset.

• format name is the data format to be applied on the variable.

Example

Let’s consider the below SAS data set containing the employee details of an organization. We wish to show all the names in uppercase. The formatstatement is used to achieve this.

DATA Employee;

INPUT empid name $ salary DEPT $ ;

format name $upcase9. ;

DATALINES;

1 Rick 623.3 IT

2 Dan 515.2 OPS

3 Mike 611.5 IT

4 Ryan 729.1 HR

5 Gary 843.25 FIN

6 Tusar 578.6 IT

7 Pranab 632.8 OPS

8 Rasmi 722.5 FIN

;

RUN;

PROC PRINT DATA = Employee;

RUN;

When the above code is executed, we get the following output.

sas 41

Using PROC FORMAT

We can also use PROC FORMAT to format data. In the below example we assign new values to the variable DEPT exapnding the name of the department.

DATA Employee;

INPUT empid name $ salary DEPT $ ;

DATALINES;

1 Rick 623.3 IT

2 Dan 515.2 OPS

3 Mike 611.5 IT

4 Ryan 729.1 HR

5 Gary 843.25 FIN

6 Tusar 578.6 IT

7 Pranab 632.8 OPS

8 Rasmi 722.5 FIN

;

proc format;

value $DEP 'IT' = 'Information Technology'

'OPS'= 'Operations' ;

RUN;

PROC PRINT DATA = Employee;

format name $upcase9. DEPT $DEP.;

RUN;

When the above code is executed, we get the following output.

sas 42

So, this brings us to the end of blog. This Tecklearn ‘How to Format Data Sets in SAS’ blog helps you with commonly asked questions if you are looking out for a job in SAS. If you wish to learn SAS and build a career in Data Analytics domain, then check out our interactive, SAS Training for SAS BASE Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

SAS Training for SAS BASE Certification

SAS Training for SAS BASE Certification Training

About the Course

SAS Certification Training is intended to make you an expert in SAS programming and Analytics. You will be able to analyse and write SAS code for real problems, learn to use SAS to work with datasets, perform advanced statistical techniques to obtain optimized results with Advanced SAS programming. In this SAS online training course, you will also learn SAS macros, Machine Learning, PROC SQL, procedure, statistical analysis and decision trees. You will also work on real-life projects and prepare for the SAS Certified Base Programmer certification exam. Upon the completion of this SAS online training, you will have enough proficiency in reading spreadsheets, databases, using SAS functions for manipulating this data and debugging it.

Why Should you take SAS Training?

• The average salary for a Business Intelligence Developer skilled in SAS is $100k (PayScale salary data)

• SAS, Google, Facebook, Twitter, Netflix, Accenture & other MNCs worldwide are using SAS for their Data analysis activities and advance their existing systems.

• SAS is a Leader in 2017 Gartner Magic Quadrant for Data Science Platform.

What you will Learn in this Course?

Introduction to SAS

• Introduction to SAS

• Installation of SAS

• SAS windows

• Working with data sets

• Walk through of SAS windows like output, search, editor etc

SAS Enterprise Guide

• How to read and subset the data sets

• SET Statement

• Infile and Infile Options

• SAS Format -Format Vs Informat

SAS Operators and Functions

• Using Variables

• Defining and using KEEP and DROP statements

• Output Statement

• Retain Statement

• SUM Statement

Advanced SAS Procedures

• PROC Import

• PROC Print

• Data Step Vs Proc

• Deep Dive into Proc

Customizing Datasets

• SAS Arrays

• Useful SAS Functions

• PUT/INPUT Functions

• Date/Time Functions

• Numeric Functions

• Character Functions

SAS Format and SAS Graphs

• SAS Format statements

• Understanding PROC GCHART, various graphs, bar charts: pie, bar

Sorting Techniques

• NODUP

• NODUKEY

• NODUP Vs NODUKEY

Data Transformation Function

• Character functions, numeric functions and converting variable type

• Use functions in data transformation

Deep Dive into SAS Procedures, Functions and Statements

• Find Function

• Scan Function

• MERGE Statement

• BY Statement

• Joins

• Procedures Vs Function

• Where Vs If

• What is Missover

• NMISS

• CMISS

PROC SQL

• SELECT statement

• Sorting of Data

• CASE expression

• Other SELECT statement clauses

• JOINS and UNIONS

Using SAS Macros

• Benefits of SAS Macros

• Macro Variables

• Macro Code Constituents and Macro Step

• Positional Parameters to Macros

Got a question for us? Please mention it in the comments section and we will get back to you.

528