BookmarkSubscribeRSS Feed
alepage
Barite | Level 11

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.

 

4 REPLIES 4
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
alepage
Barite | Level 11

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

 

 

ChrisHemedinger
Community Manager

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
alepage
Barite | Level 11
Hello Chris, I have watched your video and it is one of the best, I have listen from SAS.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1234 views
  • 0 likes
  • 2 in conversation