data want; set have (rename=(name=_name)); do i = 1 to countw(_name,","); name = scan(_name,i,","); output; end; drop i _name; run; Untested for lack of usable example data. ... View more

/*Plz post the data step code, Nobody would like to type it for you !*/ data have; input prod geo r1-r4; cards; 301 3001 . 300 . 600 301 3001 100 . 500 700 301 3001 200 400 . . 302 3002 10 . 50 . 302 3002 . 20 . 80 302 3002 . 30 40 70 ; data temp; set have; by prod geo ; if first.geo then n=0; n+1; run; proc sort data=temp;by prod geo descending n; data want(drop=n); update temp(obs=0) temp; by prod geo ; run; ... View more

If I have my JSON in the following format: { "parameters":{ "type":"SEARCH_INDEX_LOADER", "filters":[ { "type": "incrementalLoad", "startTime": "2021-07-23T00:00:00.000Z" } ] }, "tasks":[ { "parameters":{ "type":"LOAD_DOCUMENT", "name":"EMPLEADO", "filters":[ { "type": "incrementalLoad", "startTime": "2021-07-23T00:00:00.000Z" } ] }, "tasks":[ { "parameters":{ "type":"LOAD_DOCUMENT", "name":"EMPLEADO" } }, { "parameters":{ "type":"LOAD_DOCUMENT", "name":"COMERCIO" } } ] }  And let say I want to edit the startTime under the second key i.e. tasks keyword instead of the first startTime under first parameters key. Then is it possible to do so? ... View more