Listing all Files Available in a Given Directory (Windows)
%let xxroot = C:\...;
options noxwait;
data _null_;
call system("dir &xxroot.\data\*.* /a-d /b > &xxroot.\reporting\listfiles.txt");
run;
Unknown Statement
The following statement is usually used to stop the system to send the output in the RESULTS tab (in SAS Studio for example). The HTML5(Web) destination is not recognized by Altair SLC.
ods html5(web) exclude all;
ERROR: Not a valid statement in this context: ODS destination HTML5(web) is not open
Dataset Options Cannot Be Always be Used in proc sql
In SAS Studio, dataset options can be used in a
proc sql statement. This is not always the case with Altair SLC. Here is an example.
proc sql;
select a.*, b.height
from class (keep=name age sex where=(age=12)) a
left join
class (keep=name age height where=(age=12)) b
on a.name=b.name;
quit;
