31. The following are values of the variable STYLE from the SAS data set SASUSERS.HOUSES OBS STYLE -------------------- 1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT The following SAS program is submitted: proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style; quit; Which one of the following is the value of the resulting macro variable? A. CONDO RANCH SPLIT TWOSTORY B. RANCH SPLIT CONDO TWOSTORY C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTOR Y D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT Á¤´ä : A ÇØ¼³ : PROC SQL °á°ú¹°À» ¹¯´Â ¹®Á¦ÀÔ´Ï´Ù. ÀÚÁÖ ÃâÁ¦µÇ´Â À¯ÇüÀÔ´Ï´Ù. ¿ì¼± DISTINCT´Â SELECT¿Í ÇÔ²² »ç¿ëµÇ´Â Áߺ¹Á¦°Å ¿É¼ÇÀÔ´Ï´Ù. ±×¸®°í ¹Ø¿¡ Order by·Î ¿À¸§Â÷¼ø Á¤·ÄÇØ ÁØ °ÍÀ» º¼ ¼ö Àֳ׿ä. °£´ÜÈ÷ A¶ó´Â °ÍÀ» ¾Ë ¼ö ÀÖ½À´Ï´Ù. 32. The following SAS program is submitted: proc contents data = testdata.one; run; Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure? A. proc sql; show testdata.one; quit; B. proc sql; describe testdata.one; quit; C. proc sql; show table testdata.one; quit; D. proc sql; describe table testdata.one; quit; Á¤´ä : D ÇØ¼³ : PROC CONTENTS¿Í, SQLÀÇ ºñ½ÁÇÑ ±â´ÉÀ» ¹¯°í ÀÖ½À´Ï´Ù. PROC CONTENTS´Â •general and summary information •engine/host dependent information •alphabetic list of variables and attributes •alphabetic list of integrity constraints •alphabetic list of indexes and attributes ´ÙÀ½°ú °°Àº ³»¿ëÀ» Ãâ·ÂÇÕ´Ï´Ù (±³ Àç 455 Âü°í) PROC SQL¿¡¼ DECRIB TABLEE¹®Àº Å×ÀÌºí ±¸Á¶¿Í Á¤º¸¸¦ Ãâ·ÂÇÕ´Ï´Ù. (±³Àç 173 Âü°í) DESCRIBE TABLEÀÌ °°ÀÌ ¾²¿©Á®¾ßÇϹǷΠÁ¤´äÀº DÀÔ´Ï´Ù.
|