When you use the $QUOTE
w.
format, all literals must be in single quotation marks.
The following list describes
the output that SAS produces when you use the $QUOTEw. format.
-
If your data value is not enclosed
in quotation marks, SAS encloses the output in double quotation marks.
-
If your data value is not enclosed
in quotation marks, but the value contains a single quotation mark,
SAS takes the following actions:
-
encloses the data value in double
quotation marks
-
does not change the single quotation
mark.
-
If your data value begins and ends
with single quotation marks, and the value contains double quotation
marks, SAS takes the following actions:
-
encloses the data value in double
quotation marks
-
duplicates the double quotation
marks that are found in the data value
-
does not change the single quotation
marks.
-
If your data value begins and ends
with single quotation marks, and the value contains two single contiguous
quotation marks, SAS takes the following actions:
-
encloses the value in double quotation
marks
-
does not change the single quotation
marks.
-
If your data value begins and
ends with single quotation marks, and contains both double quotation
marks and single, contiguous quotation marks, SAS takes the following
actions:
-
encloses the value in double quotation
marks
-
duplicates the double quotation
marks that are found in the data value
-
does not change the single quotation
marks.
-
If the length of the target field
is not large enough to contain the string and its quotation marks,
SAS returns all blanks.