The following list describes
the output that SAS produces when you use the $QUOTE
w.
format. For examples of these items, see the examples below.
-
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 does the following:
-
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 does the following:
-
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 does the following:
-
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 does the following:
-
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 as much of the quoted string that will fit in the field.