Date:         Wed, 12 Sep 2007 15:59:38 -0600
Reply-To:     Alan Churchill <savian001@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <savian001@GMAIL.COM>
Subject:      Re: Use Windows Explorer "selected files" as input to SAS program.
Comments: To: "data _null_," <datanull@gmail.com>
In-Reply-To:  <7367b4e20709121438l30be7a6ds868d8f83854999cb@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

No, you don't have to download anything. You can code it in C#, VB.NET, C++,
etc. using NotePad and it will run fine as a command line tool. HOWEVER, you
can save yourself a lot of grief by using PowerShell which is designed
specifically to do this sort of thing and using a modern editor.

BTW, what you are asking to do is not a simple task: it requires scripting.
Microsoft has addressed the complaints about scripting by creating
PowerShell which works off of .NET. PowerShell will be included in future
server versions (Windows Server 2008 includes it).

Alan

Alan Churchill
Savian
www.savian.net



-----Original Message-----
From: data _null_, [mailto:datanull@gmail.com]
Sent: Wednesday, September 12, 2007 3:39 PM
To: Alan Churchill
Cc: SAS-L@listserv.uga.edu
Subject: Re: Use Windows Explorer "selected files" as input to SAS program.

I the only way to do even simple tasks on Windows is to "download more
software"?

I don't want to have to ask for extra software be installed on the
Windows Presentation Server where I run SAS.

On 9/12/07, Alan Churchill <savian001@gmail.com> wrote:
> Powershell. Free from Microsoft and you have full control over the
> processing.
>
> http://tinyurl.com/e5x2t
>
>
> Alan
>
> Alan Churchill
> Savian
> www.savian.net
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of data
> _null_,
> Sent: Wednesday, September 12, 2007 2:14 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Use Windows Explorer "selected files" as input to SAS
program.
>
> On 9/12/07, Pardee, Roy <pardee.r@ghc.org> wrote:
> > Do you not get a 'submit to sas' menu item when you right click on one
> > of the selected files?  (I don't, but I know my sas install is a bit
> > wonky).
>
> I don't want to run each selected file I want to make the "list" of
> selected files be the input to a SAS program.
>
> > If you don't, I'd prescribe a script that sits in your 'send to' folder.
> > You highlight your files, right-click, and then choose your script off
> > the Send To menu.  The script will be passed the file/pathnames of the
> > .sas files as arguments & you shell out to sas for each one.
> >
> > I've got a vbscript you could probably adapt to this pretty easily if
> > you're interested.
>
> Isn't there a limit of 2048 characters that are passed to the script.
> I don't know that much about it.
>
> > One down side to that approach is you may not have a ton of control over
> > the order in which your .sas programs get run.  You'll also need to
> > decide whether to run them one at a time or in parallell (so to speak).
> >
> > HTH,
> >
> > -Roy
> >
> > -----Original Message-----
> > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> > data _null_,
> > Sent: Wednesday, September 12, 2007 12:51 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: Use Windows Explorer "selected files" as input to SAS program.
> >
> > I want to "select" some files in the Windows Explorer and "somehow"
> > start a SAS program that uses the "selected" file names as input.
> >
> > Sort of like FILENAME PIPE on a DIR command but just the "selected"
> > files.
> >
> > I will create using SAS, I guess, some kind of hyperlinked document
> > using the content of the "selected" files.
> >
> > I don't know if having the starting point the WinEXP or if some other
> > FILELIST interface is better.
> >
>
>