Is there a way to directly hit a file thru a proc sql or do I have to first create a data set.
Example
DATA tbs_tmp;
set '/home/xxx/xxx/tbs'
RUN;
then PROC SQL from tbs_temp
or.. is there a way to directly hit the file?
PROC SQL;
CREATE TABLE tbs AS
SELECT * FROM '/home/xxx/xxx/tbs' WHERE etc ORDER BY etc
?? Thanks!
... View more