BookmarkSubscribeRSS Feed
hodgeswc
Calcite | Level 5

Hello, 

 

I was wondering how I can convert a csv file into sas as a sas7bdat file. Or, if easier, an xls file into sas as a sas7bdat file. 

 

Thanks 

3 REPLIES 3
art297
Opal | Level 21

Both can be done most easily using proc import.

 

Art, CEO, AnalystFinder.com

 

Reeza
Super User

CSV is easier, please see the videos here that illustrate how to accomplish most basic tasks:

http://support.sas.com/training/tutorial/

thomp7050
Pyrite | Level 9

For my part, I would recommend that you file...import data, and follow the wizard's instructions.  Once the wizard has completed, it will output the infile code that you may use to import your dataset.  Copy the code, and paste it into the editor.  Modify it as needed, and save it for future use.

 

Patrick

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 3 replies
  • 26884 views
  • 1 like
  • 4 in conversation