sas slides 15 : improving effeciency with options in sas
TRANSCRIPT
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
1/17
QIQ Tcab`cq`feoNqiqtcab`cq&aol
btt~=//www&qiqtcab`cq&aol
mailto:[email protected]://www.sastechies.com/http://www.sastechies.com/mailto:[email protected] -
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
2/17
Wbcf pos qtoxc posx diti`f i QIQ diti e`jc* pos sqctbc qsl oe tbc ditiqtoxigc q~iac tbit `qxcys`xcd eox tbc eojjow`fg= tbc dcqax`~tox ~oxt`of tbc ohqcxuit`ofq ifp qtoxigc oucxbcid ifp iqqoa`itcd `fdcrcq&
Tcabf`yscq= Gct x`d oe wiqtc q~iac Aol~xcqq ditiqctq Sqc U`cwq
99/91/>0 8QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
3/17
JCFGTB uix`ihjc"q) $jcfgtb; wbcxc uix`ihjc"q) q~ca`e`cq tbc filc oe
ofc ox loxc QIQ uix`ihjcq*qc~ixitcd hp q~iacq&
jcfgtb `q if `ftcgcx exol 9 to18*757 tbit q~ca`e`cq tbc jcfgtboe tbc uix`ihjc"q)&
QIQ iqq`gfq i dceisjt jcfgtboe 2 hptcq to tbc Abixiatcxuix`ihjc
QIQ abixiatcx uix`ihjcqqtoxc diti iq 9 abixiatcx~cx hptc& I QIQ abixiatcx
uix`ihjc aif hc exol 9 to18*757 hptcq `f jcfgtb&
Ofc wip to xcdsac tbcilosft oe diti qtoxigcq~iac tbit pos fccd `q toxcdsac tbc jcfgtb oeabixiatcx diti* tbcxchpcj`l`fit`fg wiqtcd q~iac&@fqtcid oe xcaoxd`fg tbcaol~jctc filc `f tbc ditiqct* pos aosjd iqq`gf iaodc/ihhxcu`it`of&
99/91/>0 1QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
4/17
Tbc dceisjt jcfgtb eox i fslcx`auix`ihjc `q 2 hptcq&
QIQ qtoxcq ijj fslcx`a uijscq sq`fgdoshjc,~xca`q`of ejoit`fg,~o`ftxc~xcqcftit`of& QIQ qtoxcq tbc uijscoe i fslcx`a uix`ihjc iq lsjt`~jcd`g`tq ~cx hptc& I QIQ fslcx`auix`ihjc aif hc exol 8 to 2 hptcq ox1 to 2 hptcq `f jcfgtb* dc~cfd`fg ofposx o~cxit`fg cfu`xoflcft&
JCFGTB uix jcfgtb:DCEISJT
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
5/17
Aol~xcqq`fg i diti e`jc `q i ~xoacqq tbit xcdsacq tbcfslhcx oe hptcq tbit ixc xcys`xcd `f oxdcx to xc~xcqcftciab ohqcxuit`of `f i diti e`jc&
Xcid`fg exol ox wx`t`fg to i aol~xcqqcd e`jc dsx`fg diti
~xoacqq`fg xcys`xcq ecwcx @/O o~cxit`ofq hcaisqc tbcxcixc ecwcx diti qct ~igcq `f i aol~xcqqcd diti e`jc&
Bowcucx* `f oxdcx to xcid i aol~xcqqcd e`jc* ciabohqcxuit`of lsqt hc sfaol~xcqqcd& Tb`q xcys`xcq loxc
A^S xcqosxacq tbif xcid`fg if sfaol~xcqqcd e`jc&
Ijqo* `f qolc aiqcq* aol~xcqq`fg i e`jc l`gbt iatsijjp`faxciqc `tq q`}c xitbcx tbif dcaxciq`fg `t&
99/91/>0 3QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
6/17
Hp dceisjt* i QIQ diti e`jc `q fot aol~xcqqcd& @fsfaol~xcqqcd diti e`jcq*
ciab diti uijsc ifd ciab ohqcxuit`ofoaas~`cq tbc qilc fslhcx oe hptcq iq ifpotbcx diti uijsc oe tbit uix`ihjc&
abixiatcx uijscq ixc ~iddcd w`tb hjifkq&
fslcx`a uijscq ixc ~iddcd w`tb h`fixp }cxoq&
tbcxc `q i 95,hptc oucxbcid it tbc hcg`ff`fg oe
ciab ~igc&
tbcxc `q i 9,h`t ~cx ohqcxuit`of oucxbcid"xosfdcd s~ to tbc fcixcqt hptc) it tbc cfd oeciab ~igc; tb`q h`t dcfotcq if ohqcxuit`of'qqtitsq iq dcjctcd ox fot dcjctcd&
fcw ohqcxuit`ofq ixc iddcd it tbc cfd oe tbce`jc& @e i fcw ohqcxuit`of wof't e`t of tbcasxxcft jiqt ~igc oe tbc e`jc* i wbojc fcw diti
qct ~igc `q iddcd&
tbc dcqax`~tox ~oxt`of oe tbc diti e`jc `q qtoxcdit tbc cfd oe tbc e`xqt ~igc oe tbc e`jc&
Aol~xcqqcd diti e`jcq txcit if ohqcxuit`of iq i q`fgjc
qtx`fg oe hptcq hp `gfox`fguix`ihjc tp~cq ifd hosfdix`cq&
aojji~qc aofqcast`uc xc~cit`fgabixiatcxq ifd fslhcxq `fto
ecwcx hptcq&
aofti`f i 82,hptc oucxbcid ittbc hcg`ff`fg oe ciab ~igc&
aofti`f i 98,hptc, ox 84,hptc,~cx,ohqcxuit`of oucxbcid
eojjow`fg tbc ~igc oucxbcid&Tb`q q~iac `q sqcd eox dcjct`ofqtitsq* aol~xcqqcd jcfgtb*~o`ftcxq* ifd ejigq&
99/91/>0 5QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
7/17
I diti e`jc `q fot i goodaifd`ditc eoxaol~xcqq`of `e `t biq ecw xc~citcd abixiatcxq qlijj ~bpq`aij q`}c ecw l`qq`fg uijscq qboxt tcrt qtx`fgq&
aol~xcqq`of aif hchcfce`a`ij wbcf tbc ditie`jc biq ofc ox loxc oe tbceojjow`fg ~xo~cxt`cq= @t `q jixgc& @t aofti`fq lifp jofg
abixiatcx uijscq& @t aofti`fq lifp uijscq
tbit biuc xc~citcdabixiatcxq ox h`fixp }cxoq&
@t aofti`fq lifp l`qq`fguijscq&
@t aofti`fq xc~citcd uijscq
`f uix`ihjcq tbit ixc~bpq`aijjp qtoxcd fcrt toofc ifotbcx&
99/91/>0 7QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
8/17
To aol~xcqq i diti e`jc* pos sqcc`tbcx tbc AOL^XCQQ< diti qcto~t`of ox tbc AOL^XCQQ< qpqtclo~t`of&
Pos sqc tbc AOL^XCQQ< qpqtclo~t`of to aol~xcqq ijj diti e`jcq tbitpos axcitc dsx`fg i QIQ qcqq`of&
Q`l`jixjp* pos sqc tbc AOL^XCQQ0 2QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
9/17
Ifotbcx wip to qiuc d`qkq~iac `q to jciuc posx diti`f `tq ox`g`fij joait`of ifdsqc i QIQ diti u`cw toiaacqq `t&
I QIQ diti e`jc ifd i QIQditi u`cw ixc hotb tp~cq oeQIQ diti qctq& Tbc e`xqttp~c* i QIQ diti e`jc*aofti`fq hotb dcqax`~tox`feoxlit`of ihost tbc ditiifd tbc diti uijscq& Tbcqcaofd tp~c* i QIQ ditiu`cw* aofti`fq ofjpdcqax`~tox feoxlit`ofihost tbc diti ifd`fqtxsat`ofq of bow toxctx`cuc diti uijscq tbitixc qtoxcd cjqcwbcxc&
99/91/>0 0QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
10/1799/91/>0 9>QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
11/17
sqc o~t`ofq ifd i qtitclcft toaoftxoj tbc q`}c ifd fslhcx oediti hseecxq* wb`ab `f tsxf aifieecat posx ~xogxilq' crcast`oft`lcq hp xcdsa`fg tbc fslhcx oe@/O o~cxit`ofq tbit QIQ lsqt~cxeoxl&
Wbcf pos axcitc i QIQ diti qctsq`fg i DITI qtc~* QIQ ao~`cq tbc diti exol tbc `f~st
diti qct to i hseecx `f lcloxp
ofc ohqcxuit`of it i t`lc `q joidcd`fto tbc ~xogxil diti ucatox
ciab ohqcxuit`of `q wx`ttcf to ifost~st hseecx wbcf ~xoacqq`fg `q
aol~jctc tbc aoftcftq oe tbc ost~st hseecx
ixc wx`ttcf to tbc d`qk wbcf tbchseecx `q esjj
99/91/>0 99QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
12/17
o~t`ofq hseq`}c78> hsefo;e`jcfilc oxdcxq 'a=Zoxdcxq&dit';diti aol~ifp&oxdcxq_eiat;`fe`jc oxdcxq;:loxc QIQ aodc6 xsf;
abooq`fg i ~igc/hseecx q`}c tbit `qjixgcx tbif tbc dceisjt aif q~ccds~ crcast`of t`lc hp xcdsa`fg tbcfslhcx oe t`lcq tbit QIQ lsqtxcid exol ox wx`tc to tbc qtoxigclcd`sl&
Pos aif sqc tbc HSEFO< qpqtcl oxditi qct o~t`of to aoftxoj tbcfslhcx oe hseecxq tbit ixc
iui`jihjc eox xcid`fg ox wx`t`fg iQIQ diti qct& Hp `faxciq`fg tbcfslhcx oe hseecxq* pos aif aoftxojbow lifp ~igcq oe diti ixc joidcd`fto lcloxp w`tb ciab @/O txifqecx&
Tbc ~xodsat oe HSEFO< ifdHSEQ@]C0 98QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
13/17
qiqe`jc aol~ifp&qijcq joid; ~xoa ~x`ft diti
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
14/17
99/91/>0 94QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
15/17
99/91/>0 93QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
16/17
99/91/>0 95QIQ Tcab`cq 8>>0
-
8/14/2019 SAS Slides 15 : Improving Effeciency With options in SAS
17/17
Hceoxc pos tcqt tbc ~xogxill`fg tcabf`yscq* tsxf of tbcQIQ qpqtcl o~t`ofq tbit xc~oxt xcqosxac sqigc&
Crcastc tbc aodc eox ciab ~xogxill`fg tcabf`ysc `f iqc~ixitc QIQ qcqq`of&
@f ciab ~xogxill`fg tcabf`ysc tbit pos ixc tcqt`fg* `fajsdcofjp tbc QIQ aodc tbit `q cqqcft`ij eox ~cxeoxl`fg tbc tiqk&
Xsf posx hcfablixk`fg tcqtq sfdcx tbc aofd`t`ofq `f wb`abposx e`fij ~xogxil w`jj xsf&
Ietcx tcqt`fg `q e`f`qbcd* aofq`dcx tsxf`fg oee tbc o~t`ofq tbitxc~oxt xcqosxac sqigc&
99/91/>0 97QIQ Tcab`cq 8>>0