Help using Base SAS procedures

getting the filesize of created DBF file

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

getting the filesize of created DBF file

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!


Accepted Solutions
Solution
‎06-12-2015 11:06 AM
Super User
Posts: 9,681

Re: getting the filesize of created DBF file

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

View solution in original post


All Replies
Solution
‎06-12-2015 11:06 AM
Super User
Posts: 9,681

Re: getting the filesize of created DBF file

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

Contributor
Posts: 20

Re: getting the filesize of created DBF file

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 229 views
  • 0 likes
  • 2 in conversation