SELECT COLUMN

jeremy7 — Thu, 18 Aug 2022 13:17:39 GMT

Hi,

How can I select column name with _ and space like name _category.

Is there any way in SAS that can standardize the column name ?

Re: SELECT COLUMN

Tom — Thu, 18 Aug 2022 13:23:44 GMT

@jeremy7 wrote:

Hi,

How can I select column name with _ and space like name _category.

Is there any way in SAS that can standardize the column name ?

To reference a name that does not follow normal rules you have to use a name literal

'name _category'n

What is the SOURCE of the data that has names with spaces in them?

To allow SAS to use such names you have to have set the VALIDVARNAME option to ANY.

If the source was an Excel file or text file that you imported you could set the VALIDVARNAME back to V7 and then re-import the data. PROC IMPORT should then convert those invalid names to something usable. Perhaps name__category.

Re: SELECT COLUMN

Reeza — Thu, 18 Aug 2022 15:03:56 GMT

Add this to the top of your code and re-run it.

options validvarname=v7;

topic Re: SELECT COLUMN in SAS Programming

SELECT COLUMN

Re: SELECT COLUMN

Re: SELECT COLUMN