LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2000, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 14 Aug 2000 17:12:19 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Antwort: DDE and the notab option
Comments: To: Richard.Simhon@cornhill.co.uk
Content-type: text/plain; charset=us-ascii

You _don't_ need a macro for this ! try these data step features instead put( rich1-rich25 )( '09'x ) ; This puts a '09'x before each richN variable.

To remove the'09'x before rich1 (unless you want an empty first column) put (rich1-rich25)( '09'x ) @1 ' ';

This still leaves a trailing blank at the end of each richN variable Resolve that with put (rich1-rich25)( +(-1) '09'x ) @1 ' ';

If you need to ensure that each character string variable does not cause problems if it contains a '09'x (or whatever other delimiter you might be using), then quote the strings with the format statement format _character_ $quote200. ; ***$quote200 for v6, or as wide as your v8 variables might need ! ; put (rich1-rich25)( +(-1) '09'x ) @1 ' '; Because of the nature of this kind of "grouped formatted put", the $quote200. formats remove trailing blanks before quoting

"you've just gotta try it"

Datum: 11.08.2000 17:59 An: SAS-L@listserv.uga.edu

Antwort an: Richard.Simhon@cornhill.co.uk

Betreff: DDE and the notab option Nachrichtentext:

Listers,

Is there a simple way in which to apply '09'x against "rich1-rich25" without having to spell it out 25 time? (see code below)

filename data dde "excel|driver Count!r5c2:r16000c33" notab; data _null_; file data; set tempo; put prop_typ'09'x rich1-rich25('09'x); run;

Thanks in advance.

Richard

********************************************************************** Copyright in this message and any attachments remains with us. It is confidential and may be legally privileged. If this message is not intended for you it must not be read, copied or used by you or disclosed to anyone else. Please advise the sender immediately if you have received this message in error.

Although this message and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Cornhill Insurance PLC for any loss or damage in any way arising from its use.

Cornhill Insurance Plc, Registered in England number 84638, Registered Office 32 Cornhill, London EC3V 3LJ. **********************************************************************


Back to: Top of message | Previous page | Main SAS-L page