@Neeydchi wrote:
/*---- Start of User Written Code ----*/
data &_OUTPUT;
set &_INPUT;
by id;
lvalue=lag(value);
if last.id then do;
length newvalue $ 1024;
newvalue= catx(' - ',lvalue,value);
output;
end;
keep id newvalue;
run;
/*---- End of User Written Code ----*/
the result is as I mentioned earlier, the code is concatenating the values with different id but with the same type. Although I also cannot understand why.
As was stated when posted that code requires that each value of ID has EXACTLY two observations. In addition it requires that the TYPE='NAME' value is the first and the TYPE='URL' value is the second.
So if the real data does not meet that restriction you cannot use this method.
... View more