엑셀과 SAS 함수

기본적으로 과거 SAS 시험판으로 개발된 SYLK 프로시져 도움말을 참고하였으며, SAS 기본 함수, SAS FCMP 사용자 정의 함수, SAS 프로그래밍 등을 사용하여서 작성하였다.

다음은 이 장을 구현하기 위하여 참고한 문서를 정리하였는데, 좀 더 효율적인 방법이 존재하는 경우에는 SAS 사용자 함수를 작성하여서 대체 사용하시기를 바란다.

 

 

o SAS Fcmp 함수 편집기

 

: SAS -> 솔루션 -> 분석 -> Fcmp 함수 편집기

SASHELP 하단에 엑셀을 SAS로 구현한 3 종류의 함수 목록을 확인 할 수 있다. 함수를 선택하여서 개별 함수의 세부 구현식을 확인을 할 수 있다.

 

1)   SLKWXL.finance (재문함수)

FCMP 사용자 함수	엑셀 함수
ACCRINT_slk	ACCRINT
ACCRINTM_slk	ACCRINTM
AMORDEGRC_slk	AMORDEGRC
AMORLINC_slk	AMORLINC
COUPDAYBS_slk	COUPDAYBS
COUPDAYS_slk	COUPDAYS
COUPDAYSNC_slk	COUPDAYSNC
COUPNCD_slk	COUPNCD
COUPNUM_slk	COUPNUM
COUPPCD_slk	COUPPCD
DATDIF4_slk	DATDIF
DB_slk	DB
DISC_slk	DISC
DOLLARDE_slk	DOLLARDE
DOLLARFR_slk	DOLLARFR
DURATION_slk	DURATION
EFFECT_slk	EFFECT
MDURATION_slk	MDURATION
ODDFPRICE_slk	ODDFPRICE
ODDFYIELD_slk	ODDFYIELD
ODDLPRICE_slk	ODDLPRICE
ODDLYIELD_slk	ODDLYIELD
PRICE_slk	PRICE
PRICEDISC_slk	PRICEDISC
PRICEMAT_slk	PRICEMAT
RECEIVED_slk	RECEIVED
TBILLEQ_slk	TBILLEQ
TBILLPRICE_slk	TBILLPRICE
TBILLYIELD_slk	TBILLYIELD
YIELD_slk	YIELD
YIELDDISC_slk	YIELDDISC
YIELDMAT_slk	YIELDMAT

 

2)   SLKWXL.math (수학함수)

FCMP 사용자 함수	엑셀 함수
Even_slk	EVEN
Factdouble_slk	FACTDOUBLE
Floor_slk	FLOOR
Multinomial_slk	MULTINOMIAL
Odd_slk	ODD
Product_slk	PRODUCT

 

3)   SLKWXL.stat (통계함수)

FCMP 사용자 함수	엑셀 함수
Avedev_slk	AVEDEV
Devsq_slk	DEVSQ
Varp_slk	VARP

 

 

o 파생된 수학 함수(Visual Basic)

: https://msdn.microsoft.com/ko-kr/library/w3t84e33.aspx

: http://nicklib.com/library/VBSdocs/ko_226.htm

 

 

o SYLK 프로시져 (Experimental) 

: Microsoft Excel Formula and Format Translation

: http://support.sas.com/documentation/onlinedoc/base/procsylk.pdf

 

 

o INPO Statistics Workshop: Notes and Exercises  using EXCEL and SAS 

(Developed by Jennifer Lewis Priestley, Ph.D. Kennesaw State University)

 

 

o 권세혁 교수 : 함수

: http://wolfpack.hnu.ac.kr/Book/SAS/function_sas_wolfpack.pdf