Date:         Thu, 14 Jan 1999 08:42:15 +0100
Reply-To:     mads.fiskbak@SAS.DK
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         mads.fiskbak@SAS.DK
Subject:      Re: Excel commands from SAS (another Q)
Comments: To: taf2@is8.nyu.edu
Content-Type: text/plain

Hi.
 
I use the following commands to reformat coloums.
 
FILENAME SYSTEM DDE "EXCEL|SYSTEM";
 
DATA _NULL_ ;
  FILE SYSTEM;
  PUT '[SELECT("C1")]';
  PUT '[FORMAT.FONT("TIMES NEW ROMAN",11,FALSE)]';
  PUT '[FORMAT.NUMBER("#.##0;[RED]-#.##0")]';
RUN;
 
:-) Mads Fiskbeck
 
 
> -----Original Message-----
> From: Tom Frenkel [SMTP:taf2@IS8.NYU.EDU]
> Sent: Wednesday, January 13, 1999 6:16 PM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Excel commands from SAS (another Q)
>
> To SAS-L:
>
> A further question, if I may ...
>
> Does someone know the commands I'd use, from within my SAS program, if I
> wanted to re-format some columns in Excel so that there were no places
> after the decimal point?  I tried creating a macro in Excel, then going
> into Excel's Visual Basic editor and copying those lines into my SAS
> program, but that didn't work (why not?).  In general, where could I look
> up the Excel commands that can be issued from SAS?
>
> I'm running SAS 6.12 and Excel 97 on Win NT 4.0.
>
> Thanks yet again!
>
>         --Tom
>
> Tom Frenkel
> Assoc. Research Scientist
> Center for Health & Public Service Research
> New York University
> taf2@is8.nyu.edu