SAS Question
I am trying to do a PROC SQL from a file... can this be done?
PROC SQL;
CREATE TABLE TBS AS
SELECT * FROM '/home/xxxxx/xxxxx/tbsanis' WHERE X=1 AND Y=2;
QUIT;
instead of first having to do a data step
DATA tbs_tmp;
SET '/home/xxxxx/xxxxx/tbsanis'
RUN;
then do FROM tbs_tmp in the sql step?
thanks!

