topic Re: modify the variable names within a limited list in New SAS User

modify the variable names within a limited list

PierreYvesILY — Wed, 24 Jul 2019 13:29:45 GMT

hello,

I used the following code to rename variables and add a suffix to all variable names of my dataset.

proc sql noprint; /* Variablen umbennennen */

select cats(name,'=',name,'_&Jahr11.')

into :list

separated by ' '

from dictionary.columns

where libname = 'WORK' and memname = "FICHIER_1";

quit;

proc datasets library = work nolist;

modify fichier_1;

rename &list;

quit;

proc contents data = work.fichier_1 ; run;

The variables are correctly renamed, however a few of them didn't need a rename.

So, I'm asking for help to:

option 1: modify the above code in order to exclude a limited list of variable names to be renamed

option 2: remove the suffix from the names of this limited list of variable names.

What can I do best?

Thanks for your help

Re: modify the variable names within a limited list

PaigeMiller — Wed, 24 Jul 2019 13:35:29 GMT

@PierreYvesILY wrote:

The variables are correctly renamed, however a few of them didn't need a rename.

Please explain this part further.

Please show us your LOG (the entire log, not just the error messages) by copying the text of the log and pasting it into the window that appears when you click on the {i} icon. Do not paste the log directly into the reply window.

Re: modify the variable names within a limited list

PierreYvesILY — Wed, 24 Jul 2019 13:57:17 GMT

hello Paige,

the code works, so there are no errors in the log. The log contains too many infos that cannot be displayed out of the company, I cannot send it.

This code renames ALL variables names, and I want to limit this: 6 different variables don't need to be renamed (I want to keep them as they are named). All of them are alphanumeric. On the contrary, ALL variables that need to be renamed are numeric.

Let's say, I have the following variables in the dataset: STUFE REGION AGENCY PRODUCTION RATE GROWTH ...

[ ALPHANUMERIC NUMERIC ] (the real number of numeric variables is high)

I want to add a macrovariable _&Jahr11. to all numeric variable names, and obtain:

STUFE REGION AGENCY PRODUCTION_&Jahr11. RATE_&Jahr11. GROWTH_&Jahr11. ...

I hope the context is clear now.

Re: modify the variable names within a limited list

Tom — Wed, 24 Jul 2019 13:59:47 GMT

Why not just tweek the WHERE clause?

where libname = 'WORK' and memname = "FICHIER_1"
  and upcase(name) not in ('VAR1','VAR2','VAR3')

Re: modify the variable names within a limited list

PaigeMiller — Wed, 24 Jul 2019 14:03:49 GMT

On the contrary, ALL variables that need to be renamed are numeric.

from dictionary.columns
where libname = 'WORK' and memname = "FICHIER_1" and type='num';

For future reference, you can look inside the dictionary.columns data set to see what is in there in case you ever need to use other columns for some purpose; in the SAS Explorer window this dictionary.columns data set is called SASHELP.VCOLUMN.

Re: modify the variable names within a limited list

PierreYvesILY — Wed, 24 Jul 2019 15:18:47 GMT

hi Paige,

I used the version " and type = 'num' " and it worked perfectly.

thanks a lot,

regards

Re: modify the variable names within a limited list

PierreYvesILY — Wed, 24 Jul 2019 15:19:59 GMT

I also tested this code version with success.