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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.