Hi @Badjuju  @As action_date is already a SAS date, there is no need to use the input function and create a new variable to then delete the first one. I think you can simply apply the new format to action_date: data work.fy17_usa_p_test; set work.fy17_usa_p; format action_date yymmdd10.; run; ... View more

Hi @Badjuju  You just need to add a SELECT clause before joining the two queries in the FROM clause proc sql; create table compare_table as select a.FY, a.MATCH_COUNT, b.TOTAL_OBS from (select FY, count(FY) as MATCH_COUNT from WORK.FINALCOMPARE_504 WHERE test2=1 group by FY) a left join (select FY, count(FY) as TOTAL_OBS from WORK.FINALCOMPARE_504 group by FY) b on a.fy=b.fy; quit; ... View more

Note that postal codes are NOT numbers. For example the code 04032 for Freeport Maine has a leading zero.   How to start depends on what format your original list is in.  If it is a CSV or other type of text file then just read it in originally as from/to pairs.  For example if the file looks like this: FILL 73864 37463 37465 72958 20276 95826 6 1 5 8 2 98574 2 9 1 9 1 23847 1 3 8 4 7 95867 3 2 5 8 1 you could read the first line and remember the codes for the columns. data zones ; infile zone truncover ; array cols (3000) $7 _temporary_; length from to $7 zone 8; if _n_=1 then do; input to @; do col=1 by 1 until(to=' ') ; input to @ ; cols(col)=to; end; ncols=col-1; retain ncols; input ; end; input from @; do col=1 to ncols ; to=cols(col); input zone @; output; end; keep from to zone; run; Now you can either use the data in a hash and join or merge or create a format or informat. You could easily transform the FROM/TO/ZONE variables into START/LABEL values to use with PROC FORMAT's CNTLIN= option. data infmt; set zones ; retain fmtname 'ZONE' type 'I' ; length start $14 ; start = cat(from,to); rename zone=label; run; proc format cntlin=infmt; run; Now if we create your example data. data have; input Package_Weight Package_Height Package_Length Entry_zip :$7. Destination_zip :$7. zone_expect ; cards; 2 10 32 95867 20276 1 6 3 12 23847 37465 8 ; It is easy enough to use the INFORMAT to convert the from/to pair into a zone. data want ; set have ; zone = input(cat(entry_zip,destination_zip),zone.); run; Package_ Package_ Package_ Entry_ Destination_ zone_ Obs Weight Height Length zip zip expect zone 1 2 10 32 95867 20276 1 1 2 6 3 12 23847 37465 8 8   ... View more