BookmarkSubscribeRSS Feed

[속도] SASFILE 구문을 사용하여서 메모리에 데이터 세트 로딩 후 작업

Started ‎06-14-2020 by
Modified ‎06-14-2020 by
Views 90

DATA TEST;

 SET SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode

     SASHELP.Zipcode;

RUN;

 

 

* 매 작업 마다 하드 디스크와 메모리 사이에 I/O 발생;

%macro back;

  PROC SQL;

    CREATE TABLE BACK AS

      SELECT *

      FROM   TEST

 

      %DO I=1 %TO 10;

          UNION ALL

          SELECT *

          FROM   TEST

      %END;

      ;

  QUIT;

%MEND;

 

%BACK;

 

* 메모리에 TEST 데이터 세트를 로딩하여서 처리 후 메모리에서 제거;

sasfile TEST open;

%macro back;

  PROC SQL;

    CREATE TABLE BACK AS

      SELECT *

      FROM   TEST

 

      %DO I=1 %TO 10;

          UNION ALL

          SELECT *

          FROM   TEST

      %END;

      ;

  QUIT;

%MEND;

 

%BACK;

sasfile TEST close;

 

 

*********************************************************
- 통계분석연구회 
- 카페 : http://cafe.daum.net/statsas
- 통계분석연구회(Statistics Analysis Study) 그룹 :https://www.facebook.com/groups/statsas
* 친구 호출 : 답글에서 @다음에 친구 이름이나 페이지명 작성 후 친구 선택
(예 : @통계분석연구회) 

#통계 #빅데이터 #통계분석연구회 #데이터과학자 

Version history
Last update:
‎06-14-2020 10:22 PM
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