How can i import .bak filetype (60 million data) to SAS?
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.
.bak looks like a backup of something. From what application did you get the file, and why not use an original?
.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.
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.
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.
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.