ERROR: Variable TEST__CODE has been defined as both character and numeric.
ERROR: Variable PROCEDURES has been defined as both character and numeric.
%macro overall;
data all_invoice;
set
%do i = 1 %to 86; invoice&i
%end;
;
run;
%mend;
%overall;
I attempted to use this macro to bring 86 indvidual files together in 1 report. I get the above named message. Apparently some of the data in the fields are both character and numeric. Do I use something like this to correct it?
TEST_CODE1=put(TEST__CODE);
PROCEDURE=put(PROCEDURES);
Where in the macro would this statememt go (assuming its rigth). The objective is to make both the TEST_CODE and PROCEDURES into character fields
ERROR: Variable PROCEDURES has been defined as both character and numeric.
%macro overall;
data all_invoice;
set
%do i = 1 %to 86; invoice&i
%end;
;
run;
%mend;
%overall;
I attempted to use this macro to bring 86 indvidual files together in 1 report. I get the above named message. Apparently some of the data in the fields are both character and numeric. Do I use something like this to correct it?
TEST_CODE1=put(TEST__CODE);
PROCEDURE=put(PROCEDURES);
Where in the macro would this statememt go (assuming its rigth). The objective is to make both the TEST_CODE and PROCEDURES into character fields