BookmarkSubscribeRSS Feed
WilsonPatel
Calcite | Level 5

I am doing a research project for some professors at university and the data that we acquired is in the form of a SAS table. In order to get what we need done, we need this file converted to a .csv file which will be later put into another program that I am more familiar with. Having no experience with SAS (more specifically SAS University) can someone explain the easiest way for me to get this file converted to a csv? I apologize if I am missing any critical information. I have the data imported in SAS already, I just need help getting the csv file to generate.

Thank you so much in advance!

3 REPLIES 3
ed_sas_member
Meteorite | Level 14

Here is the basic syntax;

proc export data=mydata /*specify the name of your SAS dataset*/
	outfile="path/file.csv" /*specify the name of the csv file you want to create*/
	dbms=csv
	replace;
run;

Best,

ballardw
Super User

@WilsonPatel wrote:

I am doing a research project for some professors at university and the data that we acquired is in the form of a SAS table. In order to get what we need done, we need this file converted to a .csv file which will be later put into another program that I am more familiar with. Having no experience with SAS (more specifically SAS University) can someone explain the easiest way for me to get this file converted to a csv? I apologize if I am missing any critical information. I have the data imported in SAS already, I just need help getting the csv file to generate.

Thank you so much in advance!


It never hurts to mention the actual other program that will use the data. Sometimes there may be better ways then creating an intermediate data file with potential issues with  data conversions.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 645 views
  • 1 like
  • 4 in conversation