I have about 100 numeric variables in the dataset, plus one character variable for the purpose of identification. For each numemic variable, the values can be negative or positive, and the values are not sorted in a proper order. For each variable, I want to pick up the smallest positive value. For example, -10, 2, 0.5, then the value 0.5 should be choosed. Together with the smallest positive value, the value of the character variable should also be choosed for the purpose of identification. The final output should be a dataset with a single row, with all values representing the smallest positive values for the numeric variables. Hope this is not that challenging and complex. Thanks a lot for help.
... View more