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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.