|
Format
|
Description
|
|---|---|
|
$
|
Writes standard character
data.
|
|
$BINARY
|
Converts character values
to binary representation.
|
|
$CHAR
|
Writes standard character
data.
|
|
$HEX
|
Converts character values
to hexadecimal representation.
|
|
$OCTAL
|
Converts character values
to octal representation.
|
|
$QUOTE
|
Converts character values
to quoted strings.
|
|
$VARYING
|
Writes varying length
values.
|
|
BEST
|
SPD Server chooses best notation.
|
|
BINARY
|
Converts numeric values
to binary representation.
|
|
COMMA
|
Writes numeric values
with commas and decimal points.
|
|
COMMAX
|
Writes numeric values
with commas and decimal points (European style).
|
|
DATE
|
Writes date values (ddmmmyy).
|
|
DATETIME
|
Writes date time values
(ddmmmyy:hh:mm:ss.ss).
|
|
DAY
|
Writes day of month.
|
|
DDMMYY
|
Writes date values (ddmmyy).
|
|
DOLLAR
|
Writes numeric values
with dollar signs, commas, and decimal points.
|
|
DOLLARX
|
Writes numeric values
with dollar signs, commas, and decimal points (European style).
|
|
DOWNAME
|
Writes name of day of
the week.
|
|
E
|
Writes scientific notation.
|
|
F
|
Writes scientific notation.
|
|
FRACT
|
Converts values to fractions.
|
|
HEX
|
Converts real binary
(floating-point) numbers to hexadecimal representation.
|
|
HHMM
|
Writes hours and minutes.
|
|
HOUR
|
Writes hours and decimal
fractions of hours.
|
|
IB
|
Writes integer binary
values.
|
|
MMDDYY
|
Writes date values (mmddyy).
|
|
MMSS
|
Writes minutes and seconds.
|
|
MMYY
|
Writes month and year,
separated by an 'M'.
|
|
MONNAME
|
Writes name of month
|
|
MONTH
|
Writes month of year.
|
|
MONYY
|
Writes month and year.
|
|
NEGPAREN
|
Displays negative values
in parentheses.
|
|
OCTAL
|
Converts numeric values
to octal representation.
|
|
PD
|
Writes packed decimal
data.
|
|
PERCENT
|
Prints numbers as percentages.
|
|
PIB
|
Writes positive integer
binary values.
|
|
QTR
|
Writes quarter of year.
|
|
RB
|
Writes real binary (floating-point)
data.
|
|
SSN
|
Writes Social Security
numbers.
|
|
TIME
|
Writes hours, minutes,
and seconds.
|
|
TOD
|
Writes the time portion
of datetime values.
|
|
w.d
|
Writes standard numeric
data.
|
|
WEEKDATE
|
Writes day of week and
date (day-of-week, month-name dd, yy).
|
|
WEEKDATX
|
Writes day of week and
date (day-of-week, dd month-name yy).
|
|
WEEKDAY
|
Writes day of week.
|
|
WORDDATE
|
Writes date with name
of month, day, and year (month-name dd, yyyy).
|
|
WORDDATX
|
Writes date with day,
name of month, and year (dd month-name yyyy).
|
|
WORDF
|
Converts numeric values
to words.
|
|
WORDS
|
Converts numeric values
to words (fractions as words).
|
|
YEAR
|
Writes year part of
date value.
|
|
YYMM
|
Write year and month,
separated by an 'M'.
|
|
YYMMDD
|
Writes day values (yymmdd).
|
|
YYMON
|
Writes year and month
abbreviation.
|
|
YYQ
|
Writes year and quarter,
separated by a 'Q'.
|
|
Z
|
Writes leading 0s
|
|
ZD
|
Writes data in zoned decimal format.
|
proc sql; connect to sasspds (dbq='tmp' user='anonymous' host='localhost' serv='5127'); execute(create table money as select salesite format=dollar. from sales) by sasspds; disconnect from sasspds; quit;