Thank you for the feedback. Here is more details on what I'm trying to accomplish; Originally, I tried to apply below macro which is automaticallt converts char to numeric data type with original names and labels which I need it for the dataset. http://www.nesug.org/Proceedings/nesug10/ff/ff01.pdf However since I have too many variables ( around 4000 out of 7000 with Prefix XXXX) , this macro fails because of limit on variable counts. I tried to modify the macro with variable creation number like first 1 to 500 and then 501 to 1000 and so on, but this is making process much more complex. I was wondering if there is an optimal way of converting these variables from char to numeric with keeping their original name and labels ?
... View more