topic Re: Only use some of a variable name in SAS Procedures

Only use some of a variable name

deleted_user — Fri, 22 May 2009 12:35:23 GMT

Hello

I am working with some variables with quite long names (made out of numbers). When i run my analyses, I only want to use the first two numbers in the variable name, but how do I do that?

I have tried this:

temp_1=substr(variablename,1,2);

But it doesn't work. What am I doing wrong?

Kind regards.

Re: Only use some of a variable name

GPatel — Fri, 22 May 2009 13:14:51 GMT

Please refer to this note.....

http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000998953.htm

Re: Only use some of a variable name

sbb — Fri, 22 May 2009 16:49:20 GMT

The DATA step can only reference variable values, identified by the variable name, except when using a "dataset option" RENAME= on your SET statement possibly, or by using SAS macro language to generate your DATA step SAS code with a MACRO -- though a pre-processor DATA step could be used instead of a macro, if you lack macro coding experience.

Recommend searching the SAS support http://support.sas.com/ website using the Google advanced search argument listed below:

data step generate sas code site:sas.com

Scott Barry
SBBWorks, Inc.