Previous Page | Next Page

Functions and CALL Routines

QUOTE Function



Adds double quotation marks to a character value.
Category: Character
Restriction: I18N Level 2

Syntax
Arguments
Details
Length of Returned Variable
The Basics
Examples

Syntax

QUOTE(argument)


Arguments

argument

specifies a character constant, variable, or expression.


Details


Length of Returned Variable

In a DATA step, if the QUOTE function returns a value to a variable that has not previously been assigned a length, then that variable is given a length of 200 bytes.


The Basics

The QUOTE function adds double quotation marks, the default character, to a character value. If double quotation marks are found within the argument, they are doubled in the output.

The length of the receiving variable must be long enough to contain the argument (including trailing blanks), leading and trailing quotation marks, and any embedded quotation marks that are doubled. For example, if the argument is ABC followed by three trailing blanks, then the receiving variable must have a length of at least eight to hold "ABC###". (The character # represents a blank space.) If the receiving field is not long enough, the QUOTE function returns a blank string, and writes an invalid argument note to the log.


Examples

SAS Statements Results
x='A"B';
y=quote(x);
put y;
 

"A""B"
x='A''B';
y=quote(x);
put y;
 

"A'B"
x='Paul''s';
y=quote(x);
put y;
 

"Paul's"
x='Catering Service Center      ';
y=quote(x);
put y;

"Catering Service Center      "
x='Paul''s Catering Service          ';
y=quote(trim(x));
put y;

"Paul's Catering Service"

Previous Page | Next Page | Top of Page