Ʈ  |  Contact Us
 
Ȩ > SAS Tech & Tip > SAS Programming
[SAS α׷] SAS Լ (6) 2017.08.20
MYSAS ü 5660 0
http://www.mysas.co.kr/SAS_tiptech/a_question.asp?b_no=7411&gotopage=9&con=subject&keyword=&cmd=content&bd_no=05&gubun=

[SAS α׷] SAS Լ (6)

 

ȳϼ^^

ð ̾, ¥ õ SAS Լ ˾ƺ ϰڽϴ.

 

1. ¥ Էϴ Լ

2. SAS date Ȥ ¥ κ ϴ ¥ ϴ Լ

3. ¥ õ Լ

 

̹ ð ° ð ¥ õ Լ ؼ ˾ƺ ϰڽϴ.

 

INTCK(interval<.shift>, start-value, end-value)

INTCK Լ ¥, Ȥ ð ̸ ݴϴ. Multiple ɼ ¥ ְ, .shift ɼ starting point ֽϴ.

 

Intervals date units Ʒ ϴ.

Interval

Description

DAY

Day

WEEK

Week

WEEKDAY

Each weekday (Monday to Friday, or any set of days you choose)

TENDAY

Ten-day period

SEMIMONTH

Two-week period

MONTH

Month

QTR

Quarter (Jan-Mar = 1, Apr-Jun = 2 etc.)

SEMIYEAR

Half year

YEAR

Year

 

 

Intervals time units Ʒ ϴ.

Interval

Description

SECOND

Seconds

MINUTE

Minutes

HOUR

Hours

 

 

Intervals datetime units Ʒ ϴ.

Interval

Description

DTDAY

Day

DTWEEK

Week

DTWEEKDAY

Each weekday (Monday to Friday)

DTTENDAY

Ten-day period

DTSEMIMONTH

Two-week period

DTMONTH

Month

DTQTR

Quarter (Jan-Mar=1, Apr-Jun=2, etc.)

DTSEMIYEAR

Half year

DTYEAR

Year

 

 

 

 

 

 

(YEAR) , startind date 2002 1 1̰ ending date 2002 12 31 Լ 0 Ÿϴ.

startind date 2002 12 31̰ ending date 2003 1 1 Լ 1 Ÿϴ.

INTCK5 YEAR2 ǥ interval 2 2002 1 1Ϻ 2012 12 31 ¥ Լ 5Դϴ.

INTCK6 MONTH6.3 ǥ interval 6̰ shift value 3, ų 3 9 6 ¥ ̸ Ѵ. INTCK6.3 Լ 2002 1 1Ϻ 2002 5 31 ̰̹Ƿ 1 Ÿϴ.

INTCK7 WEEK.4 starting point Ϸ Ͽ մϴ.

INTCK8 HOUR4 4ð ð ̸ մϴ.

 

 


INTNX(interval, start-date, increment <, alignment>)

INTNX Լ ¥κ Ư Ⱓ ¥ Ͽ Ÿִ ԼԴϴ.

Alignment ɼ BEGINNING(B), MIDDLE (M), END(E), or SAMEDAY(S) , default BEGINNIG Դϴ.

 

 

 

 

Interval week̰ start-date 1960 1 1̰ increment 1 , 1960 1 3( ۵Ǵ Ͽ) Ÿ ݴϴ. ׷ ¥ Ⱓ Է alignment MIDDLE ָ 1960 1 6() µǰ ˴ϴ.

 


YRDIF(start-date, end-date, basis)

YRDIF Լ ¥ ⵵(year)̸ Ͽ Ÿ ݴϴ.

Basis SAS ϴ մϴ. first value/second value ǥϰ Ǵµ, first value (the number of days in a month) ϴ κ̰ second value(the number of days in a year)

 

30/360 Uses 30-day months and 360-day years in the calculation.

ACT/365 Uses the actual number of days between the two dates, but uses 365-day years, even if a leap year is in the interval.

ACT/360 Uses the actual number of days between the two dates, but uses 360-day years.

 

 

 


HOLIDAY (holiday, year)

HOLIDAY Լ holiday ̸ ⵵ Էϸ SAS date Ÿִ ԼԴϴ.

 

    

 


DATEJUL (jul-date)

DATEJUL Լ Julian date SAS date ȯִ ԼԴϴ.

    

 

 


JULDATE (date)

JULDATE Լ SAS date Julian date ȯִ ԼԴϴ.

 

 

 


JULDATE7 (date)

JULDATE7 Լ SAS date 7ڸ Julian date ȯִ ԼԴϴ.

 

   

 

 

̻ ¥ õ Լ ˾ƺҽϴ.

մϴ^^

 

 

 
 
޴ ȣ
޴ ȣ
 
 [SAS α׷] ѹ ٷ (1)
 [SAS α׷] SAS Լ (5)