How to Jump into SAS Data Integration Studio

This post was kindly contributed by From a Logical Point of View » SAS - go there to comment and to read the full post.

This is for for SAS programmers who might be reluctant to check out a GUI tool like SAS Data Integration Studio (DIS for short, which is graphic tool to implement ETL processes: extract, transform, load). DIS translates all users dragged nodes, transformations and process into SAS codes which are traditionally written by SAS programmers. I find one of the benefits of using DIS is that I can package all the ETL work to other players(technical or nontechnical) then they can replay the job by dragging and clicking.

Actually besides translating all the visual nodes to SAS codes, DIS can also reversely incorporate your SAS codes to the graphic job shown as above. So SAS programmers can easily jump into DIS by importing their codes to get the graphic workflow (to get the first impression). Here is an one-minute demo:

Save the following codes in a file(from SAS SQL onlinedoc),

%let dir=C:\;

libname source BASE "&dir";
libname target BASE "&dir";

data source.one;
    input x y;
datalines;
1 2
2 3
;

data source.two;
    input x y;
datalines;
2 5
3 6
4 9
;

proc sql;
    create table target.three as
        select o.x,o.y
        from source.one as o, source.two as t
        where o.x=t.x
        ;
quit;

proc print data=target.three;
run;

Just create a test folder in DIS (this demo was created in a working repository, in a Windows DIS 4.21 machine ) then right click mouse to “Import”-“Import SAS Code” to import the file created above then run the job generated and all set (you will get all stuff showed above).

Note that the SAS libraries must be registered first in the SAS Metadata Server then you can use it. This demo omit this process only for demo purpose.

You can check out the SQL Join by double clicking the SQL node:

and your codes in Code panel (still yours!):

Furthermore, without getting know bunch of the tool first, you can jump into DIS quickly by creating customized Transformations which are basically SAS codes with macro variables as the perimeters in the visual options box. Pretty neat? Just check it out!

This post was kindly contributed by From a Logical Point of View » SAS - go there to comment and to read the full post.

Post navigation