SAS to CSV - The Free Way

October 16, 2020•130 words

Free as in Freedom

As I mentioned in SAS to CSV - The Easy Way, I don't do much of my actual work in SAS, but some of the data I receive is still in the SAS data format. This lead me to create a SAS script to easily convert .sas7bdat files into .csv files that you can find here.

But what if we don't have SAS installed on our computer in the first place? It is an expensive piece of software after all, and not really in line with the Open Data paradigm. Luckily, other people have created packages to read SAS data files in different programs, allowing us to circumvent SAS's paywalled approach to data:

Python - pyreadstat
R - haven
CMD - readstat

👍❤️🫶👏👌🤯🤔😂😍😭😢😡😮

More from Peter Alping
All posts

SAS to CSV - The Easy Way

October 15, 2020•157 words

Since I don't do much of my work in SAS, but some of the data I receive is in SAS format, I've created a SAS script that can be run from the terminal to convert a .sas7bdat file into an ordinary .csv file (optionally compressed to .csv.gz). There is also a Python script to run batch conversions of many SAS data files in parallel. This requires both Python and SAS to be installed. The SAS and Python scripts can be found here. Single file conversion Make sure SAS is on the path and from the roo...

Read post

SAS Scripts - Better Exit Codes

October 23, 2020•232 words

Normally, if a SAS script generates any warnings the exit code is 1, which is generally interpreted as an error by the terminal. To avoid this, we can run SAS through a batch script which converts exit code 1 to 0 (meaning OK). The batch script can be found here. :: Name: sascli.cmd :: Purpose: Run SAS scripts with more generous exit codes. Normally, if a SAS :: script runs with warnings the exit code is 1 (interpreted as an :: error). This script converts exit code 1 to 0 ...

Read post

SAS to CSV - The Free Way

More from Peter AlpingAll posts

SAS to CSV - The Easy Way

SAS Scripts - Better Exit Codes

More from Peter Alping
All posts