LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (April 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 11 Apr 2002 16:23:13 -0400
Reply-To:     "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Subject:      Re: recoding of data
Comments: To: Sebastien Dube <Sebastien.Dube@MCGILL.CA>
Content-Type: text/plain; charset=iso-8859-1

Sebastien,

If you need to create a SAS data file, you can do this:

data a ; infile <...your file...> ; input @ 41 courseno $char11. @ ; if courseno ne '' then do until ( marker = '99999999') ; input @ 01 marker $char8. @ 12 stuff $char18. ; if marker = '' then output ; end ; drop marker ; run ;

If you need an output text file with the layout you specified, you can do this:

data _null_ ; infile <... your input file ...> ; input @ 41 courseno $char11. @ ; file <... your output file ...> ; if courseno ne '' then do until ( marker = '99999999') ; input @ 01 marker $char8. @ 12 stuff $char18. ; if marker = '' then put courseno stuff ; end ; run ;

Kind regards, ===================== Paul M. Dorfman Jacksonville, FL =====================

> -----Original Message----- > From: Sebastien Dube [mailto:Sebastien.Dube@MCGILL.CA] > Sent: Thursday, April 11, 2002 3:19 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: recoding of data > > > Dear all, > I am trying to recode data and would need some hints. > > The input files look like this: > > [...] > 018001 Professor X 176-134A-01 VECTORIAL ALG. > 535245 34555554234 > 544124333445541443 > 535145 55555553335 > 535145445555541444 > 99999999 > [...] > > The first line refers to a course (176-134A-01) given by Prof X., then > you have the individual answers (one record per student). The 99999999 > indicates the end of the "block" for this course. These "blocks" are > repeated with variable length, however, the alignment of the > information > is always the same (e.g. the course number is always from col > 41-67). > > I am trying to have the course number (176-134A-01) at the > beginning of > each record...like this: > > 176-134A-01 535245 34555554234 > 176-134A-01 544124333445541443 > 176-134A-01 535145 55555553335 > 176-134A-01 535145445555541444 > > (without the first and last line of the block). Is this manipulation > easy to do with SAS? > > All comments are welcome. Many Thanks > > > --------------------------------------------- > Sebastien Dube > McGill University > >

Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.


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