Converting all variable types from character into numerical variables

YR1415 — Fri, 16 Jul 2021 08:17:17 GMT

I want to convert all the variable types in the table from characters into numerical types.

and here is the sample.

/*The sample dataset TEST contains both character and numeric variables*/
data test;
input id $ b c $ d e $ f;
datalines;
AAA 50 11 1 222 22
BBB 35 12 2 250 25
CCC 75 13 3 990 99
;
run;
/*PROC CONTENTS is used to create an output dataset called VARS to list all*/
/*variable names and their type from the test dataset*/
PROC contents data=test out=vars(keep=name type) noprint;

data vars;
set vars;
if type=2 and name ne'id';
newname=trim(left(name))||"_n";
run;

options symbolgen;
proc sql noprint;
select trim(left(name)),trim(left(newname)),
trim(left(newname))||'='||trim(left(name))
into :c_list separated by '',:n_list separated by '',
:renam_list separated by ''
from vars;
quit;

data test2;
set test;
array ch(*) $ &c_list;
array nu(*) $ &n_list;
do i=1 to dim(ch);
nu(i)=input(ch(i),8.);
end;
drop i &c_list;
rename &renam_list;
run;
proc contents data=test2;
run;

But in the code line 'rename &renam_list',

when I run it in the 'log' session, I see the error below:

SYMBOLGEN: Macro variable C_LIST resolves to ce

SYMBOLGEN: Macro variable RENAM_LIST resolves to c_n=ce_n=e

109 rename &renam_list;

NOTE: Line generated by the macro variable "RENAM_LIST".

109 c_n=ce_n=e

ERROR 22-322: Expecting a name.

Could someone help me to solve this problem, what does 'Expecting a name' means in my situation?

Tks!!!

Re: Converting all variable types from character into numerical variables

Kurt_Bremser — Fri, 16 Jul 2021 10:09:40 GMT

You forgot to use blanks in the SEPARATED BY clause.

Why don't you make sure that the data is read correctly when you import it into SAS?

topic Re: Converting all variable types from character into numerical variables in New SAS User

Converting all variable types from character into numerical variables

Re: Converting all variable types from character into numerical variables