I am using an INFILE statement to try and import a dataset, however I keep on getting this error for multiple lines:     NOTE: Invalid data for CA_ENGLISH in line 21 320-326. NOTE: Invalid data for CA_DOC in line 21 334-334. I have quadruple checked my code and while there are way more variables this is the INFILE code I am using to import my dataset:     data BNDADOS; infile "xxxxx" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2; informat CA_ENGLISG best32. ; format CA_ENGLISG best12. ; input CA_ENGLISH ; run; I read online that the above error means that there is something wrong in line 21 for variable CA_ENGLISH and CA_DOC. But I have checked this line in my oroginal CSV file and there is absolutely nothing wrong for that record line OR for either of those variables.     I also don't really understand the 320-326 part of the error. I read online that this means this is the column in my CSV file where the error is occurring, but in my csv file I only have about 250 columns!   The other weird thing is that if I do a regular PROC IMPORT, everythign works just fine. but I can't use a proc import b/c I am going to append 4 datasets and using an INFILE helps me set the type and length of all variabels.   Someone please help me I am so stumped!   ... View more

I'm trying to proc import a csv file but for some reason I'm getting an error in the log. I've imported CSV files before so I'm not sure what the problem is.    If I convert my csv file to an excel file, I can successfully import the file for some reason.    When I try to import as a csv this is the code I am using:   proc import out=BN_CSV datafile='xxxx' dbms=csv replace; getnames=yes; guessingrows=200; run; When I run this code I get this in the log:     10699 proc import out=BN_CSV 10700 datafile='xxxxx' 10701 dbms=csv replace; 10702 *Optional statements are below; 10703 getnames=yes; 10704 guessingrows=200; 10705 run; ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.47 seconds cpu time 1.45 seconds   Sorry for the long code...I don't understand what the problem is! Can someone tell me??       ... View more

Hi Everyone,    Learning sas through example, and I'm reading this line of code but I'm  not sure I uderstsand what is hapening.   proc tabulate data = ies_all2; class site schedule location csr instructions comfort_wr comfort_er clinic_skill questions privacy experience; classlev schedule location csr instructions comfort_wr comfort_er clinic_skill questions privacy experience / s=[just=right font_style=italic font_weight=light]; table schedule location csr instructions comfort_wr comfort_er clinic_skill questions privacy experience all, site * (n*f=3.0 colpctn="%"*f=4.1)/ misstext = "--"; format site site. schedule location csr instructions comfort_wr comfort_er clinic_skill questions privacy experience posf.; run; Specifcally I'm confused about what the following part of the above code is doing:   (n*f=3.0 colpctn="%"*f=4.1)/ misstext = "--"   Can someone please explain this to me?   Thank you!                 ... View more