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 (March 2005, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 7 Mar 2005 17:05:30 -0500
Reply-To:   harry.droogendyk@RBC.COM
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Harry Droogendyk <harry.droogendyk@RBC.COM>
Subject:   Re: Reading file with custom delimiter (> 1 character)
Content-Type:   text/plain; charset=iso-8859-1

Not unless you expect to find them in your data.

If you were reading from a socket or something equally mysterious, data tranmission codes might be problematic, but if they won't be found in your text file you ought to be okay.

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Bonett, John Sent: Monday, March 07, 2005 5:03 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading file with custom delimiter (> 1 character)

Are there any pratfalls to using ASCII actions as delimiters such as enquiry (hex=05) or acknowledge (hex=06)?

-----Original Message----- From: Harry Droogendyk [mailto:harry.droogendyk@RBC.COM] Sent: Monday, March 07, 2005 3:28 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Reading file with custom delimiter (> 1character)

Use TRANWRD to change the @@ to another single character, say tab and specify tab as the delimiter:

data a; infile cards dlm='09'x; input @; _infile_ = tranwrd(_infile_,'@@','09'x); input var1 $ var2 $ var3 $; cards; ASDF@@1234@@qw@abc vnmm@@23@45@@rtyu run;

proc print; run;

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Bonett, John Sent: Monday, March 07, 2005 3:18 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading file with custom delimiter (> 1character)

Hello all,

I need SAS (V8.2) to read data in a text file that uses a custom delimiter of >1 character such as @@. EX: JIM@@E@@JONES@@JJONES@MSN.COM

Is there an easy way to handle this rather unconventional data structure? Thank you in advance!

************************************ John Bonett ETS R & D Division jbonett@ets.org <mailto:jbonett@ets.org>

"If your experiment works, you obviously did something wrong."- addendum to Murphy's Law

************************************

************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance.

------------------------------------------------------------

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================

************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance.

------------------------------------------------------------

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================


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