Data Set Name:
|
SASUSER.INSURE
|
Member Type:
|
DATA
|
Engine:
|
V9
|
Created:
|
10:05 Thursday, February
16, 2017
|
Observations:
|
21
|
Variables:
|
7
|
Indexes:
|
0
|
Observation Length:
|
64
|
MUTUALITY
is
a data value, Policy 32668
is a data
value, and so on.
2458
, Murray
W
, 32668
, MUTALITY
, 100
, 98.64
,
and 0.00
comprise a single observation
in the data set shown below.
2458
, 2462
, 2501
,
and 2523
comprise the variable ID in
the data set shown below.
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR8.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR8.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
Syntax, VALIDVARNAME=
VALIDVARNAME= V7|UPCASE|ANY
V7
specifies that variable names must follow these rules:
UPCASE specifies
that the variable name follows the same rules as V7, except that the
variable name is uppercase, as in earlier versions of SAS.
ANY specifies
that SAS variable names must follow these rules:
|
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR8.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR9.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
1234
as $1,234.00
in a report, you can use the DOLLAR9.2 format, as shown for Total
below.
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR9.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
5678
as
5,678.00 in a report, you can use the COMMA8.2 format, which specifies
a width of 8 including 2 decimal places.
$12,345.00
contains
two special characters, a dollar sign ($) and a comma (,). You can
use an informat to read the value while removing the dollar sign and
comma, and then store the resulting value as a standard numeric value.
For Total below, the COMMA10. informat is specified.
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR9.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|
Variable
|
Type
|
Length
|
Format
|
Informat
|
Label
|
---|---|---|---|---|---|
Policy
|
Char
|
8
|
|
|
Policy Number
|
Total
|
Num
|
8
|
DOLLAR9.2
|
COMMA10.
|
Total Balance
|
Name
|
Char
|
20
|
|
|
Patient Name
|