BookmarkSubscribeRSS Feed

[SAS 프로그래밍 고수 백승민] [DO UNTIL] 날짜 증가하여 관측치 생성하기

Started ‎06-11-2020 by
Modified ‎06-11-2020 by
Views 99

* 질문 : 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;

Version history
Last update:
‎06-11-2020 05:25 AM
Updated by:
Contributors

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

Article Labels
Article Tags