|Date: ||Wed, 28 Aug 2002 22:49:37 +0200|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Bart Heinsius <Bart.Heinsius@EOMDATA.NL>|
|Subject: ||Check existance of Excel sheet within Workbook|
|Content-Type: ||text/plain; charset="iso-8859-1"|
If I run a PROC IMPORT on an Excel file and specify the name of the sheet I
want to load and the sheet does not exist, an ERROR is generated.
Since my programs are running with OPTIONS ERRORABEND, the job halts, even
though it is a normal situation that the sheet I specified does not exist.
Is there any way to check on forehand whether the sheet exists or not?
Note that on the (server) machine that this program runs on, Excel is NOT
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
> Kevin Auslander
> Sent: woensdag 28 augustus 2002 22:31
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: proc forms
> I am having trouble getting proc forms to do what I need. Here is the
> proc forms data=Sug.Msug(obs=12) file=labels
> lines=4 /*4 lines per unit*/
> width=25 /*unit 24 characters across*/
> across=3 /*three columns of units */
> ndown=5 /*5 rows of units*/
> between=2 /*print 2 spaces between units*/
> down=2 /*top margin of 2 lines*/
> indent=2 /*left margin of 2 characters*/
> pagesize=60 /*the number of lines on the entire page*/
> skip =2 /*skip 2 lines between each row of
> copies=1 /*one unit per observation*/
> align=1 /*print 1 row of dummy units*/
> sets=1 /*produce 1 set of units*/
> cc; /*let it eject each page on it's
> line 1 P_SALUT P_FNAME P_M_INIT P_SNAME / Pack;
> line 2 A_LINE1 / Pack;
> line 3 A_LINE2 / Pack;
> line 4 A_CITY A_state A_zip / Pack;
> The alignment is ok for the labels. But A_LINE1 is more than 24
> characters in some places. So, A_Line1 gets cut off in some cases. I
> want the text of A_LINE1 to wrap around to the next line in these cases.
> How can I make the text wrap around instead of being cut off?
> I have considered making a new field called A_LINE1ANDAHALF which would
> contain all text from A_LINE1 that is past 25 characters. Then I would
> be able to slip in A_LINE1ANDAHALF between lines 1 and 2. However, in
> doing that, I run the risk of splitting words into pieces. Please help
> if you have any good ideas on how to solve this problem.