topic How to modify the sas code generated by the import data tools in SAS Enterprise Guide

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

alepage — Fri, 20 Jan 2023 17:24:25 GMT

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.

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

ChrisHemedinger — Fri, 20 Jan 2023 17:30:24 GMT

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.

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

alepage — Fri, 20 Jan 2023 17:41:19 GMT

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

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

ChrisHemedinger — Fri, 20 Jan 2023 17:57:29 GMT

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

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

alepage — Mon, 23 Jan 2023 15:14:59 GMT

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