Hello guys, i ran this little piece of code below in an attempt to subset some data from a csv file.
LIBNAME Catalog 'E:\Source Dataset';
LIBNAME Autopay 'E:\Breakdown\Autopay';
PROC IMPORT OUT= Catalog.June08
DATAFILE= "E:\Source data\B06 - Switch Summary_csv_2010_0608.csv"
DBMS=CSV REPLACE;
GETNAMES=NO;
DATAROW=2;
RUN;
DATA Autopay.GTB;
SET Catalog.june08;
WHERE var14 = 'Autopay Transactions';
RUN;
PROC PRINT DATA = Autopay.GTB;
TITLE 'GTB AUTOPAY TRXNS';
RUN;
My results below show that 28929 records were read from the Source data (B06 - Switch Summary_csv_2010_0608.csv) but no data was subset into the data set Autopay.GTB.
I have checked all possible errors
All data sets were initialized
Field names are correct
File paths are correct
Can anyone help me out here, the log code is shown below:
443 data CATALOG.JUNE08 ;
444 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
445 infile 'E:\Source data\B06 - Switch Summary_csv_2010_0608.csv' delimiter = ',' MISSOVER DSD
445! lrecl=32767 firstobs=2 ;
446 informat VAR1 $24. ;
447 informat VAR2 $10. ;
448 informat VAR3 $6. ;
449 informat VAR4 $16. ;
450 informat VAR5 $11. ;
451 informat VAR6 $4. ;
452 informat VAR7 $18. ;
453 informat VAR8 $19. ;
454 informat VAR9 $29. ;
455 informat VAR10 $22. ;
456 informat VAR11 $16. ;
457 informat VAR12 best32. ;
458 informat VAR13 $12. ;
459 informat VAR14 $50. ;
460 format VAR1 $24. ;
461 format VAR2 $10. ;
462 format VAR3 $6. ;
463 format VAR4 $16. ;
464 format VAR5 $11. ;
465 format VAR6 $4. ;
466 format VAR7 $18. ;
467 format VAR8 $19. ;
468 format VAR9 $29. ;
469 format VAR10 $22. ;
470 format VAR11 $16. ;
471 format VAR12 best12. ;
472 format VAR13 $12. ;
473 format VAR14 $50. ;
474 input
475 VAR1 $
476 VAR2 $
477 VAR3 $
478 VAR4 $
479 VAR5 $
480 VAR6 $
481 VAR7 $
482 VAR8 $
483 VAR9 $
484 VAR10 $
485 VAR11 $
486 VAR12
487 VAR13 $
488 VAR14 $
489 ;
490 if _ERROR_ then call symput('_EFIERR_',1); /* set ERROR detection macro variable */
491 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
490:44
NOTE: The infile 'E:\Source data\B06 - Switch Summary_csv_2010_0608.csv' is:
File Name=E:\Source data\B06 - Switch Summary_csv_2010_0608.csv,
RECFM=V,LRECL=32767
NOTE: 28929 records were read from the infile 'E:\Source data\B06 - Switch Summary_csv_2010_0608.csv'.
The minimum record length was 129.
The maximum record length was 203.
NOTE: The data set CATALOG.JUNE08 has 28929 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.34 seconds
cpu time 0.32 seconds
28929 rows created in CATALOG.JUNE08 from E:\Source data\B06 - Switch
Summary_csv_2010_0608.csv.
NOTE: CATALOG.JUNE08 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.68 seconds
cpu time 0.62 seconds
492
493 DATA Autopay.GTB;
494 SET Catalog.june08;
495 WHERE var14 = 'Autopay Transactions';
496 RUN;
NOTE: There were 0 observations read from the data set CATALOG.JUNE08.
WHERE var14='Autopay Transactions';
NOTE: The data set AUTOPAY.GTB has 0 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
497
498 PROC PRINT DATA = Autopay.GTB;
499 TITLE 'GTB AUTOPAY TRXNS';
500 RUN;
NOTE: No observations in data set AUTOPAY.GTB.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
... View more