topic Re: SQL to SAS in ODS and Base Reporting

SQL to SAS

aminkarimid — Tue, 02 May 2017 16:36:31 GMT

How can i import .bak filetype (60 million data) to SAS?

Re: SQL to SAS

Kurt_Bremser — Tue, 02 May 2017 17:36:43 GMT

.bak looks like a backup of something. From what application did you get the file, and why not use an original?

Re: SQL to SAS

aminkarimid — Tue, 02 May 2017 19:24:33 GMT

##- Please type your reply above this line. Simple formatting, no
attachments.

Hello
I am using intraday data for my thesis. They are high frequency data (big
data) from stock exchange. To storage effeciently, this data has been saved
in .bak format (SQL). I want to import them to SAS for analysis. But l dont
know how to do this.
Please advice.

Re: SQL to SAS

Kurt_Bremser — Tue, 02 May 2017 19:37:29 GMT

.bak is just a filename extension, not a format specification. With which application or database system (Structured Query Language is used by all major RDBMS systems) was the file originally written?

Assuming that it is a file from a DBMS, you will need that system either to connect SAS to it, or to convert the data to a format that is readable with SAS.

Re: SQL to SAS

aminkarimid — Tue, 02 May 2017 20:41:33 GMT

Backup set 1,
Backup name,trade87
Backup description,
Backup type,Database
User name,M-Rafizadeh\MaryamRafizadeh
Server name,M-RAFIZADEH\TSETMC
Database name,trade87
Database version,706
Database creation date,10/19/2015 12:14:14 PM
Backup size,267.902 MB (280915968 bytes)
Backup start date,11/15/2015 10:11:46 AM
Backup end date,12/30/1899
Software vendor ID,4608
Software version major,SQL Server 2012 (11)
Software version minor,0
Software version build,2100
Family GUID,{4C1F5BDF-90E7-4B63-A576-D6F116A20F0B}
Family count,1
Family sequence number,1
First LSN,28000000000025600087
Last LSN,28000000000031200001
Checkpoint LSN,28000000000025600087
Database backup LSN,0
Sort order,52
Unicode locale ID,1033
Unicode comparison style,196609
Compatibility level,110
Machine name,M-RAFIZADEH
Flags,512
Binding ID,{3F2894F6-C992-4897-81F4-2EE4B2841E47}
Recovery fork ID,{4C1F5BDF-90E7-4B63-A576-D6F116A20F0B}
Collation,English (United States)
Has bulk-logged data,false
Is snapshot,false
Is read-only,false
Is single user,false
Has backup checksums,false
Is damaged,false
Begins log chain,false
Has incomplete metadata,false
Is force offline,false
Is copy only,false
Fork point LSN,0
Recovery model,FULL
Backup set GUID,{938BBCDF-B870-46E9-85CF-8FAD3D6CCE42}
Files: 2,
File ID: 1,
Logical name,trade87
Physical name,C:\Program Files\Microsoft SQL Server\MSSQL11.TSETMC\MSSQL\DATA\trade87.mdf
File type,D (data file)
Filegroup name,PRIMARY
Size,268.000 MB (281018368 bytes)
Max size,32.000 TB (35184372080640 bytes)
Create LSN,0
Drop LSN,0
Unique ID,{C9E1B28E-43A0-48E7-9ED1-B61A3229C49F}
Read-only LSN,0
Read-write LSN,0
Backup size,267.875 MB (280887296 bytes)
Source block size,4096
Filegroup ID,1
Differential base LSN,0
Differential base GUID,{00000000-0000-0000-0000-000000000000}
Is read-only,false
Is present,true
File ID: 2,
Logical name,trade87_log
Physical name,C:\Program Files\Microsoft SQL Server\MSSQL11.TSETMC\MSSQL\DATA\trade87_log.ldf
File type,L (transaction log file)
Filegroup name,
Size,4.563 MB (4784128 bytes)
Max size,2.000 TB (2199023255552 bytes)
Create LSN,0
Drop LSN,0
Unique ID,{1F450F82-98F0-4954-B226-7475DEDA3EFE}
Read-only LSN,0
Read-write LSN,0
Backup size,0 bytes (0 bytes)
Source block size,4096
Filegroup ID,0
Differential base LSN,0
Differential base GUID,{00000000-0000-0000-0000-000000000000}
Is read-only,false
Is present,true

Re: SQL to SAS

SASKiwi — Tue, 02 May 2017 21:38:15 GMT

This is obviously an SQL Server backup. As such it would need to be restored into a target SQL Server database before SAS can read it. SAS would not be able to read it directly.