»çÀÌÆ®¸Ê  |  Contact Us
 
Ȩ > SAS Stories > SAS Ȱ¿ë ³ëÇÏ¿ì
8/23 PROC EXPORT ¿Í IMPORT ¿É¼Ç ¿Ü¿ìÁö ¾Ê°í ÀÌ¿ëÇϱâ 2010.08.23
MYSAS 4726 0
http://www.mysas.co.kr/SAS_club/d_freeboard.asp?b_no=1540&gotopage=1&con=subject&keyword=&cmd=content&bd_no=04&gubun=

PROC EXPORT ¿Í PROC IMPORTÀÇ ÀÚ¼¼ÇÑ ¿É¼Çµé »ç¿ëÀ» À§ÇØ ¸Å¹ø ¹®¼­¸¦ µÚÀû°Å¸®°Å³ª Á¤È®ÇÑ ¹®¹ýÀ» ±â¾ïÇÒ ÇÊ¿ä´Â ¾ø½À´Ï´Ù. ´ë½Å¿¡ SAS Display Manager ÀÇ ¸¶¹ý»ç¸¦ ÅëÇØ¼­ PROC EXPORT °ßº»À̳ª PROC IMPORT °ßº»À» ¸¸µé¾î¼­ ÇÁ·Î±×·¥¿¡ ºñ±³ ¶Ç ´ëÁ¶Çϸ鼭 Àû¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

SAS Display Manater ¿¡¼­ File À» ¼±ÅÃÇÑ ÈÄ Export Data ¸¦ ´©¸¥ ÈÄ¿¡ sashelp.class ¶ó´Â sas µ¥ÀÌÅÍ ¼¼Æ®¸¦ ±×³É Áý¾î ³Ö½À´Ï´Ù.(Ưº°ÇÑ Àǹ̴ ¾ø°í ±×Àú export data ÇÒ ´ë»óÀÌ ÇÊ¿äÇÒ »ÓÀÔ´Ï´Ù) ±× ÈÄ Â÷·Ê·Î ³ªÅ¸³ª´Â âµéÀ» Áö³ª¸é¼­ °¡´ÉÇÑ ¸ðµç ¿É¼Çµé¿¡ üũÇϸé


The EXPORT wizard can create a file containing PROC EXPORT commands that can be used in SAS programs to export this data again. If you want these statements to be generated, enter the filename where they should be saved.

¶ó´Â ¸Þ¼¼Áö°¡ ³ª¿Ã ¶§°¡ Àִµ¥¿ä, °£´ÜÈ÷ µð·ºÅ丮¸¦ °í¸¥ ÈÄ Export to Excel Template.sas  °°ÀÌ ÀÇ¹Ì ÀÖ´Â ÇÁ·Î±×·¥ À̸§À» ³Ö¾îÁØ ÈÄ Finish ¸¦ Ŭ¸¯ÇÏ¸é ´ÙÀ½°ú °°Àº SAS ÇÁ·Î±×·¥À» °®°Ô µË´Ï´Ù.

PROC EXPORT DATA= SASHELP.CLASS
            OUTFILE= "C:\Documents and Settings\RAITHEL_M\SAS Class.XLS"
            DBMS=EXCEL LABEL REPLACE;
     RANGE="SAS Class";
     NEWFILE=YES;
RUN;

À̸¦ ÅëÇØ ¿É¼ÇµéÀ» º¼ ¼ö ÀÖ°í Import Data ¸¶¹ý»ç¸¦ ÅëÇØ Import ¿É¼Çµéµµ º¼ ¼ö ÀÖ½À´Ï´Ù.

 
 
 
ÈÞ´ëÆù ¹øÈ£
ÈÞ´ëÆù ÀÎÁõ¹øÈ£
 
 8/24 ŸÀÌÆ²°ú Dz³ëÆ® ºÎºÐÀÇ ±½Àº ¼± ¸¸µé±â
 8/20 PROC APPEND ÀÌ¿ëÇÑ µ¥ÀÌÅÍ ¿¬°áÇϱâ