02-22-2015 08:59 PM
ODBC is mostly used for reading database tables not data/text files. What does the .DAT file look like when viewed in a text editor? Does it have aligned rows and columns or is a delimiter used to separate columns?
What issues are you having reading it?
02-22-2015 10:16 PM
It is not opening in text editor, when tried data is crashed.
I basically want to read a .dat file that is copied from exchequer database.
02-23-2015 02:43 AM
How big is the file? Most likely it is the file size that is causing the text editor problems.
You could try reading a few records in SAS to see what the record layout is by writing the first 5 records to the SAS log:
infile "YourFileName.dat" obs = 5;
02-23-2015 03:39 PM
Files are quite small something around 100 KB.
These files are extracted from Pervasive DB which has a default extension .Dat. which cannot be opened in text editor.
The only way I can read this file is through ODBC connection.
02-24-2015 02:00 AM
So you can already open the data in, say, Excel via the ODBC connection?
02-23-2015 03:18 AM
Is it copied or exported from the database?
Is there any documentation about the structure?
If not, return to sender.
02-23-2015 09:48 AM
If I recall it correctly, I think.dat was the default extension for export/backup-files in (very) old versions of SQL Server.
If this is such file, you can't import it either way (ODBC nor text file import).
Verify your source, before trying to import it.
02-23-2015 03:58 PM
Don't think this is a SAS question. How you can be able to access this data via ODBC is a question for Actian/Pervasive DB.
Once you secured ODBC access to your source data, then you can go to SAS and try to connect.