Thanks for reply. this is a part of the code : proc sql; connect to pcfiles(path="&path\database\all.accdb" dbpassword=sastest); select DEALID, Duration, Score, Decision from connection to pcfiles (select top 10, DEALID, Duration, Score, Decision from clients where score is not null order by score desc); disconnect from pcfiles; quit;
... View more
