Posts Tagged ‘ AAG ’

Making SOAP calls from SAS! Integrating with web services

March 31, 2011
By

One of the issues with SAS for many IT departments is the lack of integration with service oriented architecture (SOA). The good news is with many new features coming online with versions 9.X+ are service oriented. Lets look quickly at the Proc SOAP procedure now available. For those SAS programmers out there that aren't familiar...
Read more »

Tags: , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off on Making SOAP calls from SAS! Integrating with web services

SQL tip – Inner join shorthand with USING

January 14, 2011
By

We write a LOT of SQL here and although SQL is a powerful database language, it can be tedious. So here is one tip for shortening all that typing. Typical join sytax: select some_columns from one_table join another_table on one_table.column_1 = another_table.column_1 and one_table.column_2=another_table.column_2 where some_column > someother_column ; Not too bad, right? In order...
Read more »

Tags: , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off on SQL tip – Inner join shorthand with USING

CRM technologies

January 11, 2011
By

As we begin to add posts in 2011, we stepped back to look at our business and our blog. We realized that the two are perfectly aligned. Although the majority of our focus is within the SAS product suite, our focus is marketing analytics and operations. Given that, it is time for us to...
Read more »

Tags: , , , , , , , , , ,
Posted in SAS | Comments Off on CRM technologies

SAS / Teradata Fastexport – dbsliceparm = all

November 11, 2010
By

Fastexport is the fastest way to get large data out of teradata. Fastexport utilizes multiple connections to deliver data and therefore speeding up the transfer of data between Teradata and SAS. Here are a few examples of fastexport. /* libname statement*/ libname teradb  teradata username=&un password=&pw dbsliceparm=all; /* explicit sql */ proc sql; connect...
Read more »

Tags: , , , , , , , , , , , , ,
Posted in SAS | Comments Off on SAS / Teradata Fastexport – dbsliceparm = all

Default value to macro variable

October 12, 2010
By

NOTE: This is a great one we picked up from our friends over at the SAS community. We have run across this literally hundreds of times while programming SAS macros. You need to have a default value for a variable and you don’t want to write another macro to set it if it doesn’t...
Read more »

Tags: , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off on Default value to macro variable

SAS: Where Also

August 9, 2010
By

Ever heard of ‘where also’? Neither did we. We have to give credit to the guys at the SAS Community. ‘Where also’ allows you to add a series of where statements. The use acts like a single where statement with the and condition....
Read more »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off on SAS: Where Also

“call symputX” is the symput upgrade

July 20, 2010
By

SymputX is the upgrade from Call Symput. Syntax: call symputx(“macro_var_name”, character_value (or numeric to be converted to char), symbol table def); Where symput will produce a note about converting character values to numeric, symputx won’t produce such a note. Additionally it will strip leading and trailing spaces form the character value. Lastly, you can...
Read more »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off on “call symputX” is the symput upgrade

Sending an email from SAS

July 19, 2010
By

Have you ever wanted to know when your code completes? Or maybe you want to automate the report to include sending an email? Regardless, SAS is happy to send that email for you. The easiest way to do this is through the SMTP access method via filename statements. Example: filename sendemail email ‘toaddress@email.com’ subject=’This...
Read more »

Tags: , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off on Sending an email from SAS

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors





Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.