topic Re: Need help exporting .SAS7BDAT to .CSV in New SAS User

Need help exporting .SAS7BDAT to .CSV

WilsonPatel — Sat, 19 Oct 2019 06:52:12 GMT

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!

Re: Need help exporting .SAS7BDAT to .CSV

SASKiwi — Sat, 19 Oct 2019 07:00:07 GMT

PROC EXPORT is a good way to do this. This example should be helpful: https://documentation.sas.com/?docsetId=proc&docsetTarget=n0qarv79909fdhn13c60hfubqwdq.htm&docsetVersion=9.4&locale=en

Re: Need help exporting .SAS7BDAT to .CSV

ed_sas_member — Sat, 19 Oct 2019 07:33:58 GMT

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,

Re: Need help exporting .SAS7BDAT to .CSV

ballardw — Mon, 21 Oct 2019 15:26:49 GMT

@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.