Hi!  I am reading in several text files using a wildcard in the infile statement and I include additional statements to store the name of the file in a separate variable.  Each text file includes the variable names in the first row.   DATA work.test LENGTH filename txt_file_name $256; RETAIN txt_file_name; INFILE "C:\samplepath\*.txt" EOV = eov FILENAME = filename DLM = "," MISSOVER DSD LRECL = 32767; INPUT@; IF _N_ = 1 OR EOV THEN DO; txt_file_name = scan(filename, -1,"\"); EOV = 0; DELETE; END; ELSE INPUT ..... The files that I am reading in 'should' all have the same structure.  Is there a way to test within this data step that the files being read in all have the same number of variables? I am trying to avoid reading them all in separately and checking that way.  I was thinking that replacing the MISSOVER option with the STOPOVER option might work, but I get an error message "INPUT statement exceeded record length."  Any help is greatly appreciated.  Thanks! ... View more

Hi.  I am attempting to use the methods outlined in this blog post:   https://blogs.sas.com/content/sasdummy/2018/10/09/read-multiple-text-files/   to import multiple text files from a folder using a wildcard.   - Example Code from Blog Post Above - data accel; infile "/home/chris.hemedinger/tsv/*.tsv" dlm='09'x; length counter 8 timestamp 8 x 8 y 8 z 8 filename $ 25; input counter timestamp x y z filename; run;   However, each of my files has field names in the first row and it appears that including the firstobs=2 option only applies to the first file contained in the folder.  As a result, SAS is attempting to read in the first row of all my datasets (minus the first dataset) as data and I am getting a lot of messages in the log about invalid data.    At this point, I have included a conditional statement to later delete these unwanted rows.  This method works, but I was wondering if there is a better method that communicates to SAS to skip the first row of every dataset it is attempting to read in.     Thanks!     ... View more