BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello All

I need to join to tables A, B with SAS Data Integration tool version 3.3 Columns in A are ID_CAS,BAC_ID
and columns in B are Region , Area , Team, SortCode,BAC_ID.
The output table columns needed are BAC_ID , Region, Area, Team.
Could you plz walk me thru the steps ..
Thanks
Ravi
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi,
There's a difference between building an SQL join inside a SAS Enterprise Guide project and building a SAS Data Integration Studio process or job (in which the process contains an SQL join).

In EG, you might be doing a join for just your own reporting purposes--so the result of a join may only affect you and your report. However, using SAS Data Integration Studio, you could potentially build joins that had an effect on production tables or production data marts. I always recommend that students and programmers exercise caution when using a product that can create, delete and load production tables.

If you are using SAS Data Integration Studio, your best bet might be to talk to the SAS Administrator at your site or to contact SAS Tech Support for help.

cynthia

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 1 reply
  • 647 views
  • 0 likes
  • 2 in conversation