topic Changing a variable from NUM to CHAR in PROC SQL in SAS Enterprise Guide

Changing a variable from NUM to CHAR in PROC SQL

zhou_larry — Wed, 10 Sep 2014 18:11:21 GMT

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

stat_sas — Wed, 10 Sep 2014 18:22:30 GMT

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 ;

Hima — Wed, 10 Sep 2014 18:23:39 GMT

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;