topic Re: unusual variable name when assigning columns in sql in SAS Procedures

unusual variable name when assigning columns in sql

ren2010 — Fri, 26 Mar 2010 04:50:13 GMT

I was running a sql

input table EMP is like the following:
id name sal
1 ram 300

My sql:
proc sql;
create table aa as select id,name=name,sal from emp;
quit;

In output table
id _TEMA001 sal
1 1 300

the variable _TEMA001 is numeric and has value 1 ,any one has any idea why this unusual name is appearing and why it is numeric?

Please help.

Re: unusual variable name when assigning columns in sql

andreas_lds — Fri, 26 Mar 2010 07:10:55 GMT

Can you explain what you want to achieve by using "name=name"?

Re: unusual variable name when assigning columns in sql

sbb — Fri, 26 Mar 2010 11:01:37 GMT

Share your entire SAS program code, in the context of the SAS execution log. A PROC CONTENTS output *AFTER* the PROC SQL would also be useful.

Scott Barry
SBBWorks, Inc.

Re: unusual variable name when assigning columns in sql

Doc_Duke — Fri, 26 Mar 2010 13:30:24 GMT

Read the documentation for the SELECT statement. "name=name" is a logical expression and returns a 1 or 0. Since you didn't give it a name, SAS made up one for you.

If you were just trying to rename the variable "name", use the AS operator.