I have a dataset that I put through a PROC TRANSPOSE. Now I want to expand data and make a report, by merging in extra fields, using the new output from the PROC TRANSPOSE as the base dataset, and secondary datasets to pull extra fields, matching on account ID field. I see all the matching account IDs in the secondary tables, but when merge completes, the fields from the secondary tables show "." for missing numeric and " " for missing character values. None of the fields populated in the merged dataset, from the second, third, fourth, fifth or sixth table. Here is my code. Any thoughts? proc sort data=bbwhse.test_appeals2 ; /** this is the main dataset, which was output file from PROC TRANSPOSE **/ by application_id ; run; proc sort data=bbwhse.turn_down_david_fields ; by application_id ; run; proc sort data=bbwhse.turn_down_acaps_lite_fields ; by application_id ; run; proc sort data=bbwhse.turn_down_busmast_fields ; by application_id ; run; proc sort data=bbwhse.turn_down_prinmast_fields ; by application_id ; run; proc sort data=bbwhse.tdhist_new_judgmental_declines out=bbwhse.td_reasons nodup; by application_id seq_file_key ; run; proc sort data=bbwhse.td_reasons (drop=seq_file_key state area hist_rec) nodupkey; by application_id ; run; data bbwhse.appeals_processing_code_report ; merge bbwhse.test_appeals2 (in=a) bbwhse.turn_down_david_fields (in=b) bbwhse.turn_down_acaps_lite_fields (in=c) bbwhse.turn_down_busmast_fields (in=d) bbwhse.turn_down_prinmast_fields (in=e) bbwhse.td_reasons (in=f) ; by application_id ; if a and b and c and d and e and f ; run;
... View more