07-25-2014 03:59 PM
It doesn't matter if using infile/input, proc sql or a data step. I am interested in selecting a column by it's position and renaming it. I will have a SAS dataset where the column names might change, one is only 2*3, very small but I have to reference it and cannot bet on the variable names being constant going forward. Any way to select the variable names by ordinal position and rename them?
07-25-2014 05:31 PM
In a data step you can define an ARRAY and reference the columns by their index. Say you want to work with numeric column number 3.
07-25-2014 05:39 PM
Or you can rename all the variable using their column index.