* 질문 : http://cafe.daum.net/statsas/B3m/13218
DATA BACK;
FORMAT START END MONTH YYMMDDN8.;
INPUT (START END MONTH)(: YYMMDD8.) AMT;
CARDS;
20070701 20110601 20081201 1000000
;
* 최종날짜와 증감날짜가 같은 때 까지 관측치를 출력
DATA BACK1;
SET BACK;
PUT _ALL_;
DO UNTIL(CHK = END);
FORMAT CHK YYMMDDN8.;
CHK=INTNX('MONTH',START,I);
if month ne chk then amt1=0;
else amt1=amt;
OUTPUT;
I+1;
END;
DROP AMT I;
RUN;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.