Hi, I am working on a project and I have to drop any variable where the variable name begins with ‘Street’ in this merge data set. This is my syntax: libname bhadlibs 'C:\Users\PhotonUser\My Files\Temporary Files'; data bhadlibs.employee_payroll; set bhadlibs.employeepayroll; proc sort;by employee_id; /* Experienced difficulty on renaming multiple naming conventions and dropping "street. We should review this in class. data bhadlibs.employee_donations; set bhadlibs.employee_donations; proc sort;by employee_id; data bhadlibs.employee_addresses (rename=(street_id=street)); set bhadlibs.employee_addresses; proc sort;by employee_id; data bhadlibs.employee_addresses (rename=(street_number=street)); set bhadlibs.employee_addresses; proc sort;by employee_id; run; data bhadlibs.employee_addresses (rename=(street_name=street2)); set bhadlibs.employee_addresses; proc sort;by employee_id; run;*/ data bhadlibs.employee_addresses; set bhadlibs.employee_addresses2 (drop=street); footnote1 'confidential'; run; data mergepart; merge bhadlibs.employee_payroll bhadlibs.employee_donations bhadlibs.employee_addresses; by employee_id; proc print; run;
... View more