topic Re: checking file size and send email in SAS Enterprise Guide

checking file size and send email

woo — Mon, 20 Jan 2014 17:33:17 GMT

Hi Friends - i am not sure if this question appropriate in this pan or not but i wants to raise this issue i have.

We have one file coming from different stream and we use that file to process in SAS. this file has .dat extension. Sometime this file coming in with very small size and i want to know if we have a way in SAS to check file size and send out email to users...

I am using windows 2003/SAS 9.1/EG 4.1

Please help!!!

Thanks!!!

Re: checking file size and send email

Reeza — Mon, 20 Jan 2014 17:35:37 GMT

You can use system commands to check a file size and you can email users if something is wrong.

Do you have x commands enabled in your environment?

Both of these questions have answers in the forum already.

Re: checking file size and send email

woo — Mon, 20 Jan 2014 17:57:32 GMT

Thanks Reeza!

no, x command is not enable yet. I am in process with admin to make it enable and waiting for same. I am assuming we have to edit objectspawner.bat file with

- allowxcmd command.

but what is alternative if admin answer is no. can we still do samething?

Re: checking file size and send email

Reeza — Mon, 20 Jan 2014 18:14:37 GMT

Actually I'm not sure you need x commands, just the pipe.

Try it and let me know

The following all get filename but the dir statement can be modified to obtain size as well.

Using SAS Macro to pipe a list of filenames from a Windows directory - Stack Overflow

http://www.amadeus.co.uk/sas-technical-services/tips-and-techniques/general/reading-a-file-list-into-a-data-set/

http://support.sas.com/resources/papers/proceedings11/179-2011.pdf

Re: checking file size and send email

jakarman — Mon, 20 Jan 2014 20:01:25 GMT

If do not have the xcmd you also do not have the pipe command. That wil bring you no solution.

SAS 9.1.3 is becoming outdated the documentation at the SAS site is starting to dissapear.

You can use wildcards (*?) in filenames and create a list of your needed files in that way. SAS(R) 9.3 Companion for Windows (filename)

You will need the filevar option of the infile statement. Hmmm not finding any example I did those tricks a long time ago. Should

come up with an example.

Having the real filenames you can try the finfo fucntion (is there in 9.1.3 I believe) SAS(R) 9.3 Companion for Windows

Re: checking file size and send email

TomKari — Mon, 20 Jan 2014 22:58:53 GMT

Try this piece of code from the SAS doc'n....it works for me.

Tom

data info;

length infoname infoval $60;

drop rc fid infonum i close;

rc=filename('abc', 'physical-filename');

fid=fopen('abc');

infonum=foptnum(fid);

do i=1 to infonum;

infoname=foptname(fid, i);

infoval=finfo(fid, infoname);

output;

end;

close=fclose(fid);

run;

Re: checking file size and send email

woo — Tue, 21 Jan 2014 06:11:00 GMT

Thanks all for your information....

Thanks Tom for posting real code but when i put my values in your code without changing anything i am getting error like,

"invalid do loop control information, either initial or to expression is missing or the by expression is missing, zero or invalid"

Thanks!

Re: checking file size and send email

woo — Tue, 21 Jan 2014 22:35:17 GMT

my file name is AB.WOOLAWSON.USWOO.DAT and this would be around .5 gb. sometimes it come with .2 gb which is much smaller and wants to create email alerts to users....

Thanks!

Re: checking file size and send email

TomKari — Wed, 22 Jan 2014 01:19:31 GMT

That's odd, it works for me.

Try this code with a couple of 'put' statements added for logging.

When I run it I see in the log:

rc=0

fid=1

infonum=6

data info;

length infoname infoval $60;

drop rc fid infonum i close;

rc=filename('abc', 'physical-filename');

put rc =;

fid=fopen('abc');

put fid=;

infonum=foptnum(fid);

put infonum=;

do i=1 to infonum;

infoname=foptname(fid, i);

infoval=finfo(fid, infoname);

output;

end;

close=fclose(fid);

run;

Re: checking file size and send email

HJD24 — Wed, 22 Jan 2014 13:30:18 GMT

You could try using a filename statement to point to the file you want to check, then use the SASHELP.VEXTFL dictionary table to extract the size information;

filename myfile 'D:\myfile.dat';

data _null_;

set sashelp.vextfl;

if fileref = "MYFILE" then do;

size_in_gb = (filesize / (1024**3));

put size_in_gb=;

end;

run;

Re: checking file size and send email

woo — Wed, 22 Jan 2014 17:17:16 GMT

Thanks Tom and HJD24.

meanwhile i have used different approch,

i used proc export to get file in SAS and then used %sysfunc (open)/attrn/close options to get record and then email logic to send an email...this works fine for me...

Thanks!

Re: checking file size and send email

woo — Wed, 22 Jan 2014 17:19:53 GMT

- HJD24 - in your code - filesize variable is uninitialized.

Thanks!