BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
aminkarimid
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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.

View solution in original post

5 REPLIES 5
aminkarimid
Lapis Lazuli | Level 10
##- 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.
Kurt_Bremser
Super User

.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.

aminkarimid
Lapis Lazuli | Level 10
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
SASKiwi
PROC Star

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1745 views
  • 1 like
  • 3 in conversation