topic Remove "." in Variable Name in SAS in SAS Enterprise Guide

Remove "." in Variable Name in SAS

WL2 — Fri, 17 Jun 2022 16:17:20 GMT

I need to use SAS EG 8 to work on some tables. however in each variable name has ".",how to remove them?

For example , table name is T1, the variable name in T1 is like T1.V1, T1.V2 and so on..

thanks

Re: Remove "." in Variable Name in SAS

Tom — Fri, 17 Jun 2022 16:24:10 GMT

Really? That looks like the way you would reference a variable named V1 from a table named T1 in SQL code. Are you sure the actual variable have those named? Run PROC CONTENTS to confirm that those are the actual variable names.

If you do have variable names like that which do NOT follow normal naming conventions you will need to reference them using name literals.

rename "t1.v1"n=v1;

Re: Remove "." in Variable Name in SAS

ballardw — Fri, 17 Jun 2022 16:24:05 GMT

Did you create the data sets?

Re: Remove "." in Variable Name in SAS

Reeza — Fri, 17 Jun 2022 16:24:14 GMT

That sounds like an alias that's used in SQL. Can you provide more context on what is happening here and what you're trying to do.

In SQL you will often alias a table as t1, and then t1.v1 is a variable, v1, from table t1 because different tables can have the same names.