Hi,
I am reading data from a Oracle table into temp table in WORK library. While creating temp table in SAS it is replacing one of the column name character to $. So the column name in table is
Actual Name- abc__ (it has 2 underscores)
SAS reading it as :- abc_$
And this is happening for all column names with double underscores but only on my SAS EG.
So 1 one of the underscore is getting replaced by "$" sign, now this code cant be changed because many others are using it and its working well on their SAS EG except min. Can anyone help with the solution why column is getting wrongly read by SAS.
Thanks ,
RDS
1. Are these variable names or labels being impacted?
2. How are you retrieving your data from the DB?
3. What is the length of the variable names in Oracle? Are they less than 32 characters in total?
4. What is your validvarname option set to? ANY is the default in EG, you most likely want it to be V7 though.
Thanks for responding. It cannot be issue with code or reading since it is working fine for everyone else
1. Are these variable names or labels being impacted?
Reply 1- No, I am simply creating table by Selecting all from the oracle Table
2. How are you retrieving your data from the DB?
Reply 2- Inside a Proc Creating a table by selecting * from the table name
3. What is the length of the variable names in Oracle? Are they less than 32 characters in total?
Reply 3- This code is working fine for all other colleagues so this cant be an issue. But still the characters in column name are between8-10
4. What is your validvarname option set to? ANY is the default in EG, you most likely want it to be V7 though.
Reply 4- I am not aware of this but this not set in Code for sure. You mean this has to be set in Code or in Option Tab. Cant set in the Code since change would be required for it.
Thankss,
RDS
options validvarname = v7;
That's another way to change that setting.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.