Tag: SAS Data Integration Studio

How to Jump into SAS Data Integration Studio

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 […]

SAS Certified, Again

Last week I got another SAS certification, SAS Certified Data Integration Developer for SAS 9 and I must say it can’t be better as a SAS holiday gift for myself! I took all my SAS certificates when employed (when in Sanofi Pasteur, 2010, I got two SAS programming certificates, Base and Advanced). You may say […]

Macro Quoting in SAS Data Integration Studio

You can run the following piece of codes successfully in these 3 SAS programming environments: BASE SAS Enterprise Guide: create a new “File-New-Program” SAS Data Integration Studio: create a new “Tool-Code Editor” %let species="Setosa" "Versicolor"; data a;     set sashelp.iris;     where species in (&species); run; Then create a Transformation in SAS Data Integration Studio […]