Date: Thu, 14 Jan 1999 08:42:15 +0100
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
Subject: Re: Excel commands from SAS (another Q)
I use the following commands to reformat coloums.
FILENAME SYSTEM DDE "EXCEL|SYSTEM";
DATA _NULL_ ;
PUT '[FORMAT.FONT("TIMES NEW ROMAN",11,FALSE)]';
:-) 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 Frenkel
> Assoc. Research Scientist
> Center for Health & Public Service Research
> New York University