Date:         Wed, 15 Jan 2003 13:03:36 -0500
Reply-To:     "Farrer, Andrew C" <Andrew.Farrer@CIBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Farrer, Andrew C" <Andrew.Farrer@CIBC.COM>
Subject:      Re: x command and moving data
Comments: To: Crystal Vierhout <vierhout@UNITY.NCSU.EDU>
Content-Type: text/plain; charset="iso-8859-1"

Since &save_billses and &herdcode are the only parameters, I would be
inclined to pass them using $1 and $2 such that webreport.BAT looks like:

mkdir U:\wwwroot-o\webreports\$1\pdf
mkdir U:\wwwroot-o\webreports\$1
cd U:\wwwroot-o\webreports\$1
xcopy s:\webrepts\$2\*.zip U:\wwwroot-o\webreports\$1
c:\ut\wzunzip *.zip U:\wwwroot-o\webreports\$1\pdf -o
C:\progra~1\winzip~1\wzipse32.exe U:\wwwroot-o\webreports\$1\" type" -y -d
c:\webreports -i c:\minfile\money5.ico -o -c explorer.exe /n, /e,
c:\webreports

Within SAS you submit :

  X "c:\minfile\webreport.BAT &save_billses &herdcode" ;

This is UNTESTED.


-----Original Message-----
From: Crystal Vierhout [mailto:vierhout@UNITY.NCSU.EDU]
Sent: Wednesday, January 15, 2003 12:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: x command and moving data


Hello,
  I have a question I don't know if there is a perfect answer.  If there is
an answer I thought the user group would have it.  I have a web application
that needs to move data and build an exe prior to displaying.  Below is the
code I'm using.  The delay on the website is 13 seconds which we consider to
long for a production application.  The batch file needs to be built each
time because of it's dynamic nature.

  Is there any other way to move data and build exe faster then the way I'm
going about this?

  Thanks in advance.

  Crystal



  OPTION NOXWAIT;

  DATA _NULL_;

  FILE 'c:\minfile\webreport.BAT';

  put "mkdir U:\wwwroot-o\webreports\&save_billses\pdf";

  put "mkdir U:\wwwroot-o\webreports\&save_billses";

  put "cd U:\wwwroot-o\webreports\&save_billses";

  put "xcopy s:\webrepts\&herdcode\*.zip
U:\wwwroot-o\webreports\&save_billses";

  put "c:\ut\wzunzip *.zip U:\wwwroot-o\webreports\&save_billses\pdf -o";

  put "C:\progra~1\winzip~1\wzipse32.exe
U:\wwwroot-o\webreports\&save_billses\" type" -y -d c:\webreports -i
c:\minfile\money5.ico -o -c explorer.exe /n, /e, c:\webreports";

  RUN;

  X 'c:\minfile\webreport.BAT';

  RUN;