UNIX for Advanced & Expert Users

Your sample SAS dataset file sample.sas7bdat is a CSV file with <space> as the separator character. If that is not the format you want, you must tell us how the file needs to be transformed to produce a CSV file in the format you want. Repeatedly telling us that a CSV file is not a CSV file is not going to help us help you get what you want.

Hi Don,

Actually i am unable to view the sas7dbat file in unix , because its generated using sas. If view it using sas tool then i can able to see the columns and data accordingly which i showed you as an example how the data looks while viewing from SaS 9.4 tool.

Now my query was is there a way to read this sasdataset file and convert into readable format which is comma seprated. It can be exported as .csv or .txt whichever but in accesable format so that i can open the file and access the data in unix.

Your problem is becoming less and less evident to me.
What does "i am unable to view the sas7dbat file in unix , because its generated using sas" mean? Is that file available on your *nix host? Or, how would those output data be provided, and to where?
What does "read this sasdataset file" mean? Does it exist or not?


Please take a step back, carefully rephrase your request (considering my post#4 and Don Cragun's post#6), and draw the whole picture.

Hi Rudic/Don,

Let me clarify once again. I have a sas7bdat file which is present in unix box.
sample.sas7bdat.

I need to read the content of this file. if i do cat on this file it wouldnt be in proper readable format. Hence i would require how i can read this file to a read able format where i would require to export as .csv file. So that i can able to view the data

Code:

tr ' ' ',' <sample.sas7bdat >sample.csv

Hi,

Special characters are getting printed when i use the tr command

What special characters???

Do you mean the tr command is failing and printing a diagnostic message? If so, show us the exact output the tr command produces (in CODE tags).

Do you mean that sample.csv contains special characters after running the command:

Code:

tr ' ' ',' <sample.sas7bdat >sample.csv

? If so, show us the output produced by the command:

Code:

od -bc sample.csv

but, understand that tr didn't insert those "special" characters; they were already present in sample.sas7bdat.