Hi,
i am require to create a script to check if the file is empty then i need to move the file.
how can i do about it?
Thanks
If your file is a SAS-dataset, try:
%Macro Del_F(File=,Lib=);
Data _NULL_;
MyFile=Open("&File.");
EmptyFlag=Attrn(MyFile,"ANY");
Call SymputX("Empty",EmptyFlag);
Run;
%If &Empty^=1 %Then %Do;
Proc Datasets Lib=&Lib. NoList MemType=Data;
Delete &File.;
Run;
%End;
%Mend;
%Del_F(File=<SASFile>,Lib=<Work>)
%let dsid=%sysfunc(open(sashelp.class));
%let nobs=%sysfunc(attrn(&dsid,nlobs));
%let dsid=%sysfunc(close(&dsid));
%put &nobs ;
Xia Keshan
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.