GEO Coding_Error : Variable as both character and numeric.

ShiJan1 — Thu, 06 Jun 2019 20:43:47 GMT

I am pretty new to SAS and trying street geocoding.

Downloaded external USM, USS and USP datasets. Trying to Stack 5 USS and 4 USP datasets together. USP datasets stacked together well but I am getting the following error when trying to stack 5USS datasets in SAS.

The files are huge, please help how can I remove the following errors.

ERROR: Variable F4 has been defined as both character and numeric.
ERROR: Variable F5 has been defined as both character and numeric.
ERROR: Variable F7 has been defined as both character and numeric.

Code worked fine: data stack_usp;
set work.usp1 work.usp2 work.usp3 work.usp4 ;
run;

Code not working:

data stack_uss;
set work.uss1 work.uss2;
run;

Re: GEO Coding_Error : Variable as both character and numeric.

Reeza — Thu, 06 Jun 2019 20:47:24 GMT

What format were your original data sets and how did you import them?

@ShiJan1 wrote:

I am pretty new to SAS and trying street geocoding.

Downloaded external USM, USS and USP datasets. Trying to Stack 5 USS and 4 USP datasets together. USP datasets stacked together well but I am getting the following error when trying to stack 5USS datasets in SAS.

The files are huge, please help how can I remove the following errors.

ERROR: Variable F4 has been defined as both character and numeric.
ERROR: Variable F5 has been defined as both character and numeric.
ERROR: Variable F7 has been defined as both character and numeric.

Code worked fine: data stack_usp;
set work.usp1 work.usp2 work.usp3 work.usp4 ;
run;

Code not working:

data stack_uss;
set work.uss1 work.uss2;
run;

topic Re: GEO Coding_Error : Variable as both character and numeric. in New SAS User

GEO Coding_Error : Variable as both character and numeric.

Re: GEO Coding_Error : Variable as both character and numeric.