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 (July 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 24 Jul 2008 22:54:34 -0400
Reply-To:   "Howard Schreier <hs AT dc-sug DOT org>" <schreier.junk.mail@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Howard Schreier <hs AT dc-sug DOT org>" <schreier.junk.mail@GMAIL.COM>
Subject:   Re: Reading multiple text files into one dataset
Content-Type:   text/plain; charset=ISO-8859-1

On Thu, 24 Jul 2008 06:00:27 -0700, dave crimkey <d_crimkey@YAHOO.COM> wrote:

>Thanks.� I'm having other problems with the files as well.� I was trying >different methods to read them and decided that I'd better try reading >just one for now.

Good idea.

>So I did that with the following code (listing out >all the variables to be safe).� Each VAR is a very precise value (about >22 dec places).

I doubt that you will be able to maintain that precision in SAS.

>If I look at the file in a text editor, the maximum >length of a record is 3090 but I keep getting the Truncated message

Please post that message (copied from log in context).

>and the last variable VAR129 will not read in.� In addition only half the >file is reading in.� So I should be reading 300 records in and only 150 >records are coming in.

That's common in the absence of MISSOVER or TRUNCOVER, but rather unusual otherwise. Are you sure that outcome resulted from the code you show here?

>� I'm not sure what's going on with my infile > statement or the file itself but I won't be able to read all the files >in until I can get one file in. >� >DATA A; >INFILE "C:\SasFiles\A_102m_Bx_1.txt" lrecl=3090 DLM='09'x missover dsd;

input var1 - var129; /* is equivalent */

>INPUT VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 VAR9 VAR10 >VAR11 VAR12 VAR13 VAR14 VAR15 VAR16 VAR17 VAR18 VAR19 VAR20 >VAR21 VAR22 VAR23 VAR24 VAR25 VAR26 VAR27 VAR28 VAR29 VAR30 >VAR31 VAR32 VAR33 VAR34 VAR35 VAR36 VAR37 VAR38 VAR39 VAR40 >VAR41 VAR42 VAR43 VAR44 VAR45 VAR46 VAR47 VAR48 VAR49 VAR50 >VAR51 VAR52 VAR53 VAR54 VAR55 VAR56 VAR57 VAR58 VAR59 VAR60 >VAR61 VAR62 VAR63 VAR64 VAR65 VAR66 VAR67 VAR68 VAR69 VAR70 >VAR71 VAR72 VAR73 VAR74 VAR75 VAR76 VAR77 VAR78 VAR79 VAR80 >VAR81 VAR82 VAR83 VAR84 VAR85 VAR86 VAR87 VAR88 VAR89 VAR90 >VAR91 VAR92 VAR93 VAR94 VAR95 VAR96 VAR97 VAR98 VAR99 VAR100 >VAR101 VAR102 VAR103 VAR104 VAR105 VAR106 VAR107 VAR108 VAR109 VAR110 >VAR111 VAR112 VAR113 VAR114 VAR115 VAR116 VAR117 VAR118 VAR119 VAR120 >VAR121 VAR122 VAR123 VAR124 VAR125 VAR126 VAR127 VAR128 VAR129 ; >RUN;

[snip]


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