topic Re: how to make the type of all the variables same? in SAS Programming

how to make the type of all the variables same?

srikanthyadav44 — Tue, 03 Sep 2019 09:20:52 GMT

dear all

i have 40 different variables in my dataset.

some of the variables are in character form and some are numeric.

I have to convert all tthe variables into numeric form.

how to do it in SAS.

thanks in advance.

Re: how to make the type of all the variables same?

PeterClemmensen — Tue, 03 Sep 2019 09:22:15 GMT

Read this

Sample 40700: Convert all character variables to numeric and use the same variable names in the output data set

Re: how to make the type of all the variables same?

Kurt_Bremser — Tue, 03 Sep 2019 09:22:54 GMT

Ideally, you do that when you import the data into SAS by making sure that the values are read correctly.

How did you receive the data, and how did you import it?

Re: how to make the type of all the variables same?

srikanthyadav44 — Tue, 03 Sep 2019 10:57:02 GMT

dear draycut

i tried the following code from the link suggested by you.

But it is not working.

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;   

there are some other codes also. but i could not understand them. 

i am attaching the error displayed by SAS

please help me solving the problem

thanks in advance