I'm trying to create a column (postal_cd) and then join another table from that column, but I received this error: ERROR: Column postal_cd could not be found in the table/view identified with the correlation name A. proc sql; create table TEST as (select b.state_nm as state_c ,a.* ,a.full_zip as ZIP9 ,substr(full_zip,1,5) as postal_cd from sid.plus4_zip_summary_us a inner join temp b on b.zip_char_cd=a.postal_cd ); quit;
... View more