Groups | Search | Server Info | Login | Register

Groups > comp.soft-sys.sas > #890

Re: Need to find how many files I have on our SAS server

Show all headers | View raw

When you said SAS files, do you mean SAS datasets?

"Styrmir"  wrote in message 
news:a059a171-8942-4f91-9b45-e9e3980205ef@c20g2000vbv.googlegroups.com...

Hi guys

I have an issue and I hope you can help me. I need to put a SAS code
in to production and the issue is that I need to import all files in a
certain location. This is a part of a massive process and there should
be 26 files in the folder but in order to cover myself I would like to
ask if there is a way to check via SAS how many files I have? This I
would like to do because I want to know how many times I need to loop.
The files are named File_1 File_2 etc. so I could either find the last
file in the folder and see from there how many times I need to loop or
just to calculate how many files I have in the folder.

Does anybody know how to do this? I have searched high and low but can
not seem to be able to find the solution.

There is an alternative solution of course which I can use if nobody
has an answer here. I could script myself out of this and output an
extra file which includes the right number of files and have SAS pick
up that file but I really dont like vbscripts and I am also curious to
know if I can do this in SAS and improve my SAS programming skills.

Thanks in advance
Styrmir Gunnarsson 

Back to comp.soft-sys.sas | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Need to find how many files I have on our SAS server Styrmir <styrmirg@gmail.com> - 2011-06-09 06:40 -0700
  Re: Need to find how many files I have on our SAS server "Kenneth M. Lin" <kenneth_m_lin@sbcglobal.net> - 2011-06-09 08:19 -0700
    Re: Need to find how many files I have on our SAS server Styrmir <styrmirg@gmail.com> - 2011-06-09 22:52 -0700
  Re: Need to find how many files I have on our SAS server "Lou" <lpogoda@hotmail.com> - 2011-06-10 20:49 -0400
  Re: Need to find how many files I have on our SAS server Helen <sunchunkui@hotmail.com> - 2011-06-14 07:07 -0700

csiph-web