Suppose i have a millions of record and i have to select 1st record and last records. Without using user written code how to implement in sas Data integration studio. ... View more

data a; input id name: $30.; datalines; 1 sachin,ramesh,tendulkar 2 narendra,modi 3 modi output wants: id name 1 sachin 1 ramesh 1 tendulkar 2 narendra 2 modi 3 modi ... View more

I want to sort the element in array and removing duplicate without using any procs and function. Please help me to get this solution.   eg: {2 3 5 2 7 6 7 1}  output {1 2 3 4 5 6 7}    ... View more