Batch file - options lrec=1000

[paulsparrow]

I am trying to write a batch file and have my sas session allow for fields of 1000 charactors.  Can't seem to get it to work.  Any suggestions. (SAS 9.2)

"C:\Program Files\SAS\SASFoundation\9.2\SAS.EXE"  options lrecl=3000 -icon -noterminal -nosplash -noxwait -noxsync -CONFIG "C:\Program Files\SAS\SASFoundation\9.2\SASV9.CFG"  -SYSIN  "X:\Paul\Programs\Major\Onboarding\Code\onboarding_trial_030_em.sas"  -LOG    "X:\Paul\Programs\Major\Onboarding\Code\onboarding_trial_030_em.log"

[art297]

Take a look at: http://support.sas.com/kb/15/883.html

You have to be runing 9.2 or newer and the options has to be in the configuration file.

From the above mentioned documentation:

Submitting a SAS program via a batch file imposes a maximum

     length limit of 256 characters prior to SAS 9.2.  For SAS 9.2

     and beyond you can use the new SAS system option of LRECL= to

     specify a range of 1-32767 to use for reading and writing

     external files.  The default for the LRECL= system option is

     256.  This option is valid in the configuration file, at SAS

     invocation, the OPTIONS statement, or the SAS Systems Option

     window.  Under z/OS, the LRECL= system option is recognized only

     for reading and writing HFS files.

[paulsparrow]

I have read this but I am unable to decipher.  Looking for an example of where I put the options statement (batch file or cfg file) and how do I write it.

[art297]

I read it wrong.  It is valid in all of those places.  Have you tried simply removing the word 'options'?

[paulsparrow]

Tried that (with and without dash in front of options)  Doesn't work.  See my original post

[art297]

Have you tried it in the following way?  immediately following sas.exe,

..etc.etc..sas.exe -lrecl 1000

[FriedEgg · Accepted solution]

Since you appear to try and execute this code as a batch process your should add the -batch system option.  All system options should be defined by -[option] <[value]>

C:\Program Files\SAS\SASFoundation\9.2\SAS.EXE"  -batch -lrecl 3000 -icon -noterminal -nosplash -noxwait -noxsync -CONFIG "C:\Program Files\SAS\SASFoundation\9.2\SASV9.CFG"  -SYSIN  "X:\Paul\Programs\Major\Onboarding\Code\onboarding_trial_030_em.sas"  -LOG    "X:\Paul\Programs\Major\Onboarding\Code\onboarding_trial_030_em.log

Usually I prefer to keep lrecl option parameters inside my programs and use an options statement or on my filename statement or infile statement.

Options Statement syntax:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000289431.htm

Filename Statement syntax:

http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#chfnoptfmain.htm

Infile Statement syntax:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000146932.htm

[paulsparrow]

THANKS!  Worked like a charm.  Sorry just not that good at White Papers.