Hello. Have dataset with colum of dates; column labeled "action_date" and has type "Date" and length 8 with format "MMDDYY10." Dates look like this when I print the dataset:  11/28/2016   When I run this code, I expect to get a number. I'm actually getting nothing; the entire column is populated with periods. In the log, I do have a bunch of identical notes: "Invalid argument to function INPUT at line 28 column 12."   data work.fy17_usa_p_test; set work.fy17_usa_p; new_date = input(action_date, mmddyy10.); run;   At the end of the day, I'm just trying to change the date format from 11/28/2016 to 2016-11-28.  I think I'll go with something like    data work.fy17_usa_p_test; set work.fy17_usa_p; new_date = input(action_date, mmddyy10.); format new_date yymmdd10.; drop action_date; rename new_date = action_date; run;   but before getting there I need to get the input(action_date, mmddyy10.) to work.   Thanks in advance.   P.S.: Here's a sample of the log:   NOTE: Invalid argument to function INPUT at line 28 column 12. WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed. assistance_award_unique_key=ASST_NON_17E5624332740002_7300 award_id_fain=17E5624332740002 award_id_uri= federal_action_obligation=20000 non_federal_funding_amount=5000 total_funding_amount=25000 face_value_of_loan=0 original_subsidy_cost=. total_subsidy_cost=0 total_loan_value=-25000 action_date=12/20/2016 action_date_fiscal_year=2017 period_perform_start=12/01/2016 awarding_agency_code=73 awarding_agency_name=SMALL BUSINESS ADMINISTRATION (SBA) awarding_sub_agency_code=7300 awarding_sub_agency_name=SMALL BUSINESS ADMINISTRATION awarding_office_code=733510 awarding_office_name=  funding_agency_code=73 funding_agency_name=SMALL BUSINESS ADMINISTRATION (7300) funding_sub_agency_code=7300 funding_sub_agency_name=SMALL BUSINESS ADMINISTRATION funding_office_code=733510 funding_office_name=  recipient_duns= recipient_name=KGS CONSTRUCTION SERVICES, INC. recipient_parent_name=  recipient_parent_duns=  recipient_country_code=USA recipient_country_name=UNITED STATES recipient_address_line_1=10363 PIPER LN recipient_address_line_2=  recipient_city_name=MANASSAS recipient_county_code=683 recipient_county_name=MANASSAS CITY recipient_state_code=VA recipient_state_name=VIRGINIA recipient_zip_code=20110 recipient_zip_last_4_code=2053 recipient_foreign_city_name=  recipient_foreign_province_name= recipient_foreign_postal_code=  cfda_number=59.016 cfda_title=SURETY BOND GUARANTEES assistance_type_code=11 assistance_type_description=  award_description=PARKING GARAGE REPAIRS business_funds_indicator_code=NON bus_funds_indicator_desc= business_types_code=23 business_types_description=  correction_delete_indicator_code=  correction_delete_indicator_desc= action_type_code=A action_type_description=  record_type_code=2 record_type_description=  recipient_city_code=  new_date=. _ERROR_=1 _N_=20 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to       missing values.       Each place is given by: (Number of times) at (Line):(Column).       151235 at 28:12   ... View more

Hello. I'm trying to run this basic sql and getting the following errors. Thoughts?   PROC SQL; create table compare_table as (SELECT FY, COUNT(*) AS MATCH_COUNT FROM WORK.FINALCOMPARE_504 WHERE test2 = 1 group by fy) a LEFT JOIN (SELECT FY, COUNT(*) AS TOTAL_OBS FROM WORK.FINALCOMPARE_504 group by fy) b on a.fy = b.fy; quit;   This is the log: 27         PROC SQL; 28         create table compare_table as 29         (SELECT FY, COUNT(*) AS MATCH_COUNT 30         FROM WORK.FINALCOMPARE_504 31         WHERE test2 = 1 32         group by fy) a                         _                         22                         202 ERROR 22-322: Syntax error, expecting one of the following: ;, EXCEPT, INTERSECT, ORDER, OUTER, UNION.  ERROR 202-322: The option or parameter is not recognized and will be ignored. 33         LEFT JOIN 34         (SELECT FY, COUNT(*) AS TOTAL_OBS                    __           __                    22           202 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND,               CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.  ERROR 202-322: The option or parameter is not recognized and will be ignored. 34       ! (SELECT FY, COUNT(*) AS TOTAL_OBS                                 __                                 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,               CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.  35         FROM WORK.FINALCOMPARE_504 2                                                          The SAS System                           08:28 Thursday, January 23, 2020 36         group by fy) b            _____            22            76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,               CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.  ERROR 76-322: Syntax error, statement will be ignored.   Any help greatly appreciated ... View more

I know how to do this fairly easy in Python pandas using lookup() but want to see how to do it in SAS. The problem is straight forward. I have this master list show the zone associated with any zip-code pair. For instance, if the origin zip code is 95826 and the destination zip code is 73864, then the corresponding zone is 6. This master list has 3000 rows and columns. I would appreciate keeping the code macro free. I just need the fundamental base SAS code or ideas and I can take it from there. Many people have suggested transposing then doing a join/merge. I don't think that will work here. Currently my office uses Excel VBA to do this then feeds the results back into SAS. Considering what we pay for SAS, I'm certain there's a way to do this in SAS. In python, the solution involves re-indexing the "Master List" data set so the zip codes along the vertical are the new row indices instead of the default 1,2,3,4,.... Thanks in advance.   For our discussion, let's say I got the data into SAS and it looks like the following Master List of zones:   1       FILL      73864    37463    37465    72958     20276 2    95826              6            1            5            8             2 3    98574              2            9            1            9             1 4    23847              1            3            8            4             7             5    95867              3            2            5            8             1 6    39487              .             .             .             .              . 7    39483              .             .             .             .              .     Desired Output:   Package_Weight    Package_Height    Package_Length    Entry_zip    Destination_zip    zone                           2                          10                         32          95867                   20276          1                           6                            3                          12         23847                   37465          8 ... View more