Hashtag (#) in foreign table´s columnname

Maze — Fri, 17 Oct 2014 08:54:32 GMT

Hi!

I´m having a problem regarding naming conventions in SAS.

I working with a table that I have no control over and one columns identifier contains a hashtag (ID_XXX#).

To insert rows via 'proc sql', I have to omit the insert column listing because SAS can´t handle the # in the one column´s name.

Since omitting this list is bad practice and may crash my program if there are changes made to the table,

I´d like to find a way to handle the problem.

How to handle column names containing hashtags

Re: Hashtag (#) in foreign table´s columnname

data_null__ — Fri, 17 Oct 2014 10:30:27 GMT

You may need to learn about SASNAMES. Using system option VALIDVARNAME=ANY you should be able to use the name. When you reference it you will need to use name literal syntax 'name'N. For example.

data _null_; 
   '(ID_XXX#)'n = 'Any name'; 
   put _all_; 
   run;

topic Hashtag (#) in foreign table´s columnname in SAS Procedures

Hashtag (#) in foreign table´s columnname

Re: Hashtag (#) in foreign table´s columnname