I'm attempting to do a join on two datasets on an authorization number in query builder. One of the datasets was imported from a spreadsheet. Here is a picture of the proc contents on each: Dataset 1: Dataset 2: As you can see, the AUTHORIZATIONNUMBER variable in both datasets has the same type, length, format and informat. If I test on dummy datasets like this it works: data test;
infile datalines;
input AUTHID 16.;
format AUTHID 16.;
datalines;
1111111111111111
2222222222222222
3333333333333333
4444444444444444
5555555555555555
;;
run;
data test2;
infile datalines;
input AUTHID 16.;
format AUTHID 16.;
datalines;
6666666666666666
2222222222222222
8888888888888888
8888888888888888
5555555555555555
;;
run; If you inner join here it will come back with results, but for some reason it is not working with my two real datasets.
... View more
