| Date: | Wed, 1 Apr 1998 15:45:37 -0500 |
|---|
| Reply-To: | Ray Pass <raypass@WORLDNET.ATT.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU> |
|---|
| From: | Ray Pass <raypass@WORLDNET.ATT.NET> |
|---|
| Subject: | Re: proc dbload |
|---|
| In-Reply-To: | <01bd5ccb$8764f960$1e0710ac@pc2489.tnagb.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii" |
|---|
At 05:36 PM 3/31/98 +0000, Nick wrote:
>I'm using proc dbload to Excel and want user defined formats instead of the
>values to appear in excel. Does anyone know if this is possible without
>using put statements?
DBLOAD has many limitations, like only being able to create a vanilla
1-worksheet workbook, but it does have some customizing abilities. I've
never used the FORMAT option, but it looks like this:
PROC DBLOAD DBMS = XLS;
PATH = 'pc path';
FORMAT var1 fmtone. var2 $fmttwo. ... ;
RUN;
Try it out and let us know. Good luck.
Ray
/---------------------------------------------------------\
| Ray Pass voice: (203) 356-9540 |
| ASG, Inc. fax: (203) 967-8644 |
| 1100 Summer Street |
| Stamford, CT 06905 e-mail: raypass@worldnet.att.net |
\---------------------------------------------------------/
| 
