@shahparth260: "I usually do one thing If I come across CSV file than I first convert in to XLSX file". This is by far the worst thing you can do with a csv-file. Proc import is a guessing procedure, it assumes variable types an length and can fail to import a file that could be read by a data step. Additionally excel tends to modify data without notifying the user, so almost always additional steps are necessary to fix things gone wrong. And things will sooner or later go wrong.
... View more
