GEO Coding_Error : Variable as both character and numeric.

[ShiJan1]

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;

[Reeza]

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;

---