Thank you 🙏! ... View more

Here is the log after I imported the data.   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc import datafile="location" 74 out=work.jeopardy dbms=csv replace; 75 getnames=yes; 76 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 77 /********************************************************************** 78 * PRODUCT: SAS 79 * VERSION: 9.4 80 * CREATOR: External File Interface 81 * DATE: 16NOV18 82 * DESC: Generated SAS Datastep Code 83 * TEMPLATE SOURCE: (None Specified.) 84 ***********************************************************************/ 85 data WORK.JEOPARDY ; 86 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 87 infile 'location' delimiter = ',' MISSOVER DSD 87 ! lrecl=32767 firstobs=2 ; 88 informat "Show Number"N best32. ; 89 informat " Air Date"N yymmdd10. ; 90 informat " Round"N $9. ; 91 informat " Category"N $33. ; 92 informat " Value"N $6. ; 93 informat " Question"N $122. ; 94 informat " Answer"N $23. ; 95 format "Show Number"N best12. ; 96 format " Air Date"N yymmdd10. ; 97 format " Round"N $9. ; 98 format " Category"N $33. ; 99 format " Value"N $6. ; 100 format " Question"N $122. ; 101 format " Answer"N $23. ; 102 input 103 "Show Number"N 104 " Air Date"N 105 " Round"N $ 106 " Category"N $ 107 " Value"N $ 108 " Question"N $ 109 " Answer"N $ 110 ; 111 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 112 run; NOTE: 216930 records were read from the infile 'location'. The minimum record length was 55. The maximum record length was 969. NOTE: The data set WORK.JEOPARDY has 216930 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds user cpu time 0.21 seconds system cpu time 0.03 seconds memory 10549.37k OS Memory 95316.00k Timestamp 11/16/2018 06:35:29 AM Step Count 83 Switch Count 2 Page Faults 0 Page Reclaims 294 Page Swaps 0 Voluntary Context Switches 12 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 91656 216930 rows created in WORK.JEOPARDY from jeopardy.csv. NOTE: WORK.JEOPARDY data set was successfully created. NOTE: The data set WORK.JEOPARDY has 216930 observations and 7 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.36 seconds user cpu time 0.31 seconds system cpu time 0.06 seconds memory 10549.37k OS Memory 95832.00k Timestamp 11/16/2018 06:35:29 AM Step Count 83 Switch Count 10 Page Faults 0 Page Reclaims 5565 Page Swaps 0 Voluntary Context Switches 84 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 91704 113 114 115 116 117 proc sql outobs= 10; 118 select Category 119 from work.jeopardy; ERROR: The following columns were not found in the contributing tables: Category. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 120 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 6908.46k OS Memory 94948.00k Timestamp 11/16/2018 06:35:29 AM Step Count 84 Switch Count 0 Page Faults 0 Page Reclaims 242 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 121 122 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 135 And the picture is part of my dataset.     ... View more

Hey, I'm sorry, the Category variable should be in the proc sql step(I typed Value), I've changed it. But no matter what variable I used in my dataset(Value or Category or others ), it always report this error. And I found the INFORMAT/FORMAT information, I pasted it in my post.  ... View more