131
CH A P T E R
10
XLS Chapter
No
t
e
t
oUNIX and O
S
/
390 Users
131
Impor
t
/
Expor
t
Facili
t
y
131
Unders
t
andingXL
S
Essen
t
ials
132
XL
S
Files
133
XL
S
FileNamingConven
t
ions
134
XL
S
Da
t
aTypes
134
How
t
he
S
A
SS
ys
t
emHandles Da
t
eand Time Values
135
Da
t
e
t
imeConversions in
t
heACCE
SS
Procedure
135
Da
t
e
t
imeConversions in
t
heDBLOAD Procedure
136
ACCE
SS
Procedure Da
t
aConversions
136
DBLOAD ProcedureDa
t
aConversions
140
S
e
tt
ingEnvironmen
t
Variables
142
ACCE
SS
Procedure: XL
SS
pecifics
143
ACCE
SS
Procedure
St
a
t
emen
t
sfor XL
S
143
DBLOAD Procedure: XL
SS
pecifics
146
DBLOAD Procedure
St
a
t
emen
t
sforXL
S
146
How
t
he
S
A
S
/
ACCE
SS
In
t
erface Wor
k
s
147
Accessing
t
he Da
t
a
147
Crea
t
ingand Loading
t
he Da
t
a
148
Note to UNIX and OS/390 Users
If you
ar
e
r
unning
t
his SAS/ACCESSin
t
e
r
f
a
ce unde
rt
he UNIXo
r
OS/390 ope
rat
ing
envi
r
onmen
t
,
t
hisch
a
p
t
e
r
doesno
ta
pply
t
oyou. Ins
t
e
a
d, see Ch
a
p
t
e
r
3, “DBF
a
nd DIF
P
r
ocedu
r
es,” on p
a
ge 33. Unde
r
UNIX
a
nd PC hos
t
s, you c
a
nuse
t
hese p
r
ocedu
r
es
t
o
conve
rta
DBF o
r
DIF file
t
o
a
SAS d
ata
se
t
o
ra
SAS d
ata
se
tt
o
a
DBF o
r
DIF file.
Unde
r
OS/390, you c
a
nusePROC DBFonly
t
oconve
rta
DBF file
t
o
a
SASd
ata
se
t
o
ra
SAS d
ata
se
tt
o
a
DBF file.
Import/Export Facility
UNIX
a
nd PC use
r
sc
a
n
a
ccess Excel (o
r
XLS) d
ata
—includingExcel97
files—
t
h
r
ough
t
he Impo
rt
/Expo
rt
f
a
cili
t
yo
r
by using
t
he IMPORT
a
nd EXPORT
p
r
ocedu
r
es. An ove
r
view is included inCh
a
p
t
e
r
5, “Impo
rt
/Expo
rt
F
a
cili
t
y
a
nd
P
r
ocedu
r
es,” on p
a
ge 51.
Touse
t
he poin
t
-
a
nd-click in
t
e
r
f
a
ce f
r
om
a
SAS PROGRAM EDITOR window, selec
t
t
he
File
menu
a
nd
t
henselec
tt
he
Import Data
o
r
Export Data
i
t
em. Info
r
m
at
ion
Pdf rotate one page - rotate PDF page permanently in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Empower Users to Change the Rotation Angle of PDF File Page Using C#
rotate single page in pdf file; rotate pdf page permanently
Pdf rotate one page - VB.NET PDF Page Rotate Library: rotate PDF page permanently in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
PDF Document Page Rotation in Visual Basic .NET Class Application
pdf reverse page order preview; pdf rotate pages and save
132
UnderstandingXLSEssentials
Chap
t
er10
a
bou
t
how
t
oimpo
rt
o
r
expo
rt
Exceld
ata
is
a
v
a
il
a
ble f
r
om
t
he
Help
bu
tt
on. The
followingis
a
s
a
mple Impo
rt
window:
Display 10.1 ImportWindow
To w
r
i
t
ecode
t
oimpo
rt
o
r
expo
rt
Excel d
ata
,
r
efe
rt
o
t
he de
ta
iled desc
r
ip
t
ions of
t
he
IMPORT
a
nd EXPORT p
r
ocedu
r
esin
t
he
S
A
S
Procedures Guide. Thisdocumen
tat
ion
a
lso includes seve
ra
lex
a
mples.
Understanding XLS Essentials
This ch
a
p
t
e
r
in
tr
oduces SAS Sys
t
em use
r
s
t
oXLS files. I
t
focuseson
t
he
t
e
r
ms
a
nd
concep
t
s
t
h
at
help youuse
t
he SAS/ACCESSin
t
e
r
f
a
ce
a
nd includesdesc
r
ip
t
ions of
XLS files
XLS file n
a
ming conven
t
ions
XLS file d
atat
ypes
how
t
he SAS/ACCESS in
t
e
r
f
a
ce wo
r
ks.
XLS filescon
ta
ind
ata
in
t
he fo
r
mof Mic
r
osof
t
Excelsp
r
e
a
dshee
t
s. Unlesso
t
he
r
wise
no
t
ed, Excel4
a
nd Excel5 files
ar
e
r
efe
rr
ed
t
ocollec
t
ively
t
h
r
oughou
tt
his
r
epo
rta
s
XLS. Excel 5files
ar
eno
t
suppo
rt
ed unde
r
OS/2.
No
t
e: TheACCESS
a
nd DBLOAD p
r
ocedu
r
esdo no
t
suppo
rt
filesin
t
he Excel97
(Ve
r
sion 8) fo
r
m
at
. Howeve
r
,you c
a
ns
t
ill
a
ccessExcel 97 files
t
h
r
ough
t
he SAS Impo
rt
/
Expo
rt
f
a
cili
t
y. F
r
om
a
SAS session’s PROGRAM EDITOR window, selec
tt
he
File
menu
a
nd
t
henselec
tt
he
Import Data
o
r
Export Data
i
t
em. Info
r
m
at
ion
a
bou
t
how
t
oimpo
rta
nd expo
rt
Excel d
ata
is
a
v
a
il
a
ble f
r
om
t
he
Help
bu
tt
on. To w
r
i
t
ecode
t
o
impo
rt
o
r
expo
rt
Excel d
ata
,
r
efe
rt
o
t
he IMPORT o
r
EXPORT p
r
ocedu
r
edesc
r
ip
t
ionin
t
he
S
A
S
Procedures Guide.
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
If you are looking for a solution to conveniently delete one page from your PDF document, you can use this VB.NET PDF Library, which supports a variety of PDF
rotate pdf pages and save; rotate all pages in pdf
C# PDF File Merge Library: Merge, append PDF files in C#.net, ASP.
C# developers can easily merge and append one PDF document to document imaging toolkit, also offers other advanced PDF document page processing and
how to rotate all pages in pdf; rotate pages in pdf
XLSFiles
133
XLS Files
V
ar
ious sof
t
w
ar
ep
r
oduc
t
s, such
a
s
t
he Mic
r
osof
t
Excelsp
r
e
a
dshee
t
,en
a
ble you
t
o
use sp
r
e
a
dshee
t
o
r
d
ata
b
a
se files
t
oen
t
e
r
,o
r
g
a
nize,
a
nd pe
r
fo
r
mc
a
lcul
at
ions on d
ata
.
Sp
r
e
a
dshee
t
s
ar
emos
t
of
t
en used fo
r
gene
ra
lledge
r
s, income s
tat
emen
t
s,
a
nd o
t
he
r
t
ypes of fin
a
nci
a
l
r
eco
r
dkeeping. D
ata
b
a
se files
a
lso en
a
ble you
t
oo
r
g
a
nize
r
el
at
ed
info
r
m
at
ion, such
a
s
t
he d
ata
in
a
n
a
ccoun
t
s-
r
eceiv
a
ble jou
r
n
a
l.
In sp
r
e
a
dshee
t
s,
t
he d
ataar
eo
r
g
a
nized
a
cco
r
ding
t
oce
rta
in
r
el
at
ionships
a
mong
d
ata
i
t
ems. These
r
el
at
ionships
ar
eexp
r
essed in
ata
bul
ar
fo
r
m—in columns
a
nd
r
ows.
E
a
chcolumn
r
ep
r
esen
t
sone c
at
ego
r
yof d
ata
,
a
nd e
a
chrow c
a
nhold one d
ata
v
a
lue fo
r
e
a
ch column.
AMic
r
osof
t
Excel 5.0 wo
r
kshee
t
,fo
r
ex
a
mple, is
a
nelec
tr
onic sp
r
e
a
dshee
t
consis
t
ing
of
a
g
r
id of 256columns
a
nd 16,384
r
ows. The in
t
e
r
sec
t
ionof
a
column
a
nd
ar
ow is
c
a
lled
a
cell.Displ
a
y10.2 onp
a
ge 133 illus
trat
es
a
po
rt
ionof
a
s
ta
nd
ar
dExcel
wo
r
kshee
t
.
Display 10.2 ColumnsandRowsofDatain an XLS File
Column le
tt
e
r
sfo
r
e
a
ch column
a
ppe
ara
bove
t
he wo
r
kshee
t
. Columns
ar
ele
tt
e
r
ed A
t
h
r
ough IV (A
t
oZ, AA
t
oAZ, BA
t
oBZ,
a
nd so on
t
oIV). Row numbe
r
sfo
r
e
a
ch
r
ow
a
ppe
art
o
t
he lef
t
of
t
he wo
r
kshee
t
.Rows
ar
enumbe
r
ed 1
t
o16,384. Fo
r
Excel4 files,
onlyone wo
r
kshee
t
(wo
r
kshee
t
1) is
a
llowed pe
r
file,bu
t
mo
r
e
t
h
a
none wo
r
kshee
t
c
a
n
be s
t
o
r
ed in
a
wo
r
kbook. You mus
t
conve
rta
ny wo
r
kshee
t
syou s
t
o
r
ein
a
wo
r
kbook
b
a
ck
t
owo
r
kshee
t
sbefo
r
eyou c
a
nuse
t
he d
ata
in
a
SASp
r
og
ra
m.
VB.NET PDF File Merge Library: Merge, append PDF files in vb.net
all. This guiding page will help you merge two or more PDF documents into a single one in a Visual Basic .NET imaging application.
rotate pdf page and save; rotate pages in pdf expert
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
Extract PDF Pages, Copy Pages from One PDF File and Paste into Others in C#.NET Program. Free PDF document processing SDK supports PDF page extraction, copying
how to rotate one page in pdf document; rotate a pdf page
134
XLS DataTypes
Chap
t
er 10
Arange is
a
subse
t
of cellsin
a
wo
r
kshee
t
.A
ra
nge isiden
t
ified byi
t
s
a
dd
r
ess, which
begins wi
t
h
t
he n
a
me of
t
he
t
op lef
t
cell
a
nd endswi
t
h
t
he n
a
meof
t
he bo
tt
om
r
igh
t
cell
sep
arat
ed by
t
wo pe
r
iods. Fo
r
ex
a
mple,
t
he
ra
nge B3..D6 is
t
he
ra
nge
a
dd
r
essfo
ra
r
ec
ta
ngul
ar
block of 12cells whose
t
op lef
t
cellis B3
a
nd whose bo
tt
om
r
igh
t
cell isD6
(
a
ssh
a
ded in
t
he displ
a
y).
XLS File Naming Conventions
The followingconven
t
ions
a
pply
t
oXLS filen
a
mes. Filen
a
mesmus
ta
lso follow
ope
rat
ing-sys
t
em specific conven
t
ions, so check
t
he documen
tat
ion
t
h
at
comes wi
t
hyou
r
Mic
r
osof
t
Excel p
r
oduc
t
o
r
o
t
he
r
sof
t
w
ar
ep
r
oduc
t
sfo
r
fu
rt
he
r
info
r
m
at
ion.
Unde
r
Windows 95, Windows98, Windows NT,
a
nd OS/2,
t
he ACCESS
a
nd
DBLOADp
r
ocedu
r
es suppo
rt
long n
a
mes
t
h
atar
especified in
t
he PATH=
s
tat
emen
t
(such
a
s
path=
’c:\sasdemo\library\new_customer_1999.xls’;
). Howeve
r
,XLS files wi
t
h
longn
a
mes migh
t
no
ta
ccep
t
ed bysome ve
r
sionsof Mic
r
osof
t
Excel.
Filen
a
mess
tart
wi
t
h
a
le
tt
e
r
,
a
nd
t
heyc
a
ncon
ta
in
a
nycombin
at
ionof
t
he le
tt
e
r
s
A
t
h
r
oughZ,
t
he digi
t
s0
t
h
r
ough9,
t
he unde
r
sco
r
e(_),
t
he hyphen (-),
a
nd sp
a
ces
(bl
a
nks) wi
t
hin filen
a
mes.
Filen
a
mesc
a
ncon
ta
in sp
a
ces. Filen
a
mes
t
h
at
con
ta
in sp
a
ceso
r
lowe
r
c
a
sele
tt
e
r
s
ar
esuppo
rt
ed by
t
he ACCESS
a
nd DBLOAD p
r
ocedu
r
es, bu
tt
hey migh
t
no
t
be
a
ccep
t
ed bysome ve
r
sionsof Mic
r
osof
t
Excel.
XLS Data Types
Mic
r
osof
t
Excel sof
t
w
ar
eh
a
s
t
wo d
atat
ypes: ch
ara
c
t
e
ra
nd nume
r
ic. Mic
r
osof
t
Excel
ch
ara
c
t
e
r
d
ata
m
a
ybe en
t
e
r
ed
a
sl
a
belso
r
fo
r
mul
a
s
tr
ings; Mic
r
osof
t
Excel nume
r
ic
d
ata
m
a
ybe en
t
e
r
ed
a
snumbe
r
so
r
fo
r
mul
a
s.
Charac
t
er da
t
a
ar
egene
ra
llyconside
r
ed
t
ex
ta
nd c
a
ninclude d
at
es
a
nd numbe
r
s.
Numeric da
t
ac
a
ninclude numbe
r
s(0
t
h
r
ough9), fo
r
mul
a
s,
a
nd cell en
tr
ies
t
h
at
begin wi
t
hone of
t
he followingsymbols: +, $, @, − − , =, o
r
#. Whenyou c
r
e
at
e
a
nd lo
a
d
a
nExcel file wi
t
hPROC DBLOAD,
t
he SAS/ACCESS engine supplies
#NA
fo
ra
missing, nume
r
ic v
a
lue.
Nume
r
ic d
ataa
lso c
a
ninclude d
at
e
a
nd
t
ime v
a
lues. In Mic
r
osof
t
Excel sof
t
w
ar
e,
a
da
t
evalueis
t
he in
t
ege
r
po
rt
ionof
a
numbe
rt
h
at
c
a
n
ra
ngef
r
om 01
Ja
nu
ar
y1900
t
o
31 Decembe
r
2078,
t
h
at
is, 1
t
o65380. A Mic
r
osof
t
Excel sof
t
w
ar
e
t
ime valueis
t
he
decim
a
lpo
rt
ion of
a
numbe
rt
h
atr
ep
r
esen
t
s
t
ime
a
s
a
p
r
opo
rt
ionof
a
d
a
y. Fo
r
ex
a
mple,
0.0 is midnigh
t
,0.5 is noon,
a
nd 0.999988 is 23:59:59 (on
a
24-hou
r
clock). While
a
numbe
r
c
a
nh
a
ve bo
t
h
a
d
at
e
a
nd
at
ime po
rt
ion,
t
he fo
r
m
at
sinMic
r
osof
t
Excel displ
a
y
a
numbe
r
only in
a
d
at
e,
t
ime, o
r
d
at
e
t
ime fo
r
m
at
. Fo
r
info
r
m
at
ion onhow
t
he
SAS/ACCESS in
t
e
r
f
a
ce h
a
ndles d
at
e
a
nd
t
ime v
a
lues
a
nd fo
r
m
at
s, see “How
t
he SAS
Sys
t
em H
a
ndlesD
at
e
a
nd Time V
a
lues” on p
a
ge 135.
Whenyouc
r
e
at
e
a
n
a
ccessdesc
r
ip
t
o
r
,
t
he in
t
e
r
f
a
ce sof
t
w
ar
euses
t
he column
t
ypes
a
nd fo
r
m
at
sin
t
he XLS file
t
ode
t
e
r
mine
t
he co
rr
esponding SASv
ar
i
a
ble fo
r
m
at
s. The
SAS Sys
t
em gene
rat
es i
t
sdef
a
ul
t
fo
r
m
at
sb
a
sed on
t
he v
a
lues
t
h
at
youspecify fo
rt
he
SCANTYPE, SKIPROWS,
a
nd GETNAMESs
tat
emen
t
s(o
r
in
t
he co
rr
esponding fields
in
t
he Access Desc
r
ip
t
o
r
Iden
t
ific
at
ion window). Youc
a
nch
a
nge
t
he fo
r
m
at
sgene
rat
ed
by
t
he sof
t
w
ar
ein
t
e
r
f
a
ce. Fo
r
mo
r
einfo
r
m
at
ion, see “How
t
he SAS/ACCESS In
t
e
r
f
a
ce
Wo
r
ks” on p
a
ge 147.
Whenyouc
r
e
at
e
a
n
a
ccessdesc
r
ip
t
o
r
,
a
ny d
ata
v
a
lue
t
h
at
does no
t
m
at
ch
t
he
column
t
ype (ch
ara
c
t
e
r
o
r
nume
r
ic) is
tr
e
at
ed
a
s
a
missing v
a
lue. Thisis
t
he def
a
ul
t
a
c
t
ion. Howeve
r
,you c
a
nuse
t
he MIXED=YESs
tat
emen
tt
oconve
rt
nume
r
ic d
ata
v
a
lues in
a
ch
ara
c
t
e
r
column
t
o
t
hei
r
ch
ara
c
t
e
rr
ep
r
esen
tat
ion.
VB.NET PDF Annotate Library: Draw, edit PDF annotation, markups in
to display it. Thus, PDFPage, derived from REPage, is a programming abstraction for representing one PDF page. Annotating Process.
how to reverse page order in pdf; pdf rotate just one page
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Using RasterEdge Visual C# .NET PDF page deletion component, developers can easily select one or more PDF pages and delete it/them in both .NET web and Windows
how to rotate just one page in pdf; rotate all pages in pdf and save
HowtheSASSystemHandles DateandTimeValues
135
You c
a
n
a
lso se
tt
he SS_MIXEDenvi
r
onmen
t
v
ar
i
a
ble
t
o
YES
inyou
r
SAS
configu
rat
ion file so
t
h
at
bo
t
hnume
r
ic
a
nd ch
ara
c
t
e
r
d
ataar
edispl
a
yed
a
sSAS
ch
ara
c
t
e
r
d
ata
. Add
t
hisline
t
oyou
r
SAS configu
rat
ion file:
-SET SS_MIXED YES
See “Se
tt
ingEnvi
r
onmen
t
V
ar
i
a
bles” on p
a
ge 142 fo
r
mo
r
einfo
r
m
at
ionon
envi
r
onmen
t
v
ar
i
a
bles. Fo
r
mo
r
einfo
r
m
at
iononch
a
nging
t
he column
t
ype f
r
om
t
he
t
ype de
t
e
r
mined by SAS/ACCESS sof
t
w
ar
ewhen youc
r
e
at
e
a
n
a
ccess desc
r
ip
t
o
r
,
r
efe
r
t
o
t
he sec
t
ions onXLS-specific p
r
ocedu
r
es
tat
emen
t
sl
at
e
r
in
t
his ch
a
p
t
e
r
.
How the SAS System Handles Date and Time Values
The conve
r
sion of d
at
e
a
nd
t
ime v
a
luesbe
t
ween SASd
ata
se
t
s
a
nd Mic
r
osof
t
Excel
sp
r
e
a
dshee
t
sis
tra
nsp
ar
en
tt
ouse
r
s. Howeve
r
,you
ar
eencou
ra
ged
t
ounde
r
s
ta
nd
t
he
diffe
r
ences be
t
ween
t
hem.
Mic
r
osof
t
Excel d
at
e
a
nd
t
ime v
a
lues
a
nd fo
r
m
at
s
ar
edesc
r
ibed in “XLS D
ata
Types”
onp
a
ge 134.
Datetime Conversions in the ACCESS Procedure
Asdesc
r
ibede
ar
lie
r
in
t
his ch
a
p
t
e
r
,
a
nXLSd
at
ev
a
lueis
t
he in
t
ege
r
po
rt
ionof
a
numbe
rt
h
atr
ep
r
esen
t
s
t
he numbe
r
of d
a
ys be
t
ween
Ja
nu
ar
y1, 1900
a
nd
a
specified
d
at
e. AnXLS
t
ime v
a
lue is
a
decim
a
lpo
rt
ion of
a
numbe
rt
h
atr
ep
r
esen
t
s
t
ime
a
s
a
po
rt
ion of
t
he d
a
y. Fo
r
ex
a
mple, 0.0 is 12:00:00
a
.m.,
a
nd 0.9999884is11:59:59 p.m.
While
a
numbe
r
c
a
nh
a
ve bo
t
h
a
d
at
e
a
nd
at
ime po
rt
ion,
t
he fo
r
m
at
sin XLS displ
a
y
a
numbe
r
only in
a
d
at
efo
r
m
at
o
r
in
at
ime fo
r
m
at
. Fo
r
ex
a
mple, fo
r
1:00 p.m., M
ar
ch
12, 1994,
t
he XLS d
at
ev
a
lue is 34405,
t
he
t
ime v
a
lue is0.5416667,
a
nd
t
he d
at
e
t
ime
v
a
lue is 34405.5416667.*
The SAS Sys
t
em h
a
ndles d
at
e
a
nd
t
ime v
a
luesdiffe
r
en
t
ly
t
h
a
nXLS. A SAS d
at
e
v
a
lue is
a
nin
t
ege
rt
h
atr
ep
r
esen
t
s
t
he numbe
r
of d
a
ysbe
t
ween
Ja
nu
ar
y1, 1960
a
nd
a
specified d
at
e. A SAS
t
ime v
a
lue is
a
nin
t
ege
rt
h
atr
ep
r
esen
t
s
t
he numbe
r
of seconds
since midnigh
t
of
t
he cu
rr
en
t
d
a
y. When
a
d
at
e
a
nd
at
ime
ar
ebo
t
hp
r
esen
t
,
t
he SAS
Sys
t
em s
t
o
r
es
t
he v
a
lue
a
s
t
he numbe
r
of seconds since midnigh
t
,
Ja
nu
ar
y1, 1960. Fo
r
ex
a
mple, fo
r
1:00 p.m., M
ar
ch12, 1994,
t
he SAS d
at
ev
a
lue is12489,
a
nd
t
he SAS
t
ime
v
a
lue is 46800. The
r
efo
r
e,
t
he SAS d
at
e
t
ime v
a
lue is 1079096400.
Whenyouc
r
e
at
e
a
n
a
ccessdesc
r
ip
t
o
r
,
t
he SAS Sys
t
em conve
rt
s
a
nXLS d
at
e
t
ime
fo
r
m
att
oi
t
sco
rr
esponding SAS d
at
e
t
ime fo
r
m
at
if
a
nXLSd
at
e
t
ime fo
r
m
at
isspecified
fo
rt
he v
ar
i
a
ble in
t
he XLSfile. No
t
e
t
h
at
if
t
he d
at
e
t
ime v
a
lue does no
t
h
a
ve
a
nXLS
fo
r
m
at
in
t
he XLS file,
t
he SAS Sys
t
em
tr
e
at
s
t
he d
at
e
t
ime v
a
lue like
a
nume
r
ic v
a
lue.
Toconve
rta
nXLS d
at
e
t
imefo
r
m
att
o
a
SAS d
at
e
t
ime fo
r
m
at
,you need
a
SAS
d
at
e
t
ime fo
r
m
at
in
t
he
a
ccessdesc
r
ip
t
o
r
. Fo
r
ex
a
mple, ch
a
nging
t
he def
a
ul
t
SAS
nume
r
ic fo
r
m
at
(15.2)
t
o
a
SAS d
at
efo
r
m
at
in
t
he desc
r
ip
t
o
r
c
a
uses
t
he XLSd
at
ev
a
lue
(b
a
sed on
Ja
nu
ar
y1, 1900)
t
obe conve
rt
ed
t
o
a
nequiv
a
len
t
SAS d
at
ev
a
lue (b
a
sed on
Ja
nu
ar
y1, 1960). In o
t
he
r
wo
r
ds,
t
he XLS nume
r
ic v
a
lue fo
rJa
nu
ar
y1, 1960 (which is
21916) isconve
rt
ed
t
o
t
he equiv
a
len
t
SAS
r
ep
r
esen
tat
ionof
Ja
nu
ar
y1, 1960 (whichis
0) only if
a
SASd
at
e
t
ime fo
r
m
at
is
a
ssigned in
t
he desc
r
ip
t
o
r
fo
rt
h
at
column.
O
t
he
r
wise,
t
he XLS v
a
lue of 21916 is
tr
e
at
ed
a
s
a
SAS nume
r
ic v
a
lue of21916.
The following
ta
ble showshow
t
he SAS Sys
t
em uses
a
Mic
r
osof
t
Excel d
at
e
t
ime
v
a
lue
t
oconve
rtt
o
a
SAS d
at
e
t
ime fo
r
m
at
.
*
In
t
hisdesc
r
ip
t
ion,d
at
e
t
ime(inlowe
r
c
a
se)
r
efe
r
s
t
o
a
nyv
a
lueo
r
fo
r
m
att
h
atr
ep
r
esen
t
s
a
d
at
e,
at
ime, o
r
bo
t
h
a
d
at
e
a
nd
a
t
ime.
C# PDF: C# Code to Process PDF Document Page Using C#.NET PDF
for developers on how to rotate PDF page in different two different PDF documents into one large PDF C# PDF Page Processing: Split PDF Document - C#.NET PDF
rotate pages in pdf and save; how to rotate all pages in pdf at once
C# PDF copy, paste image Library: copy, paste, cut PDF images in
This C#.NET example describes how to copy an image from one page of PDF document and paste it into another page. // Define input and output documents.
rotate single page in pdf reader; permanently rotate pdf pages
136
ACCESSProcedureDataConversions
Chap
t
er 10
Table 10.1 Value-to-Format Conversions
Fo
ra
SASfo
r
m
at
SASSys
t
emuses
d
at
e
in
t
ege
r
po
rt
ion of
t
he Mic
r
osof
t
Excel numbe
r
t
ime
decim
a
lpo
rt
ionof
t
heMic
r
osof
t
Excel numbe
r
d
at
e-
a
nd-
t
ime
in
t
ege
ra
nddecim
a
lpo
rt
ionof
t
heMic
r
osof
t
Excelnumbe
r
Datetime Conversions in the DBLOAD Procedure
If
a
SAS v
ar
i
a
ble is specified wi
t
h
a
d
at
e,
t
ime, o
r
d
at
e
t
ime fo
r
m
at
in
t
he FORMAT
s
tat
emen
t
,
t
he in
t
e
r
f
a
ce view engine conve
rt
s
t
h
at
SAS d
at
e
t
ime fo
r
m
at
in
t
o
t
he
equiv
a
len
t
Mic
r
osof
t
Exceld
at
e
t
ime fo
r
m
at
when
t
he new XLS file is c
r
e
at
ed.
Howeve
r
,if
a
SAS d
at
e
t
ime fo
r
m
at
is no
t
specified in
t
he inpu
t
SAS d
ata
se
t
,you
h
a
ve
t
o
a
ssign
a
fo
r
m
at
by using
a
PROC DBLOAD FORMAT s
tat
emen
t
. Doingso
a
ssigns
a
Mic
r
osof
t
Excel d
at
e
t
ime fo
r
m
att
o
t
he SAS v
ar
i
a
ble when
t
he v
ar
i
a
ble is
lo
a
ded in
t
o
a
nXLS file. If youdo no
ta
ssign
a
SAS d
at
e
t
ime fo
r
m
at
,
t
he SAS nume
r
ic
v
a
lue fo
rt
he d
at
eis w
r
i
tt
en
t
o
t
he XLS file. Bec
a
use SASd
at
es
ar
eb
a
sed on
Ja
nu
ar
y
1, 1960,
a
nd Mic
r
osof
t
Excel d
at
es
ar
eb
a
sed on
Ja
nu
ar
y1, 1900,
t
he d
at
ev
a
lue in
t
he
XLS file will be in
a
ccu
rat
e.
To m
a
in
ta
in
a
SAS v
ar
i
a
ble fo
r
m
at
in
t
he inpu
t
d
ata
se
t
,ye
t
ch
a
nge i
t
jus
t
while
t
he
DBLOAD p
r
ocedu
r
eis in p
r
og
r
ess, use
t
he FORMAT s
tat
emen
t
inPROC DBLOAD.
This s
tat
emen
t
en
a
blesyou
t
o
a
ssign
at
empo
rar
yfo
r
m
att
o
a
SASv
ar
i
a
ble fo
rt
he
du
rat
ion of
t
he p
r
ocedu
r
ewi
t
hou
ta
ffec
t
ing
t
he inpu
t
SAS d
ata
se
t
.
Fo
r
ex
a
mple, if
t
he SAS fo
r
m
at
fo
rt
he BIRTHDAT v
ar
i
a
ble in
t
he
MYDATA.SASEMPS
a
ccessdesc
r
ip
t
o
r
is lef
tatt
he def
a
ul
t
15.2 fo
r
m
at
,youc
a
nspecify
t
he FORMAT s
tat
emen
tt
och
a
nge
t
he v
ar
i
a
ble’sfo
r
m
att
oDATE7. while you
ar
e
c
r
e
at
ing
a
nd lo
a
ding
t
he XLSfile. Whenyou lo
a
d
t
he XLS file,
t
he DATE7. fo
r
m
at
becomes
a
nequiv
a
len
t
Mic
r
osof
t
columnfo
r
m
at
,DDMMMYY. When
t
he DBLOAD
p
r
ocedu
r
eh
a
scomple
t
ed,
t
he SAS fo
r
m
at
fo
rt
he BIRTHDAT v
ar
i
a
ble
r
e
t
u
r
ns
t
o
t
he
15.2 fo
r
m
at
.
You c
a
nspecify
t
he FORMAT s
tat
emen
t
in
t
he PROC DBLOADs
tat
emen
t
when you
invoke
t
he p
r
ocedu
r
eusing
a
nyof
t
he me
t
hods of p
r
ocessing.
ACCESS Procedure Data Conversions
Use PROC ACCESS
t
odefine desc
r
ip
t
o
r
s
t
h
at
iden
t
ify sp
r
e
a
dshee
t
d
ataa
nd
t
he
conve
r
sions necess
ar
y
t
ouse
t
he d
ata
inSAS p
r
og
ra
ms. The Mic
r
osof
t
Excel l
a
bel d
ata
t
ype is fo
r
m
att
ed
a
s
a
SASch
ara
c
t
e
rt
ype,
a
nd
t
he Mic
r
osof
t
Excel numbe
r
d
atat
ype is
fo
r
m
att
ed
a
s
a
SAS nume
r
ic
t
ype.
Fon
t
s,
attr
ibu
t
es,
a
nd colo
r
sin
t
he XLS files
ar
eno
tr
e
a
din
t
o
t
he SAS d
ata
se
t
s.
Howeve
r
,
t
he ACCESS p
r
ocedu
r
esuppo
rt
smos
t
of
t
he XLS numbe
r
fo
r
m
at
s
a
nd
a
u
t
om
at
ic
a
lly conve
rt
s
t
hem
t
o
t
he co
rr
esponding SAS fo
r
m
at
s. AnyXLS d
ata
s
tr
ings
longe
rt
h
a
n200 ch
ara
c
t
e
r
s
ar
e
tr
unc
at
ed while beingconve
rt
ed in
t
oSAS d
ata
se
t
s,
a
nd
a
ny SAS d
ata
file c
r
e
at
ed f
r
om XLS files c
a
ncon
ta
inup
t
o256v
ar
i
a
bles
a
nd 16,384
obse
r
v
at
ions.
T
a
ble 10.2 on p
a
ge 137 shows
t
he def
a
ul
t
SAS Sys
t
em v
ar
i
a
blefo
r
m
at
s
t
h
att
he
ACCESSp
r
ocedu
r
e
a
ssigns
t
oe
a
ch
t
ype of s
ta
nd
ar
dXLS file d
ata
. T
a
ble 10.3 on p
a
ge
139p
r
ovides SAS Sys
t
em v
ar
i
a
ble fo
r
m
at
sfo
r
cus
t
omized XLSfo
r
m
at
s
tr
ings. XLSfile
nume
r
ic d
ata
include d
at
e
a
nd
t
ime v
a
lues. See “How
t
he SASSys
t
em H
a
ndles D
at
e
a
nd Time V
a
lues” on p
a
ge 135 fo
r
mo
r
einfo
r
m
at
ion.
ACCESSProcedureDataConversions
137
Table 10.2 DefaultSAS SystemVariableFormatsfor XLS FileData
XLSFile D
ata
SASV
ar
i
a
bleFo
r
m
at
D
ata
Type
XLSFo
r
m
at
S
tr
ing
Type
Fo
r
m
at
Ch
ar
1
@
2
Ch
ar
$w.
Nume
r
ic
3
Gene
ra
l
Num
BEST
Nume
r
ic
0
Num
w.d
Nume
r
ic
0.00
Num
w.d
Nume
r
ic
#,##0
Num
COMMAw.d
Nume
r
ic
#,##0.00
Num
COMMAw.d
Nume
r
ic
#,##0_);(#,##0)
Num
NEGPARENw.d
Nume
r
ic
#,##0_);[Red](#,##0)
Num
NEGPARENw.d
Nume
r
ic
#,##0.00_);(#,##0.00)
Num
NEGPARENw.d
Nume
r
ic
#,##0.00_);[Red](#,##0.00)
Num
NEGPARENw.d
Nume
r
ic
$#,##0_);($#,##0)
Num
DOLLARw.d
Nume
r
ic
$#,##0_);[Red]($#,##0)
Num
DOLLARw.d
Nume
r
ic
($#,##0.00_);($#,##0.00)
Num
DOLLARw.d
Nume
r
ic
($#,##0.00_);[Red]($#,##0.00)
Num
DOLLARw.d
Nume
r
ic
_($*#,##0_);_($*(#,##0);_($*"-
"_);_(@_)
Num
DOLLARw.d
Nume
r
ic
_(*#,##0_);_(*(#,##0);_(*"-
"_);_(@_)
Num
NEGPARENw.d
Nume
r
ic
_($*#,##0.00_);_($*(#,##0.00);_($*"-
"??_);_(@_)
Num
DOLLARw.d
Nume
r
ic
_(*#,##0.00_);_(*(#,##0.00);_(*"-
"??_);_(@_)
Num
NEGPARENw.d
Nume
r
ic
0%
Num
PERCENTw.d
Nume
r
ic
0.00%
Num
PERCENTw.d
Nume
r
ic
0.00E+00
Num
Ew.d
Nume
r
ic
##0.0E+0
Num
Ew.d
Nume
r
ic
m
/
d
/
yy
Num
MMDDYYw.
Nume
r
ic
d-mmm-yy
Num
MMDDYYw.
Nume
r
ic
d-mmm
Num
DATEw.
Nume
r
ic
mmm-yy
Num
MONYYw.
Nume
r
ic
h:mmAM/PM
Num
TIMEw.
Nume
r
ic
h:mm:ssAM/PM
Num
TIMEw.
Nume
r
ic
h:mm
Num
TIMEw.
Nume
r
ic
hh:mm
Num
TIMEw.
Nume
r
ic
h:mm:ss
Num
TIMEw.
138
ACCESSProcedureDataConversions
Chap
t
er 10
XLSFile D
ata
SASV
ar
i
a
bleFo
r
m
at
D
ata
Type
XLSFo
r
m
at
S
tr
ing
Type
Fo
r
m
at
Nume
r
ic
hh:mm:ss
Num
TIMEw.
Nume
r
ic
m
/
d
/
yy h:mm
Num
DATETIMEw.
Nume
r
ic
ddmmmyy
Num
DATEw.
Nume
r
ic
ddmmmyyyy:hh:mm:ss
Num
DATETIMEw.
Nume
r
ic
dd
Num
DATEw.
Nume
r
ic
dd
/
mm
/
yy
Num
DDMMYYw.
Nume
r
ic
dddd
Num
DATEw.
Nume
r
ic
mm
/
dd
/
yy
Num
MMDDYYw.
Nume
r
ic
mm:ss
Num
MMSSw.
Nume
r
ic
mmyy
Num
MONYYw.
Nume
r
ic
mmyyyy
Num
MONYYw.
Nume
r
ic
mm:yy
Num
MONYYw.
Nume
r
ic
mm:yyyy
Num
MONYYw.
Nume
r
ic
mm-yy
Num
MONYYw.
Nume
r
ic
mm-yyyy
Num
MONYYw.
Nume
r
ic
mmyy
Num
MONYYw.
Nume
r
ic
mmyyyy
Num
MONYYw.
Nume
r
ic
mm.yy
Num
MONYYw.
Nume
r
ic
mm.yyyy
Num
MONYYw.
Nume
r
ic
mm
/
yy
Num
MONYYw.
Nume
r
ic
mm
/
yyyy
Num
MONYYw.
Nume
r
ic
mmmm
Num
MONYYw.
Nume
r
ic
m
Num
MONYYw.
Nume
r
ic
mmmyy
Num
MONYYw.
Nume
r
ic
mmmyyyy
Num
MONYYw.
Nume
r
ic
dddd,mmmmdd,yyyy
Num
MONYYw.
Nume
r
ic
dddd,dd mmmmyyyy
Num
MONYYw.
Nume
r
ic
mmmmdd,yyyy
Num
MONYYw.
Nume
r
ic
dd mmmmyyyy
Num
MONYYw.
Nume
r
ic
yy
Num
YYMMDDw.
Nume
r
ic
yyyy
Num
YYMMDDw.
Nume
r
ic
yymm
Num
YYMMDDw.
Nume
r
ic
yyyy mm
Num
YYMMDDw.
Nume
r
ic
yy:mm
Num
YYMMDDw.
Nume
r
ic
yyyy:mm
Num
YYMMDDw.
Nume
r
ic
yy-mm
Num
YYMMDDw.
ACCESSProcedureDataConversions
139
XLSFile D
ata
SASV
ar
i
a
bleFo
r
m
at
D
ata
Type
XLSFo
r
m
at
S
tr
ing
Type
Fo
r
m
at
Nume
r
ic
yyyy-mm
Num
YYMMDDw.
Nume
r
ic
yymm
Num
YYMMDDw.
Nume
r
ic
yyyymm
Num
YYMMDDw.
Nume
r
ic
yy.mm
Num
YYMMDDw.
Nume
r
ic
yyyy.mm
Num
YYMMDDw.
Nume
r
ic
yy
/
mm
Num
YYMMDDw.
Nume
r
ic
yyyy
/
mm
Num
YYMMDDw.
Nume
r
ic
yy-mm-dd
Num
YYMMDDw.
Nume
r
ic
yymmm
Num
YYMMDDw.
Nume
r
ic
yyyymmm
Num
YYMMDDw.
1
L
a
beld
ata
.
2
TheXLS ch
ara
c
t
e
r
fo
r
m
at
fo
r
ExcelVe
r
sion5.0.
3
Numbe
r
,fo
r
mul
a
,o
r
missingd
ata
.
Table 10.3 DefaultSAS SystemVariableFormatsfor Customized XLS FormatStrings
XLSFile D
ata
SASV
ar
i
a
ble Fo
r
m
at
D
ata
Type
XLSFo
r
m
at
S
tr
ing
Type
Fo
r
m
at
Nume
r
ic
"$"
Num
DOLLARw.d
Nume
r
ic
"E"
Num
Ew.d
Nume
r
ic
"m,d
a
ndy"
Num
MMDDYYw.
Nume
r
ic
"m
a
ndh"
Num
TIMEw.d
Nume
r
ic
"m
a
nds"
Num
TIMEw.d
Nume
r
ic
"m
a
ndy"
Num
MONYYw.
Nume
r
ic
"m"
Num
DATEw.
Nume
r
ic
"d"
Num
DATEw.
Nume
r
ic
"y"
Num
DATEw.
Nume
r
ic
"0.0"
Num
w.d
Nume
r
ic
F
ra
c
t
ion v
a
lues(#?/?)
Num
BESTw.d
Nume
r
ic
Pe
r
cen
t
v
a
lues(0.0%)
Num
PERCENTw.d
Nume
r
ic
Allo
t
he
r
s
Num
BESTw.d
No
t
e
t
h
at
wisb
a
sed onExcelcolumnwid
t
h;.d is con
tr
olled by
t
he Excelfo
r
m
at
s
tr
ing.
If XLSfile d
ata
f
a
ll ou
t
side of
t
he v
a
lid SAS d
atara
nges, you
r
eceive
a
ne
rr
o
r
mess
a
ge in
t
he SAS log whenyou
tr
y
t
o
a
ccess
t
he d
ata
.
The SAS/ACCESSin
t
e
r
f
a
ce does no
t
fully suppo
rtt
he Mic
r
osof
t
Excel hidden
a
nd
t
ex
t
fo
r
m
at
s. XLS d
ata
inhiddenfo
r
m
atar
edispl
a
yed in SAS d
ata
se
t
s; howeve
r
,you
c
a
nd
r
op
t
he hiddencolumnwhen you
ar
ec
r
e
at
ing
t
he
a
ccessdesc
r
ip
t
o
r
. If youw
a
n
tt
o
displ
a
y
t
he fo
r
mul
a
in
t
he
t
ex
t
fo
r
m
at
,
a
dd
a
sp
a
ce
t
oindic
at
e
t
h
att
he fo
r
mul
a
en
tr
yis
a
l
a
bel. O
t
he
r
wise,
t
he
r
esul
t
sof
t
he fo
r
mul
aar
edispl
a
yed.
140
DBLOADProcedureDataConversions
Chap
t
er 10
If youh
a
ve se
tt
he SS_MIXEDenvi
r
onmen
t
v
ar
i
a
ble
t
oYES,
t
he nume
r
ic
a
lv
a
luesin
XLS files
ar
econve
rt
ed
t
och
ara
c
t
e
r
s
tr
ingsin SAS d
ata
se
t
sif
t
he co
rr
esponding SAS
v
ar
i
a
ble
t
ype isspecified
a
sch
ara
c
t
e
r
.
DBLOAD Procedure Data Conversions
This sec
t
ion expl
a
ins how SAS d
ataar
e
r
e
a
din
t
oMic
r
osof
t
Excel d
ata
when
ata
ble
is lo
a
ded. In
t
his conve
r
sion,
t
he SAS ch
ara
c
t
e
r
d
atat
ype isconve
rt
ed in
t
o
t
he
Mic
r
osof
t
Excel l
a
bel
t
ype
a
nd
t
he SAS nume
r
ic
t
ype is conve
rt
ed in
t
o
t
he Mic
r
osof
t
Excel numbe
rt
ype.
The SAS/ACCESS in
t
e
r
f
a
ce
a
u
t
om
at
ic
a
lly conve
rt
sSAS fo
r
m
at
s
t
o
t
he s
a
me o
r
a
ssoci
at
ed Mic
r
osof
t
Excel fo
r
m
at
s
a
nd columnwid
t
hs. Howeve
r
,youc
a
n
t
empo
rar
ily
a
ssigno
t
he
r
fo
r
m
at
s
a
nd columnwid
t
hs
t
oSAS v
ar
i
a
bles by using
t
he FORMAT
s
tat
emen
t
so
t
h
att
he lo
a
ded XLS file columns h
a
ve
t
he fo
r
m
at
syouw
a
n
t
. T
a
ble 10.4
onp
a
ge 140 shows
t
he SAS Sys
t
em v
ar
i
a
ble
t
ypes
a
ndfo
r
m
at
s
a
nd
t
he XLS d
atat
ypes,
fo
r
m
at
s,
a
nd columnwid
t
hs
t
h
at
you c
a
n
a
ssign
t
hem
t
o.
No
t
e: TheFORMATs
tat
emen
t
in PROC DBLOAD only ch
a
nges
t
he fo
r
m
at
of SAS
v
ar
i
a
bles while you
ar
ec
r
e
at
ing
a
nd lo
a
ding
t
he XLS files. When
t
he p
r
ocedu
r
eis
comple
t
ed,
t
he fo
r
m
at
sof SAS v
ar
i
a
bles
r
e
t
u
r
n
t
o
t
hei
r
o
r
igin
a
lse
tt
ings.
XLS v
a
lues
ar
enume
r
ic d
ata
. See “How
t
he SASSys
t
em H
a
ndles D
at
e
a
nd Time
V
a
lues”on p
a
ge 135 fo
r
mo
r
einfo
r
m
at
ion.
Table 10.4 ConvertingSAS SystemVariableFormats to XLS FileData
SASV
ar
i
a
bleFo
r
m
at
XLSFileD
ata
Type
Fo
r
m
at
XLSFo
r
m
at
S
tr
ing
D
ata
Type
Ch
ar
""
Gene
ra
l
LABEL
Ch
ar
$CHAR
Gene
ra
l
LABEL
Ch
ar
$
Gene
ra
l
LABEL
Num
BESTw.d
Gene
ra
l
NUMBER
Num
COMMAw.d
#,##0
NUMBER
Num
COMMAXw.d
#,##0
NUMBER
Num
DATEw.
ddmmmyy
NUMBER
Num
DATETIMEw.d
ddmmmyyyy:hh:mm:ss
NUMBER
Num
DAYw.
dd
NUMBER
Num
DDMMYYw.
dd/mm/yy
NUMBER
Num
DOLLARw.d
"$"#,##0_);("$"#,##0)
NUMBER
Num
DOLLARXw.d
"$"#,##0_);("$"#,##0)
NUMBER
Num
DOWNAMEw.d
dddd
NUMBER
Num
Ew.
0.00E+00
NUMBER
Num
HHMMw.d
h:mm
NUMBER
Num
HOURw.d
h:mm
NUMBER
Num
J
ULDAYw.
m/d/yy
NUMBER
Documents you may be interested
Documents you may be interested