How to modify the sas code generated by the import data tools

[alepage]

Hello,

I have used the sas import data tool in order to import a csv file without any error.

I have tried with the proc import procedure but it did not give results as nice as with the import tool.

Does someone know the first steps involves in the import data tool, because we don't see it into the generated code.

The goal is to produce a code that will do the same job as the import tools in order to run that script on a regular basis.

[ChrisHemedinger]

It's possible if you follow the advice I share in this article. By adjusting some options in the wizard, and also ensuring that your CSV file can be read directly from SAS (by moving it to your SAS session file system), you can get the DATA step code to work for you.

[alepage]

I did a quick test by unselecting the cleanup process and it does not give what I expect.

[ChrisHemedinger]

The video tutorial (referenced in the article) shows the step-by-step process to get the reusable code from the Import Data task.

[alepage]

Hello Chris, I have watched your video and it is one of the best, I have listen from SAS.