@ama220 wrote: Thank you! The file has many variables and I did not wan to list them all in in the input line. Do you know an easy way to do that without having to type them all? Copy and paste.   If you have trouble opening the CSV file in a text editor to get the header row out so you can copy it then let SAS do it for you. data _null_; infile csv dsd obs=1; input name :$32. @@; put name @; run; Now you can copy the names from the SAS log and the commas will have already been removed.   Once you have the list of names you can use it to make a LENGTH statement.  Just put the length you want after each variable (or group of variables if they all should be the same length).  Then the INPUT statement can just use a simple positional variable list. data want; infile csv dsd truncover firstobs=2; length varfirst $20 var2 var3 var4 8 var5 varlast $10 ; input varfirst -- varlast; run; If you have any DATE, TIME or DATETIME values then also add INFORMAT and FORMAT statements for those variables. (Normal numeric and character variables do not need either a format or an informat attached to them.)   Another possibly is to paste the list into the INPUT statement.  You can then add :$xx. after any character variable.  If you are happy with making a character variable of length 8 just use bare $ instead. data want; infile csv dsd truncover firstobs=2 ; input varfirst :$20. var2 var3 var4 var5 :$10. varlast :$10. ; run; ... View more

Show a better example of your data where records are missed if you want further help with the code. As an FYI - ChatGPT will help you build regular expressions to find data. One of it's more useful features IMO. ... View more

Thanks! I was tried the same code but on a different dataset. No wonder it did not work earlier. ... View more

Thanks for your help!! ... View more

Thanks! ... View more

Welcome to the world of data cleaning. Short of getting into natural language processing I am not sure how much more effort you really want to go with trying to automate this.   You might just want to build these special cases into a lookup file (or FORMAT). ... View more