BookmarkSubscribeRSS Feed
Alice
Calcite | Level 5

Hi,

 

I am a new user of SAS

I would like to know how I can import sas7bdat file (not in spk. package format) into SAS Data Integration Studio?Woman Sad

Thank you very much!

 

2 REPLIES 2
LinusH
Tourmaline | Level 20
Search for "register table" in the DI Studio documentation.
This is one of the most basic tasks in DI Studio. It's not recommended to learn this tool on your own and ask questions on the forum. Sugest that you take some basic training/go through self paced tutorials.
Data never sleeps
Patrick
Opal | Level 21

The .sas7bdat extension is for a SAS file. You don't need to import such a file anymore into SAS as it's already in the format for SAS data.

 

 

What you need to do is make the file available to your SAS session. SAS tables (files) become accessible to a SAS session via a Libname statement (or a metadata library definition).

 

DI Studio is metadata driven. In order to use a table in DI Studio you need also a metadata object for the physical object.

 

If you are totally new to SAS then you will first have to skill-up a bit how the SAS Architecture works; what's a compute tier, a mid tier and a metadata tier. 

 

If using DI Studio you will also require some tool training as well as some SAS language programming training. If you're really new to SAS don't just try and use DI Studio. That will only be frustrating without getting the adequate training first. 

 

SAS DI Studio is SAS' ETL tool. In order to use it you will also need to have an understanding of ETL/"Data Warehousing"

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1160 views
  • 0 likes
  • 3 in conversation