

In [6]:

    
proc import 
   datafile='adult.data'
   dbms=csv out=df replace;
   getnames=no;
run;









    Out[6]:









  SAS Log
  
  


SAS Log

128  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
129  ;*';*";*/;
130  proc import
131     datafile='adult.data'
132     dbms=csv out=df replace;
133     getnames=no;
134  run;
134!     ;*';*";*/;
135   /**********************************************************************
136   *   PRODUCT:   SAS
137   *   VERSION:   9.4
138   *   CREATOR:   External File Interface
139   *   DATE:      18FEB16
140   *   DESC:      Generated SAS Datastep Code
141   *   TEMPLATE SOURCE:  (None Specified.)
142   ***********************************************************************/
143      data WORK.DF    ;
144      %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
145      infile 'adult.data' delimiter = ',' MISSOVER DSD lrecl=32767 ;
146         informat VAR1 best32. ;
147         informat VAR2 $16. ;
148         informat VAR3 best32. ;
149         informat VAR4 $12. ;
150         informat VAR5 best32. ;
151         informat VAR6 $21. ;
152         informat VAR7 $17. ;
153         informat VAR8 $13. ;
154         informat VAR9 $18. ;
155         informat VAR10 $6. ;
156         informat VAR11 best32. ;
157         informat VAR12 best32. ;
158         informat VAR13 best32. ;
159         informat VAR14 $13. ;
160         informat VAR15 $5. ;
161         format VAR1 best12. ;
162         format VAR2 $16. ;
163         format VAR3 best12. ;
164         format VAR4 $12. ;
165         format VAR5 best12. ;
166         format VAR6 $21. ;
167         format VAR7 $17. ;
168         format VAR8 $13. ;
169         format VAR9 $18. ;
170         format VAR10 $6. ;
171         format VAR11 best12. ;
172         format VAR12 best12. ;
173         format VAR13 best12. ;
174         format VAR14 $13. ;
175         format VAR15 $5. ;
176      input
177                  VAR1
178                  VAR2 $
179                  VAR3
180                  VAR4 $
181                  VAR5
182                  VAR6 $
183                  VAR7 $
184                  VAR8 $
185                  VAR9 $
186                  VAR10 $
187                  VAR11
188                  VAR12
189                  VAR13
190                  VAR14 $
191                  VAR15 $
192      ;
193      if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
194      run;
NOTE: The infile 'adult.data' is:
      Filename=/opt/notebook/adult.data,
      Owner Name=root,Group Name=root,
      Access Permission=-rw-r--r--,
      Last Modified=16Feb2016:15:18:19,
      File Size (bytes)=3974305

NOTE: 32562 records were read from the infile 'adult.data'.
      The minimum record length was 0.
      The maximum record length was 153.
NOTE: The data set WORK.DF has 32562 observations and 15 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds
      
32562 rows created in WORK.DF from adult.data.
  
  
  
NOTE: WORK.DF data set was successfully created.
NOTE: The data set WORK.DF has 32562 observations and 15 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.08 seconds
      cpu time            0.09 seconds
      
195  ods html5 close;ods listing;

196



In [1]:

    
options nosource nonotes;
proc import 
   datafile='adult.data'
   dbms=csv out=df replace;
   getnames=no;
run;
options source notes;









    Out[1]:









  
  
  




11   ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
12   
13   options nosource nonotes;
32562 rows created in WORK.DF from adult.data.
  
  
  
80   ods html5 close;ods listing;

81