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?
PROC SQL;
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.;
;
RUN
Use proc contents to check variable types. if ac.invoice_number is char then try this.
ON input(ac.invoice_number,8.) = ATSo.odr_number ;
Use proc contents to check variable types. if ac.invoice_number is char then try this.
ON input(ac.invoice_number,8.) = ATSo.odr_number ;
proc sql;
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.);
quit;
Example:
data have1;
input id $ var $;
cards;
1 a
2 b
3 c
;
run;
data have2;
input id var $;
cards;
1 a
2 b
3 c
;
run;
proc sql;
create table want as
select a.* from have1 a left join have2 b on a.id=put(b.id,char1.);
quit;
proc contents data=want;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: