topic Re: getting the filesize of created DBF file in SAS Procedures

getting the filesize of created DBF file

DmitryErshov — Thu, 11 Jun 2015 16:37:16 GMT

I have SAS stored process that ceates DBF file from SAS data set rr_udf_value and finds its size (F_SIZE):

filename dbfout "/SASInside/DBF/myfile";  


proc export data=rr_udf_value outfile=dbfout dbms=dbf replace; 
run;  


%let f_nm=/SASInside/DBF/myfile.DBF; 
%let rc=%sysfunc(filename(onefile, &f_nm.));
%let fid=%sysfunc(fopen(&onefile)); 
%let F_SIZE=%sysfunc(finfo(&fid,File Size (bytes))); 
%put &F_SIZE;

The problem is that the variable F_SIZE is empty in STP log. But if after execution of STP I run commands

%let f_nm=/SASInside/DBF/myfile.DBF;  


%let rc=%sysfunc(filename(onefile, &f_nm.));
%let fid=%sysfunc(fopen(&onefile));
%let F_SIZE=%sysfunc(finfo(&fid,File Size (bytes))); 
%put FSIZE=&F_SIZE;

manually, everithing is OK: F_SIZE=17342.

Why F_SIZE is not initialized while running STP, and how could I fix it?

Thanks in advance!

Re: getting the filesize of created DBF file

Ksharp — Fri, 12 Jun 2015 15:06:18 GMT

Not sure. Could you get file size by DICTIONARY ?

Code: Program


filename x '/folders/myfolders/x.xlsx';
proc sql;
select * from dictionary.EXTFILES where Fileref='X';
quit;

Xia Keshan

Re: getting the filesize of created DBF file

DmitryErshov — Tue, 16 Jun 2015 09:50:25 GMT

Thank you very much, Xia! Your approach works good!

P.S. I found that my approach also can work if I switch STP option "Server type" to "Workspace server only". But I will use your approach because it doesn't require switching server type and much more simple.

Best whishes,

Dmitry