Results 1 to 2 of 2
2015-11-30, 14:26 #1
- Join Date
- Nov 2015
- Thanked 0 Times in 0 Posts
Opening SAS/ASCII dataset in excel
I am trying to get some information out a .dat file but have not been able. According to the webpage where I am getting this dataset from, the file can be in either SAS or ASCII format. I have never used any SAS or ASCII program and I want to avoid it as much as I can, since I only need a few details about this file. I was wondering if there was a way to import this dataset to excel.
The webpage where I am downloading the file is: http://meps.ahrq.gov/mepsweb/data_st...Number=HC-160F
Thanks in advance,
2015-11-30, 17:36 #2
- Join Date
- Aug 2010
- Pa, USA
- Thanked 686 Times in 623 Posts
Try renaming the file with a .txt extension (ignore the warning) then letting the file open in Notepad by double clicking it. If it opens as a text file, close it then import it into Excel from the Data tab (2007+)
Alternately, you can right click the file > Open with... > Notepad. If it opens, save it as a text file or copy/paste data into Excel.
Last edited by Maudibe; 2015-11-30 at 17:40.