09-10-2014 02:11 PM
Hey there, i'm trying to Left Join a variable but the column I'm matching it to are different data types. WHat is the best way to format it?
I tried to format ATSo.odr_number using $13. but i keep getting errors. Should I use a Proc Format before this?
CREATE TABLE work.add_class AS
SELECT ac.date_shipped, ac.order_id, ac.brand_code, ac.customer_id,
ATSo.classification, ATSo.brand_code AS ATSbrand
FROM work.add_cust AS ac
LEFT JOIN work.TEMP_ORDERS AS ATSo
ON ac.invoice_number = ATSo.odr_number $13.;
09-10-2014 02:23 PM
create table work.add_class as
select ac.date_shipped, ac.order_id, ac.brand_code, ac.customer_id,atso.classification, atso.brand_code as atsbrand
from work.add_cust as ac left join work.temp_orders as atso
on ac.invoice_number = put(atso.odr_number,char13.);
input id $ var $;
input id var $;
create table want as
select a.* from have1 a left join have2 b on a.id=put(b.id,char1.);
proc contents data=want;
Need further help from the community? Please ask a new question.