1                                                          The SAS System                              12:40 Friday, January 5, 2018

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program';
4          %LET _CLIENTPROJECTPATH='C:\Users\akazmi\Desktop\test_infile.egp';
5          %LET _CLIENTPROJECTNAME='test_infile.egp';
6          %LET _SASPROGRAMFILE=;
7          
8          ODS _ALL_ CLOSE;
9          OPTIONS DEV=ACTIVEX;
10         GOPTIONS XPIXELS=0 YPIXELS=0;
11         FILENAME EGSR TEMP;
12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
13             STYLE=HtmlBlue
14             STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
15             NOGTITLE
16             NOGFOOTNOTE
17             GPATH=&sasworklocation
18             ENCODING=UTF8
19             options(rolap="on")
20         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
21         
22         GOPTIONS ACCESSIBLE;
23         DATA test;
24             LENGTH
25                 'EFF DTE'n         8
26                 COMP               8
27                 ACCOUNT            8
28                 'ACCOUNT DESCRIPTION'n $ 24
29                 CENTER             8
30                 'DOC ID'n        $ 12
31                 LINE               8
32                 'INV.DTE'n         8
33                 ENTY             $ 4
34                 'TXN DESCRIPTION'n $ 21
35                 'CHECK NUM'n       8
36                 'CTRL D  GRP'n     8
37                 AMOUNT             8
38                 SY               $ 2
39                 'VENDOR N.'n       8
40                 GR                 8
41                 BUYR             $ 4
42                 'PO NUMBER'n     $ 10 ;
43             FORMAT
44                 'EFF DTE'n       MMDDYY10.
45                 COMP             BEST4.
46                 ACCOUNT          BEST6.
47                 'ACCOUNT DESCRIPTION'n $CHAR24.
48                 CENTER           BEST8.
49                 'DOC ID'n        $CHAR12.
50                 LINE             BEST4.
51                 'INV.DTE'n       MMDDYY10.
52                 ENTY             $CHAR4.
53                 'TXN DESCRIPTION'n $CHAR21.
54                 'CHECK NUM'n     BEST11.
55                 'CTRL D  GRP'n   BEST11.
56                 AMOUNT           BEST5.
57                 SY               $CHAR2.
2                                                          The SAS System                              12:40 Friday, January 5, 2018

58                 'VENDOR N.'n     BEST9.
59                 GR               BEST2.
60                 BUYR             $CHAR4.
61                 'PO NUMBER'n     $CHAR10. ;
62             INFORMAT
63                 'EFF DTE'n       MMDDYY10.
64                 COMP             BEST4.
65                 ACCOUNT          BEST6.
66                 'ACCOUNT DESCRIPTION'n $CHAR24.
67                 CENTER           BEST8.
68                 'DOC ID'n        $CHAR12.
69                 LINE             BEST4.
70                 'INV.DTE'n       MMDDYY10.
71                 ENTY             $CHAR4.
72                 'TXN DESCRIPTION'n $CHAR21.
73                 'CHECK NUM'n     BEST11.
74                 'CTRL D  GRP'n   BEST11.
75                 AMOUNT           BEST5.
76                 SY               $CHAR2.
77                 'VENDOR N.'n     BEST9.
78                 GR               BEST2.
79                 BUYR             $CHAR4.
80                 'PO NUMBER'n     $CHAR10. ;
81             INFILE 'H:\TEST_INFILE\OIA_EXCEL.txt'
82                 LRECL=170
83                 ENCODING="WLATIN1"
84                 TERMSTR=CRLF
85                 DLM='7F'x
86                 MISSOVER
87                 DSD ;
88             INPUT
89                 'EFF DTE'n       : ?? MMDDYY8.
90                 COMP             : ?? BEST4.
91                 ACCOUNT          : ?? BEST6.
92                 'ACCOUNT DESCRIPTION'n : $CHAR24.
93                 CENTER           : ?? BEST8.
94                 'DOC ID'n        : $CHAR12.
95                 LINE             : ?? BEST4.
96                 'INV.DTE'n       : ?? MMDDYY8.
97                 ENTY             : $CHAR4.
98                 'TXN DESCRIPTION'n : $CHAR21.
99                 'CHECK NUM'n     : ?? BEST11.
100                'CTRL D  GRP'n   : ?? BEST11.
101                AMOUNT           : ?? COMMA5.
102                SY               : $CHAR2.
103                'VENDOR N.'n     : ?? BEST9.
104                GR               : ?? BEST2.
105                BUYR             : $CHAR4.
106                'PO NUMBER'n     : $CHAR10. ;
107        RUN;

ERROR: Physical file does not exist, H:\TEST_INFILE\OIA_EXCEL.txt.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEST may be incomplete.  When this step was stopped there were 0 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.37 seconds
      cpu time            0.07 seconds
      
3                                                          The SAS System                              12:40 Friday, January 5, 2018


108        
109        
110        GOPTIONS NOACCESSIBLE;
111        %LET _CLIENTTASKLABEL=;
112        %LET _CLIENTPROJECTPATH=;
113        %LET _CLIENTPROJECTNAME=;
114        %LET _SASPROGRAMFILE=;
115        
116        ;*';*";*/;quit;run;
117        ODS _ALL_ CLOSE;
118        
119        
120        QUIT; RUN;
121