| Date: | Thu, 1 Mar 2012 08:12:51 -0500 |
|---|
| Reply-To: | Nat Wooding <nathani@VERIZON.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Nat Wooding <nathani@VERIZON.NET> |
|---|
| Subject: | Re: Messing up |
|---|
| In-Reply-To: | <OF62153923.F144B633-ON862579B4.00441590-862579B4.00447543@agfinance.com> |
|---|
| Content-Type: | text/plain; charset="US-ASCII" |
|---|
Ron
I suppose that it's because I'm not properly caffinated this morning but I'm
baffled by the error message. Having said that, it appears that you are
taking a file that has fixed width fields separated by colons and writing
out a new one with blanks in place of colons. Try the following somewhat
simpler code.
Nat Wooding
Ps: I do not see a File statement in your code.
Data Start;
filename test 'C:\park\test.txt';
infile test;
Input;
file print;
put _infile_;
_infile_ = translate( _infile_ , ' ' ,':');
put _infile_;
run;
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ron
Wells
Sent: Thursday, March 01, 2012 7:27 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Messing up
11 The SAS System
13:44 Wednesday, February 29, 2012
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to AMERICAN GENERAL FINANCE CORPORATION, Site 0029634002.
NOTE: This session is executing on the z/OS V01R12M00 platform.
NOTE: Running on IBM Model 2096 Serial Number 023EC2,
IBM Model 2096 Serial Number 023EC2,
IBM Model 2096 Serial Number 023EC2,
IBM Model 2096 Serial Number 023EC2.
NOTE: SAS 9.1.3 Service Pack 2
Vv vV 99 11 SpringLeaf Financial Services(SAS)
Vv vV 9 9 1 DDDDD EEEEE V V L
Vv vV 999 1 D D EEE V V L (DEVL--LPAR)
VvV 9 1 D D EEE V V L (Ver 9 TS1 M3)
V 99 @ 11111 DDDDD EEEEE V LLLL
NOTE: The SASUSER library was not specified. SASUSER library will now be
the same as the WORK library.
NOTE: All data sets and catalogs in the SASUSER library will be deleted at
the end of the session. Use the NOWORKTERM option to
prevent their deletion.
NOTE: SAS system options specified are:
SORT=5 NOSORTBLKMODE
NOTE: 134217728 bytes were available above the line at initialization.
NOTE: 11509760 bytes were available below the line at initialization.
NOTE: 133693440 bytes were available above the line after adjustment for
MEMLEAVE=524288.
NOTE: The initialization phase used 0.14 CPU seconds and 9971K.
NOTE: The address space has used a maximum of 648K below the line and
11084K above the line.
1 DATA _NULL_;
2 INFILE INPUT DSD DLM = ':' TRUNCOVER;
3 FILE OUTPUT;
4
5 INPUT ACCT : $08.
6 XLD_LOAN_DT: $8.
7 XLD_CUST_ID: $9.
8 XLD_PORT_ID: $9.
9 XLD_BRANCH_NBR: $8.
10 BIF_BRNO: $20.
11 BIF_ADD: $30.
12 BIF_ADD2: $30.
13 BIF_CITY: $30.
14 BIF_ST: $2.
15 BIF_ZIP5: $5.
16 BIF_ZIP4: $4.
17 BIF_PO_BOX: $30.
18 BIF_PO_CITY: $30.
19 BIF_PO_ST: $2.
20 BIF_PO_ZIP5: $05.
21 BIF_PO_ZIP4: $04.
12 The SAS System
13:44 Wednesday, February 29, 2012
22 BIF_PHONE: $14.
23 BIF_FAX: $14.
24 BIF_BRNCH: $55.
25 BIF_SCORE: $04.
26 BIF_MNGR: $25.
27 BIF_COMP_CD: $60.
28 C_FNAME: $20.
29 C_MNAME: $20.
30 C_LNAME: $30.
31 C_SUFFIX: $03.
32 C_CO_FNAME: $20.
33 C_CO_MNAME: $20.
34 C_CO_LNAME: $30.
35 C_CO_SUFFIX: $03.
36 C_ADDRESS: $60.
37 C_ADDRESS2: $60.
38 C_CITY: $30.
39 C_STATE: $02.
40 C_ZIP5: $05.
41 C_ZIP4: $04.
42 C_TAX_ID: $11.
43 C_CO_TAX_ID: $11.
44 SYSTEM_DT: $10.
45 MAIL_TYPE: $04.
46 WRITER: $10.
47 C_BARCD: $14.
48 C_CUSTNAME: $75.
49 C_CO_CUSTNAME: $75.
50 C_CYST: $70.
51 EDO: $30.
52 XLD_50_01: $50.
53 XLD_50_02: $50.
54 XLD_50_03: $50.
55 XLD_50_04: $50.
56 XLD_50_05: $50.
57 XLD_50_06: $50.
58 XLD_50_07: $50.
59 XLD_50_08: $50.
60 XLD_50_09: $50.
61 XLD_50_10: $50.
62 XLD_50_11: $50.
63 XLD_50_12: $50.
64 XLD_50_13: $50.
65 XLD_50_14: $50.
66 XLD_50_15: $50.
67 XLD_50_16: $50.
68 XLD_50_17: $50.
69 XLD_50_18: $50.
70 XLD_50_19: $50.
71 XLD_50_20: $50.
72 XLD_50_21: $50.
73 XLD_100_1: $100.
74 XLD_100_2: $100.
75 XLD_100_3: $100.
76 XLD_100_4: $100.;
77
78 PUT @01 ACCT 08.
79 @10 XLD_LOAN_DT 8.
13 The SAS System
13:44 Wednesday, February 29, 2012
80 @19 XLD_CUST_ID 9.
81 @29 XLD_PORT_ID 9.
82 @39 XLD_BRANCH_NBR 8.
83 @48 BIF_BRNO 20.
84 @69 BIF_ADD 30.
85 @100 BIF_ADD2 30.
86 @131 BIF_CITY 30.
87 @162 BIF_ST 2.
88 @165 BIF_ZIP5 5.
89 @171 BIF_ZIP4 4.
90 @176 BIF_PO_BOX 30.
91 @207 BIF_PO_CITY 30.
92 @238 BIF_PO_ST 2.
93 @241 BIF_PO_ZIP5 05.
94 @246 BIF_PO_ZIP4 04.
95 @251 BIF_PHONE 14.
96 @266 BIF_FAX 14.
97 @281 BIF_BRNCH 55.
98 @366 BIF_SCORE 04.
99 @371 BIF_MNGR 25.
100 @396 BIF_COMP_CD 60.
101 @456 C_FNAME 20.
102 @477 C_MNAME 20.
103 @498 C_LNAME 30.
104 @528 C_SUFFIX 03.
105 @532 C_CO_FNAME 20.
106 @553 C_CO_MNAME 20.
107 @574 C_CO_LNAME 30.
108 @605 C_CO_SUFFIX 03.
109 @609 C_ADDRESS 60.
110 @670 C_ADDRESS2 60.
111 @730 C_CITY 30.
112 @761 C_STATE 02.
113 @764 C_ZIP5 05.
114 @770 C_ZIP4 04.
115 @775 C_TAX_ID 11.
116 @786 C_CO_TAX_ID 11.
117 @798 SYSTEM_DT 10.
118 @809 MAIL_TYPE 04.
119 @814 WRITER 10.
120 @825 C_BARCD 14.
121 @840 C_CUSTNAME 75.
122 @916 C_CO_CUSTNAME 75.
123 @992 C_CYST 70.
124 @1062 EDO 30.
125 @1093 XLD_50_1 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
126 @1144 XLD_50_2 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
127 @1195 XLD_50_3 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
128 @1246 XLD_50_4 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
129 @1297 XLD_50_5 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
130 @1348 XLD_50_6 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
131 @1399 XLD_50_7 50.
14 The SAS System
13:44 Wednesday, February 29, 2012
___
+ ___
+ ___
29
+ 29
+ 29
132 @1450 XLD_50_8 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
133 @1501 XLD_50_9 50.
+ ___
+ ___
+ ___
29
+ 29
+ 29
ERROR 29-185: Width specified for format F is invalid.
+ERROR 29-185: Width specified for format F is invalid.
+ERROR 29-185: Width specified for format F is invalid.
134 @1552 XLD_50_10 50.
135 @1603 XLD_50_11 50.
136 @1654 XLD_50_12 50.
137 @1705 XLD_50_13 50.
138 @1756 XLD_50_14 50.
139 @1807 XLD_50_15 50.
140 @1858 XLD_50_16 50.
141 @1909 XLD_50_17 50.
142 @1960 XLD_50_18 50.
143 @2011 XLD_50_19 50.
144 @2062 XLD_50_20 50.
145 @2103 XLD_50_21 50.
146 @2154 XLD_100_1 100.
147 @2255 XLD_100_2 100.
148 @2356 XLD_100_3 100.
149 @2457 XLD_100_4 100.;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: The DATA statement used 0.04 CPU seconds and 11672K.
NOTE: The address space has used a maximum of 648K below the line and
12792K above the line.
ERROR: Errors printed on pages 3,4.
+ERROR: Errors printed on pages 3,4.
+ERROR: Errors printed on pages 3,4.
NOTE: The SAS session used 0.18 CPU seconds and 11672K.
NOTE: The address space has used a maximum of 648K below the line and
12792K above the line.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
| 
