PROC GROOVY 解析JSON

標籤：card   nes   idcard   one   尋找   class   bsp   header   代碼   

 

 

參考：http://saslist.com/blog/category/json/

下載jdk和groovy
1.安裝jdk 預設安裝
2解壓groovy:到C:\Program Files (x86)\
參照http://saslist.com/blog/category/json/ 關於groovy的那段，配置groovy，並設定系統變數：
**********
（1）JDK的配置：
設定環境變數%JAVA_HOME%\bin，值為放置解壓檔案的目錄，如C:\Program Files (x86)\Java\jdk1.8.0_141
增加環境變數path，指向%GROOVY_HOME%\bin
（2）groovy配置
設定環境變數GROOVY_HOME，值為放置解壓檔案的目錄，如C:\Program Files (x86)\groovy-2.4.12
增加環境變數path，指向%GROOVY_HOME%\bin
（3）找到SAS執行程式的路徑,如C:\Program Files\SASHome\SASFoundation\9.4
該路徑下的\nls\en的sasv9.cfg，尋找JREOPTIONS，添加
-Dtkj.app.class.path=C:\Program Files (x86)\Groovy\groovy-2.4.12\embeddable\groovy-all-2.4.12.jar

3將解析結果放在csv裡面，需要將opencsv-3.10放在groovy安裝包下面embeddable下面

4.接下來就可以在Groovy控制台中編寫指令碼了，在Windows控制台(cmd)下輸入groovyconsole命令進入groovy控制台，在裡面輸入代碼 println "HelloWorld"斷行符號，按按鍵組合CTRL+R就可以看到運行結果了。

解析：

json:

{
"acct_nbr": 1234,
"firstName": "John",
"lastName": "Smith",
"age": 25,
"address": {
"streetAddress": "21 2nd Street",
"city": "New York",
"state": "NY",
"postalCode": "10021"
}
}
,
{
"acct_nbr": 3456,
"firstName": "Sam",
"lastName": "Jones",
"age": 32,
"address": {
"streetAddress": "25 2nd Street",
"city": "New Jersy",
"state": "NJ",
"postalCode": "10081"
}
}

解析代碼：

%let groovydir=C:\Program Files (x86)\groovy-2.4.12\embeddable; *the location the groovy JARs are located at;

%let sourcefile=.\data\test_1.txt;
%let outfile=.\data\test_1.csv;

proc groovy classpath="&groovydir.\groovy-all-2.4.12.jar;&groovydir.\opencsv-3.10.jar";

submit "&sourcefile" "&outfile";
import groovy.json.*/*載入json包*/
import com.opencsv.*

def input = new File(args[0]).text
def output = new JsonSlurper().parseText(input)
def csvoutput = new FileWriter(args[1])

CSVWriter writer = new CSVWriter(csvoutput);

String[] header = new String[2];
header[0] = "user_basic";
header[1] = "user_blacklist";
writer.writeNext(header);

output.statuses.each {
String[] user_basic_content1 = new String[8];
content[0] = it.user_basic.user_age.toString();
content[1] = it.user_basic.user_city.toString();
content[2] = it.user_basic.user_gender.toString();
content[3] = it.user_basic.user_idcard.toString();
content[4] = it.user_basic.user_idcard_valid.toString();
content[5] = it.user_basic.user_name.toString();
content[6] = it.user_basic.user_phone.toString();
content[7] = it.user_basic.user_phone_city.toString();
writer.writeNext(user_basic_content1);
}

writer.close();

endsubmit;
quit;

PROC GROOVY 解析JSON