Is this bit of SQL supposed to be executed remotely?
proc sql ;
CREATE TABLE &client_id_CUSTOMER_HEADER_&todaysDate as
select
&client_id varchar(16) default null,
unique_identifier bigint default null,
der_hash_code bigint default null,
der_hash_key varchar(50) default null,
elements_address_dps varchar(2) default null,
elements_address_status varchar(1) default null,
elements_key_household bigint default null,
elements_key_urn_household bigint default null,
elements_data_date datetime default null,
unique_rec integer default 0
;
quit;
If not you will get errors because VARCHAR, BIGINT, Default and Null are not SAS Proc SQL keywords.
You have to start with working non-macro code and then add the macro elements.
... View more
