I am using a select * query to extract data from oracle to create a sas dataset.
The problem is, oracle is containing column name with number as initial character or special characters.In the SAS dataset the numebr or special characters are replaced by "_".For e.g. If oracle field name is 1employee* then in SAS dataset the field name will be _employee_.
Things that I have tried out:
1. I have used the option validvarname = any.It gives warning which is not acceptable.
2. SYSERR cannot be used as I am using it to log error message.
3. Printing a part of log to other log also doesnt help.
Just curious - what problem are you looking to solve given the SAS system requirement for a non-numeric first char for SAS variables? Best to explain your INPUT and desired OUTPUT condition, with sample data, similar to what you have.