More simply with SAS/ETS you could simply have, since the id variable is already id and we want to expand all the other variables: /*modify 0's to missing and expand*/ data foo; set foo; array v[7]; do _n_=1 to 7; if v[_n_]=0 then call missing(v[_n_]); end; proc expand; run; ... View more

@art297, I posted a PROC EXPAND example and another using PROC TRANSREG for good measure. For further reading I would recommend the following topic from SAS-L: http://marc.info/?t=139164201000004&r=1&w=2 ... View more

Without SAS/ETS you can use PROC TRANSREG: %macro foo; data v_foo/view=v_foo;    set foo;    array v[7];    do _n_=1 to 7;       if v[_n_]=0 then call missing(v[_n_]);       end;    run; proc means data=v_foo;    var v1-v7;    output out=nknots n= /autoname;    run; data _null_;    set nknots;    array v[7] v1_n--v7_n;    do i=1 to 7;       call symputx(cats('nknots', i), v-2);    end;    stop;    run; data foospline;    set foo;    call missing(of pv1-pv7);    run; %do i=1 %to 7;    proc transreg data=v_foo;       model identity(v&i.)=spline(id / degree=1 nknots=&&nknots&i..);       output out=fooLin&i.(keep=id pv&i.) predicted;       run;    data foospline;       update foospline foolin&i.;       by id;       run;    %end; %mend; %foo %macro foo; data v_foo/view=v_foo;    set foo;    array v[7];    do _n_=1 to 7;       if v[_n_]=0 then call missing(v[_n_]);       end;    run; proc means data=v_foo;    var v1-v7;    output out=nknots n= /autoname;    run; data _null_;    set nknots;    array v[7] v1_n--v7_n;    do i=1 to 7;       call symputx(cats('nknots', i), v-2);    end;    stop;    run; data foospline;    set foo;    call missing(of pv1-pv7);    run; %do i=1 %to 7;    proc transreg data=v_foo;       model identity(v&i.)=spline(id / degree=1 nknots=&&nknots&i..);       output out=fooLin&i.(keep=id pv&i.) predicted;       run;    data foospline;       update foospline foolin&i.;       by id;       run;    %end; %mend; %foo With SAS/ETS: data foo; set foo; array v[7]; do _n_=1 to 7; if v[_n_]=0 then call missing(v[_n_]); end; run; *remove comments to forward copy over beginning missing values in series; /* data a;    set foo;    a=1;    run; proc sort data=a; by descending id; run; data a(drop=a);    update a(obs=0) a;    by a;    run; data foo;    update foo a;    by id;    run; */ %macro foo; proc expand data=foo out=fooLin;    %do i=1 %to 7;       convert v&i.=pv&i. /method=join; *or could be convert v1-v7 /method=join  --without macro, difference is no copy of input values;    %end;    run; %mend; %foo ... View more

Your macro variable is not local to the remote submission.  Use %syslput. http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a001221974.htm ... View more

filename cp temp; proc groovy classpath=cp; add sasjar="groovy_2.1.3" version="2.1.3.0_SAS_20130517000930"; submit parseonly; import groovy.json.JsonSlurper class MyJsonParser {     def parseFile(path) {      def jsonFile = new File(path)   def jsonText = jsonFile.getText()         def InputJSON = new JsonSlurper().parseText(jsonText)         def accounts = []         InputJSON.results.each{             accounts << [                     acct_nbr      : it.acct_nbr.toString(),                     firstName     : it.firstName,                     lastName      : it.lastName,                     age           : it.age.toString(),                     streetAddress : it.address.streetAddress,                     city          : it.address.city,                     state         : it.address.state,                     postalCode    : it.address.postalCode             ]         }         return accounts     } } endsubmit; submit parseonly; import java.util.ArrayList; import java.util.Iterator; import java.util.LinkedHashMap; public class MyJsonParser4Sas {     public String filename = "";     public void init() {         MyJsonParser myParser = new MyJsonParser();         accounts = myParser.parseFile(filename);         iter = accounts.iterator();     }     public boolean hasNext() {         return iter.hasNext();     }     public void getNext() {         account = ((LinkedHashMap) (iter.next()));     }     public String getString(String k) {         return account.get(k);     }     protected ArrayList accounts;     protected Iterator iter;     protected LinkedHashMap account; } endsubmit; quit; options set=classpath "%sysfunc(pathname(cp,f))"; filename json "/home/mkastin/Desktop/foo.json"; data accounts;    attrib id            label="Account Index"  length=    8           acct_nbr      label="Account Number" length=$  10           firstName     label="First Name"     length=$  20           lastName      label="Last Name"      length=$  30           age           label="Age"            length=$   3           streetAddress label="Street Address" length=$ 128           city          label="City"           length=$  40           state         label="State"          length=$   2           postalCode    label="Postal Code"    length=$   5;    dcl javaobj accounts("MyJsonParser4Sas");    accounts.exceptiondescribe(1);    accounts.setStringField("filename", "%sysfunc(pathname(json,f))");    accounts.callVoidMethod("init");    accounts.callBooleanMethod("hasNext",rc);    do id=1 by 1 while(rc);       accounts.callVoidMethod("getNext");    accounts.callStringMethod("getString", "acct_nbr", acct_nbr);    accounts.callStringMethod("getString", "firstName", firstName);    accounts.callStringMethod("getString", "lastName", lastName);    accounts.callStringMethod("getString", "age", age);    accounts.callStringMethod("getString", "streetAddress", streetAddress);    accounts.callStringMethod("getString", "city", city);    accounts.callStringMethod("getString", "state", state);    accounts.callStringMethod("getString", "postalCode", postalCode);       output;    accounts.callBooleanMethod("hasNext",rc);    end;    drop rc; run;           1 1234 John Smith 25 21 2nd Street New York NY 10021 2 3456 Sam Jones 32 25 2nd Street New Jersy NJ 10081 A few notes: 1. The json as shared here is invalid and should be wrapped in "{}" 2. In windows you will need to modify the file's name in one of following ways 2a. escape the \ as \\, for example C:\json.txt would be C:\\json.txt 2b. use forward slash instead of backslash, for example C:\json.txt would be /C:/json.txt 2c. use a file uri specification ie. file://C:/json.txt 3. The add sasjar statement is specific to your version or SAS and OS, check your versioned jar repositiory as part of your installation or use a different groovy-all jar, as you had in OP ... View more

\/|^\s+$ Match either the regular expression below (attempting the next alternative only if this one fails) «\/»    Match the character “/” literally «\/» Or match regular expression number 2 below (the entire match attempt fails if this one fails to match) «^\s+$»    Assert position at the beginning of a line (at beginning of the string or after a line break character) «^»    Match a single character that is a “whitespace character” (spaces, tabs, and line breaks) «\s+»       Between one and unlimited times, as many times as possible, giving back as needed (greedy) «+»    Assert position at the end of a line (at the end of the string or before a line break character) «$» ... View more

A good thing to learn would be that this is an inefficient use-case for regular expression. ... View more

You main issue is having 'and' where it should be 'or.'  I would not recommend using the regular expression, given your example (which I would also rewrite as prxmatch('#/|^\s+$#o', var) given your explained requirements). where index(var, '/') or missing(var); ... View more