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

Sorry about lack of information. Any help is appreciated, Thank you. ... View more

character.   Basically it showul identify number of val columns.   example if there val columns till val12 it has to get the values from val12 to val5. if it has val columns till val4 it has to get the values from val4- val1. ... View more

the word 'null' is actually missing values. The requirement is actually to have the latest 8 values and ignore old value. Example, If there are val1-val9 columns in the output i need val9-val2 values. The have dataset is actually transposed dataset, sometimes it can have just 4 columns(val1-val4) sometimes it can have 9 columns(val1-val9). ... View more

data want; set have; array x val1-val8; array z(8) $ _temporary_; n=8-cmiss(of x(*)); do i=n to 1 by -1; z(n-i+1)=x(i); end; do i=1 to dim(x); if not missing(x(i)) then x(i)=z(i); end; drop n i; run; Thank you. ... View more

Hi, thank you so much for the solution, but it is still not what i was expecting. I am sorry about the requirement i posted, i think it is not clear yet. Let me try to explain in more here. According to your code, it is only with data set having 3 val columns. I modified a bit, please find it below. data have; infile cards dlm='|'; input id (val1-val9) ($); cards; 1 | abc | efg | hij | klm | npo | qrs | tuv | wxy | aaa 2 | hdi | iijk | klm | null | null | null | null | null | null 3 | kkk | iikl | null | null | null | null | null | null | null 4 | klm | null | null | null | null | null | null | null | null ; There are 9 val columns and i just want 8 val columns in the want dataset. So in the output i want something like this. want id | val1 | val2 | val3 | val4 | val5 | val6 | val7 | val8 1 aaa | wxy | tuv | qrs | npo | klm | hij | efg 2 | klm | iijk | hdi | null | null | null | null | null 3 | iikl | kkk | null | null | null | null | null | null 4 | klm | | null | null | null | null | null | null | null Thank you for your help ... View more

Thank you for your reply, As you can see the have data set has multiple cal columns. Since this is transposed data that i have it can have any number of val columns. My requirement is, I need the last column value(if its not null) as the first column value in the want data set. Some id can have all the val columns with data, some can have only few val columns with data.   example: for id = 1 in have data set val8 is populated in val1 of want data similarly for id = 2 in have dataset val4 is populated in val1 of want data Hope i am clear with my explanation ... 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