Able to define git branch in the setup. Is any one was able to figure out how to specify a specific folder inside a branch?   Version: SAS DI 4.906 ... View more

Hi, Thank you for your reply. This is slight change in the requirement. Sorry i wasnt clear on the first time. data have ; input id (val1-val9) ($); cards; 1 abc efg hij klm npo qrs tuv wxy aaa 2 hdi iijk klm . . . . . . 3 kkk iikl . . . . . . . 4 klm . . . . . . . . ; The output should have data from val9 to val2. Basically i need only 8 values but they should be latest, meaning it has to drop val1. ... View more

Whenever the SAS software itself asks you to contact technical support, do so. But do not supply just a little snippet, but the whole log to them (they will ask for it anyway). ... View more

Hi @melligeri    I would use something like the following code. I am not sure about the value "'NULL'" for ID 2, does it represent a missing value or does the transposed data set actually contain the quoted literal value? - In my example code I have understood it as "missing".   data xpose; ID = 1; PA_1 = 'user1'; PA_2 = 'user2'; output; ID = 2; PA_1 = 'user3'; PA_2 = 'user4'; output; ID = 3; PA_1 = 'user5'; PA_2 = ''; output; ID = 4; PA_1 = 'user6'; PA_2 = 'user7'; output; run; data master; length ID 8 PA_1-PA_6 $20; stop; run; data target; set master xpose; run; Result:   ... View more

I answered this on StackOverflow (and Reddit! Hitting all of the channels!) where it seems that the original poster wants the "name" values to be proper SAS variables. Achievable using what @BillM_SAS suggests, plus a transpose step: libname j json fileref=test; proc transpose data=j.content out=want; id name; var value; run; Output: customer_ customer_ Obs _NAME_ ID name 1 value 1 John ... View more

In the example code how are you able to fetch both the names; JSmith and MAnderson using single path in the json;"PATH": "/root/info/name" When I try to access multiple values with same path I get the output of only one value. In this case the output will be only MAnderson   Please help. ... View more