data _null_; 98 format report_date MMDDYY10.; 99 report_date = intnx("MONTH", today(), - 0, "BEG"); /*this is the first day of the month which will generate data for the 99 ! last day of the previous month*/ 100 call symput('report_date', input(put(report_date, YYMMDD8.), YYMMDD10.)); 101 call symput('report_date_num', input(put(report_date, YYMMDDN8.), 8.)); 102 call symput('report_date_txt', put((report_date-1), MMYYS7.)); /*This is the month and year that we will be reporting 102 ! on.1 day less than the first of the month*/ 103 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 100:29 101:33 /*BELOW FROM THE COMPILER??*/ %macro upload_file; 680 data _null_; 681 set org_char11; 682 file "\\temp\org_char&report_date_num..txt"; 683 684 if UNKNOWN = . then 685 UNKNOWN = 0; 686 687 put """OC"""','"""&report_date_txt."""','"""OperationalCapacity"""',' operational_capacity ','; 688 put """OC"""','"""&report_date_txt."""','"""PrisonerHousedBydoC"""',' prisoners_housed_by_doc ','; 689 put """OC"""','"""&report_date_txt."""','"""PrisonersOutsourced"""','prisoners_outsourced ','; ___ 49 690 put """OC"""','"""&report_date_txt."""','"""MaleSecurityStaff"""','male_security_staff ','; ___ 49 691 put """OC"""','"""&report_date_txt."""','"""FemaleSecurityStaff"""','female_security_staff ','; ___ 49 692 put """OC"""','"""&report_date_txt."""','"""InstitutionalStaff"""','agency_facility_staff ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 693 put """OC"""','"""&report_date_txt."""','"""Jails"""',''0' ','; 694 put """OC"""','"""&report_date_txt."""','"""CommunityBasedCorrections"""',''0' ','; 695 put """OC"""','"""&report_date_txt."""','"""Prisons"""',''1' ','; 696 put """OC"""','"""&report_date_txt."""','"""CivilCommitments"""',''0' ','; 697 put """OC"""','"""&report_date_txt."""','"""Probation"""',' '0' ','; 698 put """OC"""','"""&report_date_txt."""','"""Parole"""',' '0' ','; 699 put """OC"""','"""&report_date_txt."""','"""Juvenile"""',' '0' ','; 700 put """OC"""','"""&report_date_txt."""','"""ParoleBoard"""',' '0' ','; 701 put """OC"""','"""&report_date_txt."""','"""AvgLengthOfSentence"""',' avg_sent_length ','; 702 put """OC"""','"""&report_date_txt."""','"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; ___ 49 703 put """OC"""','"""&report_date_txt."""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; ___ 49 704 put """OC"""','"""&report_date_txt."""','"""LessThan1Year"""','Less_one_year ','; ___ 49 705 put """OC"""','"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; ___ 49 15 The SAS System 08:40 Monday, January 4, 2021 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 706 put """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; 707 put """OC"""','"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 708 put """OC"""','"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; 709 put """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; 710 put """OC"""','"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; ___ 49 711 put """OC"""','"""&report_date_txt."""','"""LifeWithParole"""','life ','; ___ 49 712 put """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 713 put """OC"""','"""&report_date_txt."""','"""Death"""','death ','; 714 put """OC"""','"""&report_date_txt."""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; ___ 49 715 put """OC"""','"""&report_date_txt."""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; ___ 49 716 put """OC"""','"""&report_date_txt."""','"""PropertyCrime"""','PROPERTY ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 717 put """OC"""','"""&report_date_txt."""','"""DrugCrime"""','DRUG ','; 718 put """OC"""','"""&report_date_txt."""','"""PretrialNonConvicted"""','pre_trial ','; ___ 49 719 put """OC"""','"""&report_date_txt."""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; ___ 49 720 put """OC"""','"""&report_date_txt."""','"""OtherCrime"""','OTHER ','; ___ 49 721 put """OC"""','"""&report_date_txt."""','"""AverageAge"""','Average_Age ','; ___ 49 722 put """OC"""','"""&report_date_txt."""','"""Male"""','Male ','; ___ 49 723 put """OC"""','"""&report_date_txt.""" ',' """Female"""','Female ','; ___ 49 724 put """OC"""','"""&report_date_txt."""','"""White"""','WHITE ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 725 put """OC"""','"""&report_date_txt."""','"""BlackOrAfricanAmerican"""','BLACK ','; 16 The SAS System 08:40 Monday, January 4, 2021 726 put """OC"""','"""&report_date_txt."""','"""NativeHawaiianOrPacificIslander"""',''0' ','; 727 put """OC"""','"""&report_date_txt."""','"""NativeAmericanAlaskanNative"""',' Native_American_Alaskan_Native ','; 728 put """OC"""','"""&report_date_txt."""','"""HispanicOrLatino"""','HISPANIC ','; ___ 49 729 put """OC"""','"""&report_date_txt."""','"""Asian"""','ASIAN ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 730 put """OC""" ',' """&report_date_txt.""" ','"""Other"""',''0' ','; 731 put """OC""" ',' """&report_date_txt.""" ','"""UnknownMissing"""','UNKNOWN ','; ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 732 put """OC"""','"""&report_date_txt."""','"""NonCitizens"""','non_citizens ','; 733 put """OC"""','"""&report_date_txt."""','"""NewConviction"""','new_conviction ','; 734 put """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNewSentence"""','tech_New_Sentence ','; 735 put """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNoNewSentence"""','tech_No_New_Sentence ','; 736 put """OC"""','"""&report_date_txt."""','"""PretrialAdmission"""',''0' ','; 737 run; 738 %mend; 739 %upload_file; /*BELOW FROM THE ACTUAL RUN??*/ NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""OperationalCapacity"""',' operational_capacity ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PrisonerHousedBydoC"""',' prisoners_housed_by_doc ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PrisonersOutsourced"""' ___ 49 NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'prisoners_outsourced ','; put """OC"""','"""&report_date_txt."""','"""MaleSecurityStaff"""','male_security_staff ','; ___ ___ 49 49 32 The SAS System 08:40 Monday, January 4, 2021 767 ! put """OC"""','"""&report_date_txt."""','"""FemaleSecurityStaff"""','female_security_staff ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""InstitutionalStaff"""','agency_facility_staff ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""Jails"""',''0' ','; put 767 ! """OC"""','"""&report_date_txt."""','"""CommunityBasedCorrections"""',''0' ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 avg_sent_length ','; put """OC"""','"""&report_date_txt."""','"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; ___ ___ 49 49 767 ! put """OC"""','"""&report_date_txt."""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""LessThan1Year"""','Less_one_year ','; put ___ ___ 49 49 767 ! """OC"""','"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; put 767 ! """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; put 767 ! """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; put ___ ___ ___ 49 49 49 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithParole"""','life ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""Death"""','death ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; put ___ ___ 49 49 767 ! """OC"""','"""&report_date_txt."""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""PropertyCrime"""','PROPERTY ','; put ___ ___ 49 49 767 ! """OC"""','"""&report_date_txt."""','"""DrugCrime"""','DRUG ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PretrialNonConvicted"""','pre_trial ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; put ___ ___ 33 The SAS System 08:40 Monday, January 4, 2021 ___ 49 49 49 767 ! """OC"""','"""&report_date_txt."""','"""OtherCrime"""','OTHER ','; put 767 ! """OC"""','"""&report_date_txt."""','"""AverageAge"""','Average_Age ','; put """OC"""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 ,'"""&report_date_txt."""','"""Male"""','Male ','; put """OC"""','"""&report_date_txt.""" ',' """Female"""','Female ',' ___ ___ ___ 49 49 49 767 ! ; put """OC"""','"""&report_date_txt."""','"""White"""','WHITE ','; put """OC"""','"""&report_date_txt."""' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 put """OC"""','"""&report_date_txt."""','"""HispanicOrLatino"""','HISPANIC ','; put ___ ___ 49 49 767 ! """OC"""','"""&report_date_txt."""','"""Asian"""','ASIAN ','; put """OC""" ',' """&report_date_txt.""" 767 ! ','"""Other"""',''0' ','; put """OC""" ',' NOTE: Line generated by the invoked macro "RUN_REPORT". 767 """&report_date_txt.""" ','"""UnknownMissing"""','UNKNOWN ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""NonCitizens"""','non_citizens ','; put 767 ! """OC"""','"""&report_date_txt."""','"""NewConviction"""','new_conviction ','; put """OC"""' MPRINT(UPLOAD_FILE): data _null_; MPRINT(UPLOAD_FILE): set org_char11; MPRINT(UPLOAD_FILE): file "\\wpdocsasl01\sasoutput\pbms\pbms_org_char 20210101.txt"; MPRINT(UPLOAD_FILE): if UNKNOWN = . then UNKNOWN = 0; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""OperationalCapacity"""',' operational_capacity ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PrisonerHousedBydoC"""',' prisoners_housed_by_doc ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""PrisonerHousedBydoC"""',' prisoners_housed_by_doc ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PrisonersOutsourced"""','prisoners_outsourced ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PrisonersOutsourced"""','prisoners_outsourced ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""MaleSecurityStaff"""','male_security_staff ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""FemaleSecurityStaff"""','female_security_staff ','; put 767 ! """OC"""','"""&report_date_txt."""','"""InstitutionalStaff"""','agency_facility_staff ','; put MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""MaleSecurityStaff"""','male_security_staff ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""MaleSecurityStaff"""','male_security_staff ','; put 767 ! """OC"""','"""&report_date_txt."""','"""FemaleSecurityStaff"""','female_security_staff ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""InstitutionalStaff"""','agency_facility_staff ','; put NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 34 The SAS System 08:40 Monday, January 4, 2021 MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""FemaleSecurityStaff"""','female_security_staff ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""MaleSecurityStaff"""','male_security_staff ','; put 767 ! """OC"""','"""&report_date_txt."""','"""FemaleSecurityStaff"""','female_security_staff ','; put 767 ! """OC"""','"""&report_date_txt."""','"""InstitutionalStaff"""','agency_facility_staff ','; put ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""InstitutionalStaff"""','agency_facility_staff ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Jails"""',''0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""CommunityBasedCorrections"""',''0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Prisons"""',''1' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""CivilCommitments"""',''0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Probation"""',' '0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Parole"""',' '0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Juvenile"""',' '0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""ParoleBoard"""',' '0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""AvgLengthOfSentence"""',' avg_sent_length ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LessThan1Year"""','Less_one_year ','; put """OC"""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; put 767 ! """OC"""','"""&report_date_txt."""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""LessThan1Year"""','Less_one_year ','; put """OC"""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""AvgLengthOfStaySentencedOffenders"""','avg_los ','; put 767 ! """OC"""','"""&report_date_txt."""','"""AvgLengthOfStayPretrial"""','avg_los_pretrial ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LessThan1Year"""','Less_one_year ','; put """OC"""' ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""LessThan1Year"""','Less_one_year ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; put 767 ! """OC"""','"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; put """OC"""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""1To3Years"""','one_to_three ','; NOTE 137-205: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; put 767 ! """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; put 35 The SAS System 08:40 Monday, January 4, 2021 ____ 22 767 ! """OC"""','"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; put """OC"""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; put 767 ! """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; put ____ 200 767 ! """OC"""','"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; put """OC"""' ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""3To5Years"""','three_to_five ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""1To3Years"""','one_to_three ','; put 767 ! """OC"""','"""&report_date_txt."""','"""3To5Years"""','three_to_five ','; put 767 ! """OC"""','"""&report_date_txt."""','"""5To10Years"""','five_to_ten ','; put """OC"""' ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""5To10Years"""','five_to_ten ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; put ____ 22 200 767 ! """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; put 767 ! """OC"""','"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; put """OC"""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""10To20Years"""','ten_to_twenty ','; NOTE 137-205: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; put 767 ! """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; put ____ 22 767 ! """OC"""','"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; put """OC"""' ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; put 767 ! """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; put ____ 200 767 ! """OC"""','"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; put """OC"""' ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""20To40Years"""','twenty_to_forty ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""10To20Years"""','ten_to_twenty ','; put 36 The SAS System 08:40 Monday, January 4, 2021 767 ! """OC"""','"""&report_date_txt."""','"""20To40Years"""','twenty_to_forty ','; put 767 ! """OC"""','"""&report_date_txt."""','"""MoreThan40Years"""','over_forty ','; put """OC"""' ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""MoreThan40Years"""','over_forty ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""LifeWithParole"""','life ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; put 767 ! """OC"""','"""&report_date_txt."""','"""Death"""','death ','; put """OC"""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""LifeWithParole"""','life ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""LifeWithParole"""','life ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""Death"""','death ','; put """OC"""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""LifeWithoutParole"""','life_no_parole ','; NOTE 137-205: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""LifeWithParole"""','life ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; put 767 ! """OC"""','"""&report_date_txt."""','"""Death"""','death ','; put """OC"""' ____ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""LifeWithParole"""','life ','; put 767 ! """OC"""','"""&report_date_txt."""','"""LifeWithoutParole"""','life_no_parole ','; put 767 ! """OC"""','"""&report_date_txt."""','"""Death"""','death ','; put """OC"""' ____ 200 ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Death"""','death ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PropertyCrime"""','PROPERTY ','; put MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; put 767 ! """OC"""','"""&report_date_txt."""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""PropertyCrime"""','PROPERTY ','; put NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 37 The SAS System 08:40 Monday, January 4, 2021 MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""PartIViolentCrime"""','PART_I_VIOLENT ','; put 767 ! """OC"""','"""&report_date_txt."""','"""OtherViolentCrime"""','OTHER_VIOLENT ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PropertyCrime"""','PROPERTY ','; put ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PropertyCrime"""','PROPERTY ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""DrugCrime"""','DRUG ','; put ____ 22 200 767 ! """OC"""','"""&report_date_txt."""','"""PretrialNonConvicted"""','pre_trial ','; put 767 ! """OC"""','"""&report_date_txt."""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; put MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""DrugCrime"""','DRUG ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""DrugCrime"""','DRUG ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PretrialNonConvicted"""','pre_trial ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; put ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PretrialNonConvicted"""','pre_trial ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""DrugCrime"""','DRUG ','; put 767 ! """OC"""','"""&report_date_txt."""','"""PretrialNonConvicted"""','pre_trial ','; put 767 ! """OC"""','"""&report_date_txt."""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; put ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""OtherPublicOrderCrime"""','OTHER_PUBLIC_ORDER ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""OtherCrime"""','OTHER ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""AverageAge"""','Average_Age ','; put 767 ! """OC"""','"""&report_date_txt."""','"""Male"""','Male ','; put """OC"""','"""&report_date_txt.""" MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""OtherCrime"""','OTHER ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""OtherCrime"""','OTHER ','; put 767 ! """OC"""','"""&report_date_txt."""','"""AverageAge"""','Average_Age ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""Male"""','Male ','; put """OC"""','"""&report_date_txt.""" 38 The SAS System 08:40 Monday, January 4, 2021 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""AverageAge"""','Average_Age ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""OtherCrime"""','OTHER ','; put 767 ! """OC"""','"""&report_date_txt."""','"""AverageAge"""','Average_Age ','; put 767 ! """OC"""','"""&report_date_txt."""','"""Male"""','Male ','; put """OC"""','"""&report_date_txt.""" ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Male"""','Male ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ',' """Female"""','Female ','; put """OC"""','"""&report_date_txt."""','"""White"""','WHITE ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""BlackOrAfricanAmerican"""','BLACK ','; put """OC"""','"""&report_date_txt."""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020""" ',' """Female"""','Female ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ',' """Female"""','Female ','; put """OC"""','"""&report_date_txt."""','"""White"""','WHITE ','; put ___ 49 767 ! """OC"""','"""&report_date_txt."""','"""BlackOrAfricanAmerican"""','BLACK ','; put """OC"""','"""&report_date_txt."""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""White"""','WHITE ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ',' """Female"""','Female ','; put """OC"""','"""&report_date_txt."""','"""White"""','WHITE ','; put 767 ! """OC"""','"""&report_date_txt."""','"""BlackOrAfricanAmerican"""','BLACK ','; put """OC"""','"""&report_date_txt."""' ____ 216 ERROR 216-185: The use of a BIT string constant is not allowed in this context. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""BlackOrAfricanAmerican"""','BLACK ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""NativeHawaiianOrPacificIslander"""',''0' ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""NativeAmericanAlaskanNative"""',' Native_American_Alaskan_Native ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""NativeHawaiianOrPacificIslander"""',''0' ','; put 767 ! """OC"""','"""&report_date_txt."""','"""NativeAmericanAlaskanNative"""',' Native_American_Alaskan_Native ','; put 767 ! """OC"""','"""&report_date_txt."""','"""HispanicOrLatino"""','HISPANIC ','; put ___ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""HispanicOrLatino"""','HISPANIC ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 """OC"""','"""&report_date_txt."""','"""Asian"""','ASIAN ','; put """OC""" ',' """&report_date_txt.""" ___ 49 767 ! ','"""Other"""',''0' ','; put """OC""" ',' """&report_date_txt.""" ','"""UnknownMissing"""','UNKNOWN ','; put 767 ! """OC"""' MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""Asian"""','ASIAN ','; MPRINT(UPLOAD_FILE): put """OC""" ',' """12/2020""" ','"""Other"""',''0' ','; NOTE: Line generated by the invoked macro "UPLOAD_FILE". 39 The SAS System 08:40 Monday, January 4, 2021 767 """OC"""','"""&report_date_txt."""','"""Asian"""','ASIAN ','; put """OC""" ',' """&report_date_txt.""" 767 ! ','"""Other"""',''0' ','; put """OC""" ',' """&report_date_txt.""" ','"""UnknownMissing"""','UNKNOWN ','; put ___ 49 767 ! """OC"""' NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. MPRINT(UPLOAD_FILE): put """OC""" ',' """12/2020""" ','"""UnknownMissing"""','UNKNOWN ','; ERROR: The name , is not a valid SAS name. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""NonCitizens"""','non_citizens ','; ERROR: The name , is not a valid SAS name. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""NewConviction"""','new_conviction ','; NOTE 137-205: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""NonCitizens"""','non_citizens ','; put 767 ! """OC"""','"""&report_date_txt."""','"""NewConviction"""','new_conviction ','; put 767 ! """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNewSentence"""','tech_New_Sentence ____ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ,'"""&report_date_txt."""','"""NonCitizens"""','non_citizens ','; put 767 ! """OC"""','"""&report_date_txt."""','"""NewConviction"""','new_conviction ','; put 767 ! """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNewSentence"""','tech_New_Sentence ____ 200 ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""TechnicalViolationWithNewSentence"""','tech_New_Sentence ','; NOTE 137-205: Line generated by the invoked macro "UPLOAD_FILE". 767 ','; put """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNoNewSentence"""','tech_No_New_Sentence ','; ____ 22 767 ! put """OC"""','"""&report_date_txt."""','"""PretrialAdmission"""',''0' ','; run; ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, arrayname, #, (, +, /, //, ;, @, @@, OVERPRINT, _ALL_, _BLANKPAGE_, _ODS_, _PAGE_. NOTE: Line generated by the invoked macro "UPLOAD_FILE". 767 ','; put """OC"""','"""&report_date_txt."""','"""TechnicalViolationWithNoNewSentence"""','tech_No_New_Sentence ','; ____ 200 767 ! put """OC"""','"""&report_date_txt."""','"""PretrialAdmission"""',''0' ','; run; ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""TechnicalViolationWithNoNewSentence"""','tech_No_New_Sentence ','; MPRINT(UPLOAD_FILE): put """OC"""','"""12/2020"""','"""PretrialAdmission"""',''0' ','; MPRINT(UPLOAD_FILE): run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(RUN_REPORT): ; MPRINT(RUN_REPORT): ; 40 The SAS System 08:40 Monday, January 4, 2021 768 /*---- End of User Written Code ----*/ 769 770 %let etls_endTime = %sysfunc(datetime(),datetime.); 771