topic Re: Merging error in New SAS User

Merging error

nmlynar13 — Fri, 23 Apr 2021 01:50:31 GMT

I am trying to merge a few datasets I have. I get the following error:

ERROR: Variable year1 has been defined as both character and numeric.

I understand what it means and how it works, however, I am wondering if there is a simple line to convert all observations in the data to numeric (or character for that matter) at once.

Re: Merging error

SASKiwi — Fri, 23 Apr 2021 02:13:24 GMT

No there isn't. You use the INPUT function to convert from character to numeric or the PUT function for numeric to character. You can use arrays to convert a lot of variables at a time but that still requires a minimum of four statements - an ARRAY, a DO, an INPUT function with an assignment, and an END.

Re: Merging error

nmlynar13 — Fri, 23 Apr 2021 03:21:43 GMT

Thank you for the help, I'll try that out!

Re: Merging error

Amir — Fri, 23 Apr 2021 10:37:41 GMT

Hi @nmlynar13,

In addition to what has already been said, note that the variable itself has a type (character or numeric), the type of the variable cannot be changed, a new variable of the desired type will have to be created to hold the converted value, as in the example below. If desired, drop and rename data set options or statements can be used to have the same variable name on the output data set.

data have;
   set sashelp.class;

   /* create a character variable age2 to hold the value of numeric variable age */ 
   age2 = put(age,8.);
run;

Kind regards,

Amir.