excel file converted to ASCII

[Sean_biology]

Hi there,

I am tasked with compiling data fin excel Excel and saving as an ASCII file that is readable by SAS statistics.

how do I convert an excel sheet to an ASCII?

thanks much

Sean

 

[VoG]

You can use File > Save As and select Text (*.txt) as the file type. Or heres an example using a macro (the .txt file must exist before running it):

Sub MyOutput()
Dim iMyFreeFile As Integer, LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
iMyFreeFile = FreeFile
Open "C:\testfile.txt" For Output As #iMyFreeFile
For i = 1 To LR
    Write #iMyFreeFile, Range("A" & i).Value, Range("B" & i).Value, Range("C" & i).Value, Range("D" & i).Value, Range("E" & i).Value
Next i
Close #iMyFreeFile
End Sub

 

[mooseman]

Sean, Is this PC SAS? Or SAS on a mainframe?
For PC SAS, it can read in XLS files very easily.
If it's a main frame, try saving the worksheet as a .CSV file, then SAS can read it using an infile statement with delimiter = ','.