Hi all, This is a beginner's question I am trying to merge 2 SAS datasets into one by ID with a PROC SQL, but it seems that my file reference is wrong. The log says that my file doesn't exist. Would anybody know what is wrong with this code? libname ABC '/global/home/XXX';
filename K1 '/global/home/XXX.sas7bdat';
filename K2 '/global/home/XXYXX.sas7bdat';
proc sql;
select k.ID as A_BBB,
r.ID as B_BBB,
AGE , GENDER, HEIGHT, CITY , PHONE NUMBE
FROM ABC.K1 as K,
ABC.K2 as R
WHERE K.ID eq r.ID;
QUIT; Thank you
... View more