SAS Web XML * ** * ** Web Data Analysis with SAS Input and Output of XML Data and Application to Real Estate Valuation Map Junnosuke Matsushima*, Hiro

Size: px

Start display at page:

Download "SAS Web XML * ** * ** Web Data Analysis with SAS Input and Output of XML Data and Application to Real Estate Valuation Map Junnosuke Matsushima*, Hiro"

まれあなかじゅく
5 years ago
Views:

1 SAS Web XML * ** * ** Web Data Analysis with SAS Input and Output of XML Data and Application to Real Estate Valuation Map Junnosuke Matsushima*, Hiroshi Ishijima**, Ikue Watanabe *Clinical Research Planning Department, Chugai Pharmaceutical Co., LTD. **Graduate School of International Accounting, Chuo University July 27, 2010 Web Web ( 2 ) XML ( 3 ) Web XML ( ) File name MAP SAS SAS ( ) SAS Put KML (XML ) ( 4 ) XML : Google Earth ( 5 ) CSV CSV SAS ( ) SAS Google Earth 1 1

2 SAS WebXML Web Google Earth XML, Filename, Valuation Map, Google Earth 2 WebWeb WebSAS 2 1. Web SAS 2. Web Web XML(eXtensible Markup Language) 3 2

3 XML () XMLWeb XHTML RSS Web API 4 XHTML 5 3

4 RSS 6 Web API 7 4

5 WebSAS 2 1. Web SAS? 2. Web? WebXML Web XML SAS XML 8 : XML 9 5

6 1. Web Web 2. SAS 3. Web Google Earth Google Maps 10 : 3 1. Web! (Web)API XML SAS SAS 2. SAS ( ) 3. Web SAS KML(XML ) Google Earth Google Maps 11 6

7 SAS Web XML SAS SAS SAS SASXML Web Google 12 Web Web ( 2 ) XML ( 3 ) Web XML ( ) File name MAP SAS SAS ( ) SAS Put KML (XML ) ( 4 ) XML : Google Earth ( 5 ) CSV CSV SAS ( ) SAS Google Earth 13 7

8 Web Filename filename < > url <URL> ( ) ; <URL> URL ( ) 14 WEB

9 ! API 16 URL

$junk length=len; input record $varying8192. len; 6 run; 7 8 9 10 11 data; set data1; file 'C:\mysasfiles\xml\in.xml' termstr=lf encoding="utf-8" lrecl=8192; put record; run; 2.1 C:\mysasfiles\xml\in.$

10 18 Web Filename filename < > url <URL> ( ) ; SAS 1 options validvarname=any ; 2 filename junk url URL encoding="utf-8" Filename URL termstr=lf debug lrecl=8192; URL 3 data data1; Infile 4 5 infile junk length=len; input record $varying8192. len; 6 run; data; set data1; file 'C:\mysasfiles\xml\in.xml' termstr=lf encoding="utf-8" lrecl=8192; put record; run; 2.1 C:\mysasfiles\xml\in.xml 19 10

11 Web Web ( 2 ) XML ( 3 ) ( 4 ) XML : Google Earth ( 5 ) Web XML ( ) CSV CSV File name MAP SAS SAS ( ) SAS SAS ( ) SAS Put KML (XML ) Google Earth 20 XML3 XML 1 <?xml version= 1.0 encoding= windows-1252?> 3 2 <TABLE> TABLE 3 <CLASS> CLASS 4 <NAME> Taro </NAME> NAME 5 <SEX> Male </SEX> SEX 6 <AGE> 25 </AGE> AGE 7 </CLASS> 8 <CLASS> Obs AGE SEX NAME 9 <NAME> Hanako </NAME> 10 <SEX> Female </SEX> 1 25 Male Taro 11 <AGE> 24 </AGE> 2 24 Female Hanako 12 </CLASS> 13 </TABLE>

12 SAS ( 3 ) SAS 1 Libname trans xml C:\mysasfiles\xml\basic.xml ; XML 2 Libname myfiles C:\mysasfiles\xml ; 3 data myfiles.class; 4 set trans.class; 5 run; XML CLASS SAS 3? 22 XML MAP XML results apartment id area name MAP SAS APARTMENTS id areaname

13 XML <?xml version="1.0" encoding="utf-8"?> <results xmlns=" <api_version>1.0</api_version> <apartment> <id> </id> <area> <name></name> <code>030</code> </area> </apartment> <apartment> </apartment> </results> XMLMAP MAP <?xml version="1.0"?> <SXLEMAP version="1.2"> <TABLE name="apartments"> <TABLE-PATH syntax="xpath"> /results/apartment </TABLE-PATH> <COLUMN name="id"> <PATH>/results/apartment/id</PATH> <TYPE>character</TYPE> <DATATYPE>STRING</DATATYPE> <LENGTH>15</LENGTH> </COLUMN> <COLUMN name="areaname"> <PATH>/results/apartment/area/name</PATH> <TYPE>character</TYPE> <DATATYPE>STRING</DATATYPE> <LENGTH>8</LENGTH> </COLUMN> </TABLE> </SXLEMAP> SAS SAS 1 filename RESULTS 'C:\mysasfiles\XML\in.xml' ; XML 2 filename MAP 'C:\mysasfiles\XML\in.map' ; MAP 3 libname RESULTS xml xmlmap=map MAP xmlconcatenate=yes ; 4 libname MYFILES 'C:\mysasfiles\XML' ; 5 data MYFILES.APARTMENTS; 6 set RESULTS.APARTMENTS; 7 run; XML APARTMENT SAS MAPXML SAS 25 13

14 Web Web ( 2 ) XML ( 3 ) ( 4 ) XML : Google Earth ( 5 ) Web XML ( ) CSV CSV File name MAP SAS SAS ( ) SAS SAS ( ) SAS Put KML (XML ) Google Earth 26 1 Box-Cox 3 N } K ( l ) ( l ) ( k ) ( k ) ( k ) Hij ( ) xij xij { { i ij 123 { l 1 k (1) : (Box-Cox) (2) 1 : () (2) 1 : (+ ) 4 (3) 2 : ( ) (3) 2 : () (4) : 27 14

15 2 (, 2009) 1: 2: 28 3 ~ 1 ~ 1: Box-Cox (Box-Cox) : Hij 1 ( 0 ) Hij ( ) : log Hij ( 0 ) = 1 = 1 =0 = 29 15

16 4 ~ 2 ~ 2: Box-Cox : K } } ( k ) ( k ) ( k ) x ij i { k k k k = = 30! (Web) () 8 ( i j (Hij) k ( k ) ) : Box-Cox : PROC MIXED λ Gurka et al (2006) x ij 31 16

17 3 3 41, ( <.0001 ) () ( ) ( ) Box-Cox (λ= -0.05) 39, ( <.0001 ) 39, ( <.0001 ) 38, ( <.0001 ) 39, ( <.0001 ) 38, ( <.0001 ) 36, ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) 8,552 4,856 3,940 3,945 3,518 3,458 2,581 ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) ( <.0001 ) 4 32 Web Web ( 2 ) XML ( 3 ) ( 4 ) XML : Google Earth ( 5 ) Web XML ( ) CSV CSV File name MAP SAS SAS ( ) SAS SAS ( ) SAS Put KML (XML ) Google Earth 33 17

18 XML ~ Google Earth ~ Google Earth Web kml

19 XMLSAS XML SAS Web MAP SAS ( ) XML ( ) SAS KML (XML ) CSV SAS ( ) CSV SAS Google Earth 37 19

20 KML KML 1 <?xml version="1.0" encoding="utf-8"?> 2 <KML xmlns=" <DOCUMENT> <STYLE ID="ICON3"> <ICONSTYLE > </ICONSTYLE> 6 </STYLE> 7 <STYLE ID="ICON4"> header <ICONSTYLE > </ICONSTYLE> </STYLE> <PLACEMARK> <NAME> </NAME> <STYLEURL> #ICON4 </STYLEURL> <DESCRIPTION> </ DESCRIPTION> <POINT> <COORDINATES> , </ COORDINATES> 18 </POINT > 19 (20) 21 </ PLACEMARK > </DOCUMENT> 22 </KML> DOCUMENT STYLE STYLE ICONSTYLE PLACEMARK NAME STYLEURL STYLE DESCRIPTION POINT COORDINATES KML3 header STYLE <PLACEMARK> <PLACEMARK> footer <PLACEMARK> footer SAS : SASKML data MYFILES.APARTMENTS; set MYFILES.APARTMENTS; keep id name tag1 tag2 ; tag1 = '<Placemark><name>' ; tag2 = '</name><styleurl>' ; run; 39 20

21 SAS : Header, Footer Header Footer %LET kml_header_file="c:\mysasfiles\output\kml_header.csv"; %LET kml_footer_file="c:\mysasfiles\output\kml_footer.csv"; Header Footer SAS proc import datafile=&kml_header_file out=myfiles.kml_header replace; getnames=no; run; proc import datafile=&kml_footer_file out=myfiles.kml_footer replace; getnames=no; run; 40 SAS : KML KML %LET kml_file="c:\mysasfiles \out.kml"; kml_headerheaderapartments kml_footerfooter SAS KML data; set MYFILES.kml_header MYFILES.APARTMENTS MYFILES.kml_footer; file &kml_file termstr=lf encoding="utf-8" lrecl=8192; put var1 tag1 name tag2 address ; run; 41 21

22 Web Web ( 2 ) XML ( 3 ) Web XML ( ) File name MAP SAS SAS ( ) SAS Put KML (XML ) ( 4 ) XML : Google Earth ( 5 ) CSV CSV SAS ( ) SAS Google Earth 42 WebXMLSAS SASXML 3 1. Web Filename 2. XML SAS MAP 3. SASXML XMLHeader Footer 43 22

5 Armitage x 1,, x n y i = 10x i + 3 y i = log x i {x i } {y i } 1.2 n i i x ij i j y ij, z ij i j 2 1 y = a x + b ( cm) x ij (i j )

5 Armitage x 1,, x n y i = 10x i + 3 y i = log x i {x i } {y i } 1.2 n i i x ij i j y ij, z ij i j 2 1 y = a x + b ( cm) x ij (i j ) 5 Armitage. x,, x n y i = 0x i + 3 y i = log x i x i y i.2 n i i x ij i j y ij, z ij i j 2 y = a x + b 2 2. ( cm) x ij (i j ) (i) x, x 2 σ 2 x,, σ 2 x,2 σ x,, σ x,2 t t x * (ii) (i) m y ij = x ij /00 y