Return to Snippet

Revision: 56396
at March 26, 2012 14:44 by ccw


Initial Code
LIBNAME EDA ORACLE  PATH=XE  SCHEMA=EDA  USER=eda  PASSWORD=eda;

DATA WAT;
    SET EDA.WAT;
    KEEP PRODUCT_NAME SPEC_FILE LOT_ID WAFER_ID SITE_ID ATT1 ATT2 ATT3;
    WHERE LOT_ID like 'P0M78.1';
RUN;

DATA _NULL_;
    file print PS=32767;
    set WAT end=lastrec;
    if _N_ eq 1 then do;
        put '[';
    end;
    put '{"productName":"' PRODUCT_NAME '",';
    put '"lotId":"' LOT_ID '",';
    put '"waferId":' WAFER_ID ',';
    put '"siteId":"' SITE_ID '",';
    put '"specFile":"' SPEC_FILE '",';
    put '"attrs": [';
    put '{"attr1":' ATT1 '},';
    put '{"attr2":' ATT2 '},';
    put '{"attr3":' ATT3 '}]}';
 
    if lastrec eq 1 then do;
        put ']';
    end;
    else do;
        put ',';
    end;
RUN;

Initial URL


Initial Description
SAS code to output in JSON format

Initial Title
[SAS] JSON output

Initial Tags
json

Initial Language
SAS