강의자료 다운로드: http://www.sas.com/offices/asiapacific/korea/training/SAS_init.pdf

Sales Division
- 1
- 2
PSD
- Consulting
- Education
- Tech.Support

바젤II(은행권 리스크 관리) - 우리은행 2004년 처음 도입
SAS9 - 아키텍쳐를 완전히 개선한 시스템
EIP - Enterprize Intelligence Pletform

Data in -> (Analysis Module) -> Information Out -> Information Delivery

ACCESS PART : Use Example
Excel Data -> PC에서 SAS Data로 Convert -> UNIX로 Remote Processing -> 원하는 Architecture로 넣는다.


원하는 프로그래밍은 4GL and Procedures

DATA Part Exam
1. 블룸버그에서 Data
2. 개인 Excel Data
3. Merge
4. Transpose etc.
5. Reg.

ETL: Extract, Transport, and Loading (BI 공부할때 배웠던 걸 생각해라)

SAS DW는 SPDS를 사용한다. - 통계를 위해 가장 빠른 형태의 DATA
MDB, RDB와는 다른 독자적 Engine(Ver. 8 이후)
Multi-Thread의 퍼포먼스는 하드웨어의 성능에 따라 다르다. ppt 10 Page

BI of UI(Client Level) - DMS(코딩), EG(Use Mouse Click), AMO(Additional Microsoft Office - Word, Excel, PPT), ETL(JAVA Bace), OLAP(.net)

OLAP: 다차원적인 데이터를 보여줌.

Data Mining: 월마트 기저귀-맥주

invalid-file

DB관련 PPT


------------휴식시간-------------
http://support.sas.com/publishing/pubcat/chaps/59332.pdf


SAS Business Solution : CI;Customer Intelligence, FI;Financial Intelligence(BSC = SAS SPM(Strategic Performance Management), RI;Risk Intelligence


access: SAS ACCESS TO [DBMS, ORACLE, SyBase] -access module
af: develop tool
assist: menu.
common: sas file
connect: connection file
ets: SAS module(ARIMA, X11, Forecst, ....etc.) - for PROC use.
nls: national language support system folder
nls/ko: 2-Byte date process support / Korean language support

1. DMS(Display Management System)
---------------------
Out
---------------------
Log
---------------------
PGM
---------------------

2. EG - Click to use(Interface tool)

3. AMO(Additional Microsoft Office)
Excel/Word Window
-----------------------------------
                            | SAS|<- icon
----------------------------------- tool collection

4. SAS Tools(OLAP, ETL, Appder, etc.)

=====================================
Observation (ROW)
Variable(Column)
=====================================
Libname Mktdat <- d:\Market\data
Mktdat._________

Direct Path - max 8 char.
WORK._________ : 임시 Data 폴더
이름을 지정안하고 작업을 할 경우 WORK Library에 등록이 되므로, 종료시 작업 내용이 다 지워진다.
따라서, 이름을 지정하고 작업을 해야한다.
=====================================
사용자 라이버르러 할당
LIBNAME Lib_ref <engine> "Folder-Path" <Option>;
engine 부분에 6는 V6, 공백으로 처리하면 9로 있는다. 8은 읽어준다고 한다.
=====================================
http://172.26.12.3/education
과정명 SAS입문(data)
과정암호: init
=====================================
/* 확장 편집기에 작성하는 내용 */

LIBNAME init "c:\educ\init";

/* 첫자는 영문이고 숫자 영문 8자 이내 */

/* 위에 사람달려가는 실행버튼을 눌러라 */

Libname init_v6 v6 "c:\educ\init";

/* V6 엔진 파일도 있다. 실행은 두줄 드래그 해서 실행버튼을 누른다. */
=====================================
실행 아이콘 등록정보에가서 대상란에 가서 파일 뒤에 -autoexec "c:\~" 하면 같이 실행된다
=====================================
proc options;
run;
/* SAS 시스템을 입력하고 기본적으로 입력되어있는 옵션들을 보여줌 */
/* NOTE: SAS 9.1.3 Service Pack 3

NOTE: SAS 시스템 초기화 실행:
     실행 시간           0.62 초
     cpu 시간            0.57 초

1    proc options;
2    run;

  SAS (r) Proprietary Software Release 9.1  TS1M3

포터블 옵션:

APPLETLOC=C:\Program Files\SAS Institute\Shared Files\applets\9.1
                  Location of Java applets
ARMAGENT=         ARM Agent to use to collect ARM records
ARMLOC=ARMLOC.LOG Identify location where ARM records are to be written
ARMSUBSYS=(ARM_NONE)
                  Enable/Disable ARMing of SAS subsystems
NOASYNCHIO        Do not enable asynchronous input/output
AUTOSAVELOC=      Identifies the location where program editor contents are auto saved
NOAUTOSIGNON      SAS/CONNECT remote submit will not automatically attempt to SIGNON
NOBATCH           Do not use the batch set of default values for SAS system options
BINDING=DEFAULT   Controls the binding edge for duplexed output
BOTTOMMARGIN=0.000 MM
                  Bottom margin for printed output
BUFNO=1           Number of buffers for each SAS data set
BUFSIZE=0         Size of buffer for page of SAS data set
BYERR             Set the error flag if a null data set is input to the SORT procedure
BYLINE            Print the by-line at the beginning of each by-group
BYSORTED          Require SAS data set observations to be sorted for BY processing
NOCAPS            Do not translate source input to uppercase
NOCARDIMAGE       Do not process SAS source and data lines as 80-byte records
CATCACHE=0        Number of SAS catalogs to keep in cache memory
CBUFNO=0          Number of buffers to use for each SAS catalog
CENTER            Center SAS procedure output
NOCHARCODE        Do not use character combinations as substitute for special characters not on the keyboard
CLEANUP           Attempt recovery from out-of-resources condition
NOCMDMAC          Do not support command-style macros
CMPLIB=           Identify previously compiled libraries of CMP subroutines to use when linking
CMPOPT=(NOEXTRAMATH NOMISSCHECK NOPRECISE NOGUARDCHECK)
                  Enable SAS compiler performance optimizations
NOCOLLATE         Do not collate multiple copies of printed output
COLORPRINTING     Print in color if printer supports color
COMAMID=TCP       Specifies the communication access method to be used for SAS distributed products
COMPRESS=NO       Specifies whether to compress observations in output SAS data sets
CONNECTPERSIST    Persist connection to remote session
CONNECTREMOTE=    Remote session ID used by SAS/CONNECT software
CONNECTSTATUS     Show the current status of a SAS/CONNECT upload or download transfer
CONNECTWAIT       Wait for a SAS/CONNECT rsubmit to finish before allowing further processing to occur
COPIES=1          Number of copies to make when printing
CPUCOUNT=2        Number of processors available.
CPUID             Print CPU information at beginning of log
DATASTMTCHK=COREKEYWORDS
                  Control whether keywords such as SET, MERGE, etc. are accepted as one-level dataset names in the DATA
                  statement
DATE              Print date and time on top of each page of SAS log and procedure output
DATESTYLE=YMD     Identify sequence of month, day and year when ANYDATE informat data is ambiguous
DBSLICEPARM=(THREADED_APPS, 2)
                  Alter DBMS engine threaded read behavior by expanding or disallowing threaded reads.
DBSRVTP=NONE      Enable SAS server throughput for these SAS/Access products
NODETAILS         Do not display additional information in directory lists
DEVICE=           Graphics device driver
DFLANG=LOCALE     Language for EURDF date/time formats and informats
DKRICOND=ERROR    Action for DROP/KEEP/RENAME error conditions on input SAS data sets
DKROCOND=WARN     Action for DROP/KEEP/RENAME error conditions on output SAS data sets
DLDMGACTION=REPAIR
                  SAS System action taken when a damaged dataset or catalog is opened
NODMR             Invoke a local SAS session
DMS               Invoke the SAS Display Manager System
DMSEXP            Display Explorer, Program Editor, Log, and Output windows.
DMSLOGSIZE=99999  Maximum number of rows in DMS log window
DMSOUTSIZE=99999  Maximum number of rows in DMS output window
NODMSSYNCHK       Do not enable syntax check, in windowing mode, for a submitted statement block
DQLOCALE=         Data Quality best locale default and search order
DQSETUPLOC=C:\Program Files\SAS\SAS 9.1\dquality\sasmisc\dqsetup.txt
                  SAS Data Quality - Cleanse setup file
DSNFERR           Generate error when SAS data set not found condition occurs
NODTRESET         Do not update date and time for log and print output
NODUPLEX          Do not print output in duplex mode
NOECHOAUTO        Do not echo AUTOEXEC input to log
EMAILAUTHPROTOCOL=NONE
                  Identifies the SMTP e-mail authentication protocol
EMAILHOST=LOCALHOST
                  SMTP server host for email access method
EMAILID=          From E-mail address, log in id, or profile for use with underlying e-mail system
EMAILPORT=25      Port number for SMTP server for email access method
EMAILPW=          Used by the E-mail Access Method and Send menu item to set the email session login password for the
                  underlying e-mail system
ENGINE=V9         Default access method for SAS data libraries
NOERRORABEND      Do not abend on error conditions
NOERRORBYABEND    Do not abend on By-group error condition
ERRORCHECK=NORMAL Level of special error processing to be performed
ERRORS=20         Maximum number of observations for which complete error messages are printed
NOEXPLORER        Do not invoke EXPLORER, which is an alternative to the Display Manager System
FIRSTOBS=1        Number of the first observation of each SAS data set to read
FMTERR            Treat missing format or informat as an error
FMTSEARCH=(WORK LIBRARY)
                  List of catalogs to search for formats and informats
FONTSLOC=C:\Program Files\SAS\SAS 9.1\core\resource
                  Specifies location of SAS font files
FORMCHAR=|----|+|---+=|-/\<>*
                  Default output formatting characters for print device
FORMDLIM=         Character to delimit page breaks in SAS output
FORMS=DEFAULT     Default form used to customize appearance of interactive windowing output
GISMAPS=!sasext0\gismaps
                  Location of SAS/GIS supplied TIGER map library
GWINDOW           Display SAS/GRAPH output in the GRAPH window of Display Manager
HELPENCMD         Use the English index to resolve command line help requests
HELPINDEX=(/help/common.hlp/index.txt /help/common.hlp/keywords.htm common.hhk)
                  Location of help index files
HELPTOC=(/help/helpnav.hlp/config.txt /help/common.hlp/toc.htm common.hhc)
                  Location of the help table of contents files
IBUFSIZE=0        Size of index file buffers
NOIMPLMAC         Do not allow statement-style macro calls
INITCMD=          Initial Display Manager command(s)
INITSTMT=         Initial statements to execute before SYSIN
INVALIDDATA=.     Missing value to assign when invalid numeric data encountered on  input
LABEL             Allow procedures to use labels with variables
LEFTMARGIN=0.000 MM
                  Left margin for printed output
LINESIZE=122      Line size for SAS log and SAS procedure output
LOGPARM=          SAS log file control parameters
MACRO             Allow use of SAS macro facility
MAPS=!sasext0\maps
                  Location of maps
NOMAUTOLOCDISPLAY Do not display the location from which the autocall macro source code is compiled
MAUTOSOURCE       Allow the macro autocall feature
MAXSEGRATIO=75    SPDE pre-evaluation phase time ratio
MCOMPILENOTE=NONE Issue a note to the log when a macro has been successfully compiled
MERGENOBY=NOWARN  Action for DATA step MERGE statement with no associated BY statement
MERROR            Treat apparent undefined macro references as an error
METAAUTORESOURCES=
                  Startup automatic resource identifier
METACONNECT=      Identifies the named connection from the METAPROFILE file to use as the default Open Metadata Server
                  connection.
METAENCRYPTALG=NONE
                  Type of encryption to use when communicating with an Open Metadata Server.
METAENCRYPTLEVEL=EVERYTHING
                  Encryption level to use when communicating with an Open Metadata Server.
METAID=88AF258E-2D03-420C-8E20-3EF084FFA72D
                  Identifies SAS installation to the Metadata Server
METAPASS=         Identifies Metadata Server password
METAPORT=8561     Identifies Metadata Server port
METAPROFILE=      Location of the file containing meta profiles
METAPROTOCOL=BRIDGE
                  Identifies Metadata Server IOM protocol
METAREPOSITORY=Default
                  Identifies the Metadata Server Repository to use for storing SAS configuration information
METASERVER=       Identifies Metadata Server where configuration information is saved and can be queried
METAUSER=         Identifies Metadata Server userid
NOMEXECNOTE       Do not display macro execution information
MEXECSIZE=65536   Maximum size for a macro to execute in memory
NOMFILE           Do not write MPRINT output to an external physical file
MINDELIMITER=     Identifies the character to use as the delimiter of the macro IN operator
MINPARTSIZE=16777216
                  Minimum partition size when creating SPDE files
MISSING=.         Character to represent missing numeric value
NOMLOGIC          Do not trace macro execution
NOMLOGICNEST      Do not display macro nesting information in MLOGIC output
NOMPRINT          Do not display SAS statements generated by macro execution
NOMPRINTNEST      Do not display macro nesting information in MPRINT output
NOMRECALL         Do not search autocall libraries for an undefined macro name each time the macro is invoked
MSGLEVEL=N        Level of messages displayed
NOMSTORED         Do not use stored compiled macros
MSYMTABMAX=4194304
                  Maximum amount of memory allocated for the macro table
NOMULTENVAPPL     Do not support multiple environment SAS applications
MVARSIZE=4096     Maximum length of value of macro variable
NONETENCRYPT      Do not encrypt all network communications.
NETENCRYPTALGORITHM=
                  List of encryption algorithms for use
NETENCRYPTKEYLEN=0
                  Key size for network data encryption
NETMAC            Use Message Authentication Codes (MACs) on network communications
NEWS=             Location of NEWS file that contains messages to be written to the SAS log
NOTES             Write notes to the SAS log
NUMBER            Print page number on each page of SAS output
NOOBJECTSERVER    Do not invoke OBJECTSERVER SAS process.
OBS=9223372036854775807
                  Number of the last observation to process
ORIENTATION=PORTRAIT
                  Orientation to use when printing
NOOVP             Do not allow output lines to be overprinted
NOPAGEBREAKINITIAL
                  Do not begin SAS log and listing files on a new page.
PAGENO=1          Beginning page number for the next page of output produced by the SAS System
PAGESIZE=51       Number of lines printed per page of output
PAPERDEST=        Bin to receive printed output
PAPERSIZE=A4      Size of paper to print on
PAPERSOURCE=      Bin to pull paper from when printing
PAPERTYPE=PLAIN   Type of paper printer is using
PARM=             Parameter string to pass to external program
PARMCARDS=FT15F001
                  Fileref for the PARMCARDS file
PRINTERPATH=      Printer path
NOPRINTINIT       Do not initialize SAS print file
PRINTMSGLIST      Print extended lists of messages
QUOTELENMAX       Enable warning for quoted string length max
REPLACE           Allow replacement of permanent SAS data sets
REUSE=NO          Reuse space when observations are added to a compressed SAS data set
RIGHTMARGIN=0.000 MM
                  Right margin for printed output
NORSASUSER        Do not open SASUSER library as READONLY
S=0               Length of source statements and data lines
S2=0              Length of secondary source statements, such as input from a %INCLUDE statement, an AUTOEXEC file, or
                  an autocall macro file
SASAUTOS=SASAUTOS Search list for autocall macros
SASCMD=           SAS command to be used by SAS/CONNECT to start another SAS session
SASFRSCR=#LN00003 Fileref for SAS/CONNECT script files
SASHELP=(                  "!SASCFG\SASCFG"                  "!sasext1\ko\sashelp"
"!sasroot\core\sashelp"                  "!sasext0\dmine\sashelp"                  "!sasext0\reporter\sashelp"
     "!sasext0\risk\sashelp"                  "!sasext0\webdatasrv\sashelp"                  "!sasext0\finance\sashelp"
               "!sasext0\hpf\sashelp"                  "!sasext0\inttech\sashelp"
"!sasext0\irp\sashelp"                  "!sasext0\cpe\sashelp"                  "!sasext0\mktopt\sashelp"
"!sasext0\mddbserv\sashelp"                  "!sasext0\soltnsdata\sashelp"                  "!sasext0\weba\sashelp"
           "!sasext0\access\sashelp"                  "!sasext0\af\sashelp"                  "!sasext0\assist\sashelp"
              "!sasext0\connect\sashelp"                  "!sasext0\eis\sashelp"                  "!sasext0\ets\sashelp"
                "!sasext0\genetics\sashelp"                  "!sasext0\gis\sashelp"
"!sasext0\graph\sashelp"                  "!sasext0\iml\sashelp"                  "!sasext0\insight\sashelp"
  "!sasext0\intrnet\sashelp"                  "!sasext0\lab\sashelp"                  "!sasext0\or\sashelp"
    "!sasext0\qc\sashelp"                  "!sasext0\sview\sashelp"                  "!sasext0\stat\sashelp"
    "!sasext0\whouse\sashelp"                  "!sasext0\tmine\sashelp"                 )
                  Location of the SASHELP library
SASMSTORE=        Libref associated with SAS data library containing catalog of compiled stored macros
SASSCRIPT=(!sasext0\connect\saslink)
                  Location of SAS/CONNECT script files
SASUSER=C:\Documents and Settings\Administrator\My Documents\My SAS Files\9.1
                  Location of SAS data library containing user profile catalog
SEQ=8             Number of digits in numeric portion of the sequence field
SERROR            Treat references to undefined macro variables as an error
NOSETINIT         Do not update site validation data with PROC SETINIT
SIGNONWAIT        Wait for a SAS/CONNECT signon to finish before allowing further processing to occur
SKIP=0            Number of lines to skip before title
SOLUTIONS         Display "Solutions" pulldown
SORTDUP=PHYSICAL  SORT applies NODUP option to physical or logical records?
SORTEQUALS        Maintain order for the input data set in the output data set, when processing identical BY-variable
                  values with Proc Sort
SORTSEQ=          Collating sequence for sorting
SORTSIZE=67108864 Size parameter for sort
SOURCE            Write SAS source statements to the SAS log
NOSOURCE2         Do not write secondary source statements from included files to the SAS log
SPDEINDEXSORTSIZE=33554432
                  Identifies memory to be used for SPDE asynchronous index create or append
SPDEMAXTHREADS=0  Maximum number of threads for SPDE processing
SPDESORTSIZE=33554432
                  Memory for SPDE sort operations
SPDEUTILLOC=      Location where SPDE temporary utility files are created
SPDEWHEVAL=COST   Specifies SPDE WHERE statement evaluation strategy
NOSPOOL           Do not write SAS statements to a utility data set in the WORK data library
NOSSLCLIENTAUTH   Do not require client authentication when a connection is established.
NOSSLCRLCHECK     Do not check certificate revocation list when validating digital certificates
STARTLIB          Autoassign libraries at startup
SUMSIZE=0         Upper limit for data-dependent memory usage during summarization
NOSYMBOLGEN       Do not write results of resolving macro variable references to SAS log
SYNCHIO           Require synchronous input/output
SYNTAXCHECK       Put SAS into syntaxcheck mode
SYSPARM=          Character string that can be passed to SAS programs
SYSPRINTFONT=     Set the default font for printing
NOSYSRPUTSYNC     Macro variables are set when a synchronization point is encountered
TBUFSIZE=0        Message transmission size for SAS/Connect and SAS/SHARE
TCPPORTFIRST=0    First TCP/IP port available for SAS/Connect use
TCPPORTLAST=0     Last TCP/IP port available for SAS/Connect use
TERMINAL          Specify that a terminal is attached at SAS invocation
TERMSTMT=         SAS statements to execute at SAS termination
TEXTURELOC=!sasroot\common\textures
                  Location of textures and images used by ODS styles.
THREADS           Threads are available for use with features of the SAS System that support threading
TOOLSMENU         Allow the Tools pull-down to be displayed in the SAS menu
TOPMARGIN=0.000 MM
                  Top margin for printed output
TRAINLOC=         Location of SAS online training courses
TRANTAB=          Names of translate tables
NOUNIVERSALPRINT  Do not use Universal Printing Model
USER=             Default location for all one-level SAS data set names
UTILLOC=WORK      Temporary utility file locations where procedures can create utility files
UUIDCOUNT=100     UUID Generator Server Cache
UUIDGENDHOST=     UUID Generator Server
V6CREATEUPDATE=NOTE
                  Access to create and update V6 SAS files
VALIDFMTNAME=LONG Controls the name length of informats and formats created and processed during a SAS Session
VALIDVARNAME=V7   Control the type of SAS variable names that can be created during a SAS session
VIEWMENU          Allow the View pull-down to be displayed in the SAS menu
VNFERR            Treat variable not found on _NULL_ SAS data set as an error
WORK=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SAS Temporary Files\_TD596
                  Location for WORK SAS data library
WORKINIT          Erase all files from WORK library at SAS invocation
WORKTERM          Erase all files from WORK library at SAS termination
YEARCUTOFF=1920   Cutoff year for DATE and DATETIME informats and functions
_LAST_=_NULL_     Last SAS data set created

호스트 옵션:

ACCESSIBILITY=STANDARD
                  Enable Extended Accessibility
ALTLOG=           Specifies the destination for a copy of the SAS log
ALTPRINT=         Specifies the destination for a copy of the SAS procedure output file
AUTHPROVIDERDOMAIN=
                  Authentication providers associated with domain suffixes
AUTHSERVER=       Specify the authentication server or domain.
AUTOEXEC=         Specifies the autoexec file to be used
AWSCONTROL=(SYSTEMMENU MINMAX TITLE)
                  Used to customize the appearance for the SAS AWS. Valid parameters are: TITLE/ NOTITLE
                  SYSTEMMENU/NOSYSTEMMENU MINMAX/NOMINMAX
AWSDEF=(0 0 79 80)
                  Specify the initial size and position of the SAS AWS. This should be specified as follows: 0 0 100 100
AWSMENU           Show the main window's (AWS) menu.
AWSMENUMERGE      Add host specific menu items to the main window's (AWS) menu.
AWSTITLE=         Specify the text for the SAS AWS title bar.
COMAUX1=          Specify auxiliary 1 communication access method id.
COMAUX2=          Specify auxiliary 2 communication access method id.
COMDEF=(BOTTOM CENTER)
                  Specify command dialog default display location.
CONFIG=C:\Program Files\SAS\SAS 9.1\nls\ko\SASV9.CFG
                  Specifies a SAS configuration file.
DBCS              Process double byte character sets
DBCSLANG=KOREAN   Specifies the double-byte character set (DBCS) language to use
DBCSTYPE=PCMS     Specifies a double-byte character set (DBCS) encoding method
DOCLOC=           Base Location of SAS Online Documentation
ECHO=             Prints string to the log during startup.
EMAILDLG=NATIVE   Used by Send menu item to set the email dialog interface.
EMAILSYS=MAPI     Used by E-mail Access Method and Send menu item to set the interface type with underlying e-mail
                  system.
ENCODING=EUC-KR   Specifies default encoding for processing external data.
ENHANCEDEDITOR    Invoke the enhanced editor at SAS startup.
FILTERLIST=       Used to customize the list of filters used in the open/save dialogs. Filters should be specified as
                  follows: "*.xxx|*.my files"
FONT=(바탕체 9)   Sets the display manager font. The first parameter is the facename of the font and the second optional
                  parameter is the point size of the font.
FONTALIAS=        Assigns a new host font facename to a portable SAS font family. The first parameter is the SAS font
                  family and the second is the host-specific font facename.
NOFULLSTIMER      Do not write system performance statistics to the SAS log
HELPLOC=("!MYSASFILES\classdoc" "!sasroot\nls\ko\help" "!sasroot\core\help")
                  Location of help environment text and index files
HELPREGISTER=     Specifies the help file launched from SAS AWS->HELP menu.
HOSTPRINT         Print using the host Print Manager. To use Universal Printing or FORMS, this option must be turned off.
NOICON            Force SAS AWS to be restored.
JREOPTIONS=( -Dsas.jre.home=C:\PROGRA~1\SASINS~1\SHARED~1\JRE\14267D~1.1 -Djava.security.policy=C:\Program Files\SAS\SAS
9.1\core\sasmisc\sas.policy -Dsas.app.class.dirs=C:\Program Files\SAS\SAS
9.1\core\sasmisc;C:\PROGRA~1\SASINS~1\SHARED~1\applets\9.1 -Dsas.jre=private -Dsas.ext.config=C:\Program Files\SAS\SAS
9.1\core\sasmisc\sas.java.ext.config -DPFS_TEMPLATE=C:\Program Files\SAS\SAS 9.1\core\sasmisc\qrpfstpt.xml
-Djava.class.path=C:\Program Files\SAS\SAS 9.1\core\sasmisc\sas.launcher.jar
-Djava.system.class.loader=com.sas.app.AppClassLoader -Djava.ext.dirs=C:\Program Files\SAS\SAS
9.1\core\sasmisc;C:\Program Files\SAS Institute\Shared Files\applets\9.1;C:\Program Files\SAS\SAS
9.1\soltnsdata\sasmisc;C:\Program Files\SAS\SAS 9.1\finance\sasmisc )
                  Java Runtime Environment options
LOADMEMSIZE=0     Suggested memory limit for loaded SAS executables
LOCALE=KOREAN_KOREA
                  Specifies the current locale for the SAS session.
LOG=              Specifies a destination to which the SAS log is written in batch or noninteractive mode
MAXMEMQUERY=0     Maximum amount of memory returned when inquiring as to available space
MEMBLKSZ=16777216 Size of memory blocks allocated to support MEMLIB and MEMCACHE options.
MEMCACHE=0        Activates use of Intel Extended Server Memory Architecture memory for file caching.
NOMEMLIB          Disable use of Intel Extended Memory Server Architecture memory for memory based librefs. When used on
                  startup, applies to the WORK library.
MEMMAXSZ=2147483648
                  Maximum amount of memory allocated to support MEMLIB and MEMCACHE options.
MEMSIZE=0         Specifies the limit on the total amount of memory to be used by the SAS System
MSG=(                  "!sasext1\ko\sasmsg"                  "!sasroot\core\sasmsg"
"!sasext0\dmine\sasmsg"                  "!sasext0\risk\sasmsg"                  "!sasext0\dquality\sasmsg"
  "!sasext0\hpf\sasmsg"                  "!sasext0\inttech\sasmsg"                  "!sasext0\irp\sasmsg"
  "!sasext0\mddbserv\sasmsg"                  "!sasext0\access\sasmsg"                  "!sasext0\af\sasmsg"
  "!sasext0\ets\sasmsg"                  "!sasext0\genetics\sasmsg"                  "!sasext0\gis\sasmsg"
  "!sasext0\graph\sasmsg"                  "!sasext0\iml\sasmsg"                  "!sasext0\insight\sasmsg"
    "!sasext0\intrnet\sasmsg"                  "!sasext0\lab\sasmsg"                  "!sasext0\or\sasmsg"
  "!sasext0\qc\sasmsg"                  "!sasext0\sview\sasmsg"                  "!sasext0\stat\sasmsg"
"!sasext0\tmine\sasmsg"                 )
                  The path to the sasmsg directory
NOMSGCASE         Do not uppercase messages before returning
NONLSCOMPATMODE   Uses the user specified encoding to process character data
NUMKEYS=12        Number of function keys. (default on machine keyboard)
NUMMOUSEKEYS=3    Number of keys (buttons) on mouse
NOOPLIST          Do not write the settings of the SAS system options to the SAS log
PATH=(                   "!sasext0\dbcs\sasexe"                  "!sasroot\core\sasexe"
"!sasext0\dmine\sasexe"                  "!sasext0\reporter\sasexe"                  "!sasext0\procurement\sasexe"
         "!sasext0\risk\sasexe"                  "!sasext0\dquality\sasexe"                  "!sasext0\hpf\sasexe"
          "!sasext0\inttech\sasexe"                  "!sasext0\irp\sasexe"                  "!sasext0\cpe\sasexe"
         "!sasext0\itslm\sasexe"                  "!sasext0\ma\sasexe"                  "!sasext0\mktopt\sasexe"
        "!sasext0\mddbserv\sasexe"                  "!sasext0\weba\sasexe"                  "!sasext0\access\sasexe"
            "!sasext0\af\sasexe"                  "!sasext0\connect\sasexe"                  "!sasext0\eis\sasexe"
          "!sasext0\ets\sasexe"                  "!sasext0\fsp\sasexe"                  "!sasext0\genetics\sasexe"
          "!sasext0\gis\sasexe"                  "!sasext0\graph\sasexe"                  "!sasext0\iml\sasexe"
       "!sasext0\insight\sasexe"                  "!sasext0\intrnet\sasexe"                  "!sasext0\lab\sasexe"
          "!sasext0\or\sasexe"                  "!sasext0\qc\sasexe"                  "!sasext0\securwin\sasexe"
        "!sasext0\share\sasexe"                  "!sasext0\sview\sasexe"                  "!sasext0\stat\sasexe"
        "!sasext0\toolkt\sasexe"                  "!sasext0\tmine\sasexe"                  )
                  Specifies location of the SAS System load image search path.
PFKEY=(WIN)       Key definitions to map
PRINT=            Specifies the destination for SAS output in batch or noninteractive mode
PRTABORTDLGS=BOTH User can select when to display the print abort dialog. Valid arguments are both, neither, file, and
                  printer.
NOPRTPERSISTDEFAULT
                  Disable persist of the printer selected in Print Setup between SAS sessions.
PRTSETFORMS       Display the 'use forms' checkbox on the print setup dialog box.
REALMEMSIZE=0     Limit on the total amount of real memory to be used by the SAS System
REGISTER=         Registers external applications for use with SAS by adding them to menus.
RESOURCESLOC=( "C:\Program Files\SAS\SAS 9.1\nls\ko\resource" "C:\Program Files\SAS\SAS 9.1\core\resource" )
                  Specifies location of resources files used by SAS.
RTRACE=NONE       A method for observing which files are used by the SAS System
RTRACELOC=        Specifies the pathname of the file to which RTRACE information is written
SASCONTROL=(SYSTEMMENU MINMAX)
                  Used to customize the appearance of the SAS windows. Valid parameters are SYSTEMMENU/NOSYSTEMMENU, and
                  MINMAX/NOMINMAX.
SASINITIALFOLDER= Sets SAS's initial working folder. Also changes initial folder of Open and Save As dialog to be
                  current working folder.
NOSCROLLBARFLASH  Prevent the scroll bar from flashing by not allowing the scroll bar to receive keyboard or window
                  focus events.
SET=[FT15F001 = 'FT15F001.DAT'] [sasext0 = "C:\Program Files\SAS\SAS 9.1"] [sasroot = "C:\Program Files\SAS\SAS 9.1"]
[sasext1 = "C:\Program Files\SAS\SAS 9.1\nls"] [MYSASFILES = "?CSIDL_PERSONAL\My SAS Files\9.1"] [SASCFG = "C:\Program
Files\SAS\SAS 9.1\nls\ko"] [EISIMAGE = !sasext0\eis\sample] [SASSAML = !sasext0\share\sasmacro\] [busroot =
"!sasroot\reporter"] [SASAUTOS = (                  "!sasroot\core\sasmacro"                  "!sasext0\dmine\sasmacro"
              "!sasext0\risk\sasmacro"                  "!sasext0\dquality\sasmacro"
"!sasext0\webdatasrv\sasmacro"                  "!sasext0\finance\sasmacro"                  "!sasext0\hpf\sasmacro"
           "!sasext0\inttech\sasmacro"                  "!sasext0\cpe\sasmacro"
"!sasext0\itslm\sasmacro"                  "!sasext0\ma\sasmacro"                  "!sasext0\soltnsdata\sasmacro"
        "!sasext0\weba\sasmacro"                  "!sasext0\access\sasmacro"                  "!sasext0\assist\sasmacro"
                "!sasext0\eis\sasmacro"                  "!sasext0\ets\sasmacro"
"!sasext0\genetics\sasmacro"                  "!sasext0\gis\sasmacro"                  "!sasext0\graph\sasmacro"
       "!sasext0\iml\sasmacro"                  "!sasext0\or\sasmacro"                  "!sasext0\qc\sasmacro"
      "!sasext0\share\sasmacro"                  "!sasext0\stat\sasmacro"                  "!sasext0\scorecard\sasmacro"
               )] [SAMPSIO = (                  "!sasroot\core\sample"                  "!sasext0\dmine\sample"
       "!sasext0\risk\sample"                  "!sasext0\dquality\sample"                  "!sasext0\hpf\sample"
        "!sasext0\inttech\sample"                  "!sasext0\irp\sample"                  "!sasext0\access\sample"
          "!sasext0\connect\sample"                  "!sasext0\eis\sample"                  "!sasext0\ets\sample"
         "!sasext0\genetics\sample"                  "!sasext0\gis\sample"                  "!sasext0\graph\sample"
           "!sasext0\iml\sample"                  "!sasext0\insight\sample"                  "!sasext0\intrnet\sample"
              "!sasext0\or\sample"                  "!sasext0\qc\sample"                  "!sasext0\share\sample"
         "!sasext0\sview\sample"                  "!sasext0\stat\sample"                  "!sasext0\tmine\sample"
        )] [SAMPSRC = (                  "!sasroot\core\sample"                  "!sasext0\dmine\sample"
"!sasext0\risk\sample"                  "!sasext0\dquality\sample"                  "!sasext0\hpf\sample"
  "!sasext0\inttech\sample"                  "!sasext0\irp\sample"                  "!sasext0\access\sample"
  "!sasext0\connect\sample"                  "!sasext0\eis\sample"                  "!sasext0\ets\sample"
  "!sasext0\genetics\sample"                  "!sasext0\gis\sample"                  "!sasext0\graph\sample"
    "!sasext0\iml\sample"                  "!sasext0\insight\sample"                  "!sasext0\intrnet\sample"
       "!sasext0\or\sample"                  "!sasext0\qc\sample"                  "!sasext0\share\sample"
  "!sasext0\sview\sample"                  "!sasext0\stat\sample"                  "!sasext0\tmine\sample"
  )] [INSTALL = (                 )]
                  Defines an environment variable
NOSGIO            Disable Windows NT scatter read/gather write I/O file access.
SLEEPWINDOW       Disable idle window when SAS is waiting for the wakeup or sleep function to complete.
SORTANOM=         Host sort option
SORTCUT=0         Specifies the number of observations above which the host sort program is used instead of the SAS sort
                  program
SORTCUTP=0        Specifies the number of bytes above which the host sort program should be used instead of the SAS sort
                  program
SORTDEV=          Specifies the pathname used for temporary host sort files
SORTPARM=         Specifies the host sort parameters
SORTPGM=BEST      Specifies the name of the sort utility
SPLASH            Display the system startup screen.
SPLASHLOC=        Specifies the location of the splash screen bitmap.
SSLCERTISS=       Name of the certificate authority issuing digital certificate
SSLCERTSERIAL=    Serial number of the digital certificate
SSLCERTSUBJ=      Subject of the digital certificate
STIMEFMT=M        Specifies the format to use for displaying the time on STIMER output as either seconds,
                  minutes:seconds or hours:minutes:seconds.
STIMER            Writes a subset of system performance statistics to the SAS log
SYSGUIFONT=       Sets the default GUI font
SYSIN=            Specifies the default location of SAS source code when running in batch or noninteractive mode
SYSPRINT=         Set the default printer and, optionally, an alternate destination (file) for output
TOOLDEF=(TOP RIGHT)
                  Specify toolbox default display location.
NOUPRINTMENUSWITCH
                  Disable universal print menus when UNIVERSALPRINT is on.
USERICON=         Specify location of user-defined icon DLL.
NOVERBOSE         Do not print configuration options to the screen
NOWEBUI           Disable web user interface enhancements for supporting hover mode and single-click expand/activation.
NOWINDOWSMENU     Disable Windows menu if NOAWSMENUMERGE is set.
XCMD              The X Command is valid in this SAS session
NOXMIN            X-commands launch in default active state.
XSYNC             X-commands execute synchronously.
XWAIT             X-commands wait for 'exit' before returning to SAS.
NOTE: 프로시저 OPTIONS 실행:
     실행 시간           0.13 초
     cpu 시간            0.12 초
*/

options LS=132 PS=60;
/* 가로 132, 세로 60 */
/* LINESIZE, PAGESIZE가 바뀌어 있음을 알 수 있다*/
===================================
데이터 핸들링
===================================
data work.test;
set sashelp.class;
/* if sex='M' then output;*/
run;
proc print data=work.test;
run;
/* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
----------------------------------
7    data work.test;
8        set sashelp.class;
9    /*  if sex='M' then output;*/
10   run;

NOTE: 19개의 관측치를 데이터셋 SASHELP.CLASS. (으)로부터  읽었습니다.
NOTE: 데이터셋 'WORK.TEST'은(는) 19개 관측치, 5개 변수를 가지고 있습니다.
NOTE: DATA 문장 실행:
     실행 시간           0.15 초
     cpu 시간            0.00 초


11   proc print data=work.test;
NOTE: HTML Body 파일 기록 중: sashtml.htm
12   run;

NOTE: 19개의 관측치를 데이터셋 WORK.TEST. (으)로부터  읽었습니다.
NOTE: 프로시저 PRINT 실행:
     실행 시간           0.68 초
     cpu 시간            0.09 초


13   /* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
------------------------------------
              SAS 시스템                2006년 07월 07일 금요일 오후 02시55분49초   1

                                         OBS    Name       Sex    Age    Height    Weight

                                           1    Alfred      M      14     69.0      112.5
                                           2    Alice       F      13     56.5       84.0
                                           3    Barbara     F      13     65.3       98.0
                                           4    Carol       F      14     62.8      102.5
                                           5    Henry       M      14     63.5      102.5
                                           6    James       M      12     57.3       83.0
                                           7    Jane        F      12     59.8       84.5
                                           8    Janet       F      15     62.5      112.5
                                           9    Jeffrey     M      13     62.5       84.0
                                          10    John        M      12     59.0       99.5
                                          11    Joyce       F      11     51.3       50.5
                                          12    Judy        F      14     64.3       90.0
                                          13    Louise      F      12     56.3       77.0
                                          14    Mary        F      15     66.5      112.0
                                          15    Philip      M      16     72.0      150.0
                                          16    Robert      M      12     64.8      128.0
                                          17    Ronald      M      15     67.0      133.0
                                          18    Thomas      M      11     57.5       85.0
                                          19    William     M      15     66.5      112.0
=====================================
data work.test;
set sashelp.class;
if sex='M' then output;
run;
proc print data=work.test;
run;
/* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
------------------------------------
14   data work.test;
15       set sashelp.class;
16       if sex='M' then output;
17   run;

NOTE: 19개의 관측치를 데이터셋 SASHELP.CLASS. (으)로부터  읽었습니다.
NOTE: 데이터셋 'WORK.TEST'은(는) 10개 관측치, 5개 변수를 가지고 있습니다.
NOTE: DATA 문장 실행:
     실행 시간           0.00 초
     cpu 시간            0.00 초


18   proc print data=work.test;
19   run;

NOTE: HTML Body 파일 기록 중: sashtml1.htm
NOTE: 10개의 관측치를 데이터셋 WORK.TEST. (으)로부터  읽었습니다.
NOTE: 프로시저 PRINT 실행:
     실행 시간           0.07 초
     cpu 시간            0.03 초


20   /* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
---------------------------------
                                    SAS 시스템                2006년 07월 07일 금요일 오후 02시55분49초   2

                                         OBS    Name       Sex    Age    Height    Weight

                                           1    Alfred      M      14     69.0      112.5
                                           2    Henry       M      14     63.5      102.5
                                           3    James       M      12     57.3       83.0
                                           4    Jeffrey     M      13     62.5       84.0
                                           5    John        M      12     59.0       99.5
                                           6    Philip      M      16     72.0      150.0
                                           7    Robert      M      12     64.8      128.0
                                           8    Ronald      M      15     67.0      133.0
                                           9    Thomas      M      11     57.5       85.0
                                          10    William     M      15     66.5      112.0
==================================
data work.test;
set sashelp.class;
if sex='M' and age>14 then output;
run;
proc print data=work.test;
run;
/* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
----------------------------------
21   data work.test;
22       set sashelp.class;
23       if sex='M' and age>14 then output;
24   run;

NOTE: 19개의 관측치를 데이터셋 SASHELP.CLASS. (으)로부터  읽었습니다.
NOTE: 데이터셋 'WORK.TEST'은(는) 3개 관측치, 5개 변수를 가지고 있습니다.
NOTE: DATA 문장 실행:
     실행 시간           0.01 초
     cpu 시간            0.01 초


25   proc print data=work.test;
26   run;

NOTE: HTML Body 파일 기록 중: sashtml2.htm
NOTE: 3개의 관측치를 데이터셋 WORK.TEST. (으)로부터  읽었습니다.
NOTE: 프로시저 PRINT 실행:
     실행 시간           0.09 초
     cpu 시간            0.01 초


27   /* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
--------------------------------
                                                            SAS 시스템                2006년 07월 07일 금요일 오후 02시55분49초   3

                                         OBS     Name      Sex    Age    Height    Weight

                                          1     Philip      M      16     72.0       150
                                          2     Ronald      M      15     67.0       133
                                          3     William     M      15     66.5       112

================================
data work.test;
set sashelp.class;
if sex='M' and age>14 then output;
run;
title "14세 이상인 남자의 데이터";
/*title 주기*/
options nodate;
/* 날짜 주기 싫다*/
proc print data=work.test;
run;
/* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
-------------------------------
67   data work.test;
68       set sashelp.class;
69       if sex='M' and age>14 then output;
70   run;

NOTE: 19개의 관측치를 데이터셋 SASHELP.CLASS. (으)로부터  읽었습니다.
NOTE: 데이터셋 'WORK.TEST'은(는) 3개 관측치, 5개 변수를 가지고 있습니다.
NOTE: DATA 문장 실행:
     실행 시간           0.00 초
     cpu 시간            0.00 초


71   title "14세 이상인 남자의 데이터";
72   /*title 주기*/
73   options nodate;
74   /* 날짜 주기 싫다*/
75   proc print data=work.test;
76   run;

NOTE: HTML Body 파일 기록 중: sashtml6.htm
NOTE: 3개의 관측치를 데이터셋 WORK.TEST. (으)로부터  읽었습니다.
NOTE: 프로시저 PRINT 실행:
     실행 시간           0.09 초
     cpu 시간            0.01 초


77   /* 2개의 스텝이 있다(data 스텝과 proc 스텝) run 사이에 쓰는 문장을 통해 핸들링을 한다.*/
------------------------------

excel data load
==============
file>데이터 가져오기
Membername 32 char. max
---------- log ------------
NOTE: INIT.MUSIC_ME 이(가) 성공적으로 생성되었습니다.
--------------------------


========================
fsview run
------------------------
proc fsview data=init.music_me;
run;
========================
=================================
SAS 9.3 ver > BI, EBI Architecture show.


SAS EG



신기하긴하다.
Program I&II, III(Advance)
SQL (ex. Connect to ORACLE 명령어를 쓰면 ORACLE를 전부 쓸 수 있다.
MACRO Language - 프로그램을 함축시켜 실행 가능 ex) %Let ds = Mktdata.MAST ;
                                                                             %MACR Sexpgm(Gender);
                                                                              data work.set;
                                                                              Set &ds;
                                                                              if Sex = &Gender then output
                                                                             Run;
                                                                             Proc print date = work.test;
                                                                             Run;
                                                                             .... 쓰다보니 모르겠다.
EG I(데이타 쿼리, 레포팅), II(분석)
기초통계
회기분석
.
.

+ plus (professional skills)
BI
ETL
by Joe & Soohy 2006. 7. 7. 10:57