Date:         Sat, 31 Dec 2011 01:13:55 +0800
Reply-To:     Murphy Choy <goladin@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Murphy Choy <goladin@GMAIL.COM>
Subject:      Re: SAS DI studio queries
Comments: To: global local <firstvar.lastvar@gmail.com>
In-Reply-To:  <CAOZm9CS=UORCXQKrYW4-+9aqfbxy8uCjvw40OWO5Hsquucru2g@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

3. Difference between SQL join and lookup.
        Join has more types of join techniques than lookup.

4. Splitter Vs Extract
        Split a file into N parts vs extracting a sample from the data

5. How to read an external file when the data is in on CSV and variable
names are in MS Access table (MDB).
        I think external files allows you to reference other tables?

Regards,
Murphy Choy
Certified Base SAS Programmer
Certified Advanced SAS Programmer
Certified Predictive Modeler Using SAS Enterprise Miner

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of global
local
Sent: Friday, December 30, 2011 10:33 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS DI studio queries

Hi All,

I will all of you happy holidays.

I have some DI queries and appreciate if any one can help in clearing those.

1. How can we create Error table and Exceptional table in SAS DI.
2. Difference between SCD Type2 & Type3.
3. Difference between SQL join and lookup.
4. Splitter Vs Extract
5. How to read an external file when the data is in on CSV and variable
names are in MS Access table (MDB).

Can any one please help in suggesting me the answers for the above cited
points please.

Thanks,
GL