Desktop productivity for business analysts and programmers

Special Character in Column Names

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Special Character in Column Names

Hello,

 

I was importing a access to SaS using a c# application, for the script works, i have to read all the access and create a txt with the columns names and data values.

 

The problem is the column name have the special character "/", i can change the name because its a legacy database.

When i import the file using the Enterprise guide, the script works, but when i try to do that with c# application, i receveid the follow message:  "'PAB/PAE'n $CHAR5.
ERROR: The name PAB/PAE is not a valid SAS name." .

 

If i try to run the code in the Enterprise Guide, i its works. I think i have to pass some options on the code, but i don´t know what options and in the code create in the Guide, don´t have that option.

 

Someone already have this problem?

 

Thank you.

 

Raphael Gnecco


Accepted Solutions
Solution
‎01-10-2018 01:47 PM
Super User
Posts: 5,917

Re: Special Character in Column Names


All Replies
Solution
‎01-10-2018 01:47 PM
Super User
Posts: 5,917

Re: Special Character in Column Names

Occasional Contributor
Posts: 12

Re: Special Character in Column Names

Thank you
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 167 views
  • 0 likes
  • 2 in conversation