@PaigeMiller wrote: @Tom wrote: You attached a CSV file, but I don't see any SAS code to read that CSV file into a dataset. Given that the error message is complaining about text with a lot of commas in it I suspect that you problem was with reading the CSV file.  You appear to have read the commas from the CSV into the values of the SAS variables. Given this guess by @Tom, have you@Deepender actually looked at the data set you are using (not the sample one you sent us) to see if some stray commas have caused your .csv file to be improperly read, or are affecting your macros?   ACTUALLY LOOK AT YOUR DATA in the data set (not in the .csv file)! It's a very simple and effective tool for debugging. AND look at your CSV file with a text editor (Notepad, WordPad, the SAS editor etc.) not a spreadsheet. The spreadsheets are notorious for disguising the appearance of certain types of data from CSV files. ... View more