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.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 804 views
  • 1 like
  • 4 in conversation