UNIX for Advanced & Expert Users

Hi Guys,

Is there a way to export a sas file i.e .sas7bdat file to .csv file with header and data using unix. I dont want to use SAS program instead using unix tool or unix scripting is it possible ?

That's highly probable.

Hi Rudic,

Can you let me know how it can be done, because i would require to read the sasdataset file and export. How it can be done in unix

I would REALLY like to let you "know how it can be done" - IF you gave e.g. a sample representing your "sasdataset" and a target output file structure. With sloppy generic request formulations like above, what else than sloppy generic answers do you expect?

Hi rudic,

For eg my file is sample.sas7bdat which has below columns

Code:

id name country
01 xyz AUS
02 yyy NZ

My sample.csv will have the same data

I don't understand your problem. If you want a character separated values (i.e. CSV) file (with an unspecified character as the separator), then your sample SAS dataset is a CSV file in the format you want. If you're saying that you want a copy of your SAS dataset file with the name sample.csv, try:

Code:

cp sample.sas7bdat sample.csv

If you're saying that you don't want to keep two copies of your file and just need to rename your file, try:

Code:

mv sample.sas7bdat sample.csv

If there is something else that you want done, please specify details about what you want done instead of giving generalities that could be solved hundreds of different ways that might or might not do what you really want.

Hi Don,

My sample.sas7bdat is a sas dataset file which hold these columns. Its not csv file. Just for sample data i mentioned. Basically i would require to read this sas dataset file and convert into csv file so that i can read the data along with columns