The delimiter 7C worked perfectly! I was able to execute and the log now dont have errors: 61 /**********************************************************************
62 * PRODUCT: SAS
63 * VERSION: 9.4
64 * CREATOR: External File Interface
65 * DATE: 07APR21
66 * DESC: Generated SAS Datastep Code
67 * TEMPLATE SOURCE: (None Specified.)
68 ***********************************************************************/
69 data WORK.EYRG0004A ;
70 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
71 infile DATOS delimiter = '|' MISSOVER DSD firstobs=2 ;
72 informat ENTI best32. ;
73 informat CIRBE best32. ;
74 informat OPE best32. ;
75 informat FIN $3. ;
76 informat TPR $3. ;
77 informat SIT $3. ;
78 informat CONT best32. ;
79 informat SEC $1. ;
80 informat ACTE $1. ;
81 informat PR best32. ;
82 informat IMP_RIDISPU best32. ;
83 informat IMP_RIDISPO best32. ;
84 informat A $1. ;
5 The SAS System 16:21 Wednesday, April 7, 2021
85 informat _1 best32. ;
86 informat _2 best32. ;
87 informat _3 best32. ;
88 informat _4 best32. ;
89 informat _5 best32. ;
90 informat _6 best32. ;
91 informat _7 best32. ;
92 informat _8 best32. ;
93 informat VAR22 $1. ;
94 format ENTI best12. ;
95 format CIRBE best12. ;
96 format OPE best12. ;
97 format FIN $3. ;
98 format TPR $3. ;
99 format SIT $3. ;
100 format CONT best12. ;
101 format SEC $1. ;
102 format ACTE $1. ;
103 format PR best12. ;
104 format IMP_RIDISPU best12. ;
105 format IMP_RIDISPO best12. ;
106 format A $1. ;
107 format _1 best12. ;
108 format _2 best12. ;
109 format _3 best12. ;
110 format _4 best12. ;
111 format _5 best12. ;
112 format _6 best12. ;
113 format _7 best12. ;
114 format _8 best12. ;
115 format VAR22 $1. ;
116 input
117 ENTI
118 CIRBE
119 OPE
120 FIN $
121 TPR $
122 SIT $
123 CONT
124 SEC $
125 ACTE $
126 PR
127 IMP_RIDISPU
128 IMP_RIDISPO
129 A $
130 _1
131 _2
132 _3
133 _4
134 _5
135 _6
136 _7
137 _8
138 VAR22 $
139 ;
140 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
141 run;
6 The SAS System 16:21 Wednesday, April 7, 2021
NOTE: The infile DATOS is:
Filename=/SASDATOS/MIS/datos/salidak90.txt,
Owner Name=xe22674,Group Name=sas,
Access Permission=-rw-r--r--,
Last Modified=07Apr2021:13:33:47,
File Size (bytes)=31715
NOTE: 10 records were read from the infile DATOS.
The minimum record length was 1760.
The maximum record length was 3001.
NOTE: The data set WORK.EYRG0004A has 10 observations and 22 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 9873.37k
OS Memory 17864.00k
Timestamp 04/07/2021 04:21:58 PM
Step Count 3 Switch Count 0
Page Faults 0
Page Reclaims 247
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
10 rows created in WORK.EYRG0004A from DATOS. I still cant open the sas7bat, but is probably just me moving the wrong variable after Import. I will check after launch. Thanks! Edit: Yep, just change a few names and now i can 😛
... View more