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: AAG, AFHood Analytics Group, analytics consulting, consulting, dynamic, function, General Chatter, http post, output to file, proc soap, SAS, SAS Code, SOA, web service, webservices, XML
Posted in SAS | Comments Off
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: AAG, AFHood Analytics Group, conditional processing, conditional programming, default value, dynamic, function, if then, macro coding, macro script, open code, SAS, sas automation, SAS Code, SAS macro, SAS Macros, sas script, string functions
Posted in SAS | Comments Off
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: AAG, AFHood Analytics Group, analytics, analytics consulting, conditional processing, conditional programming, dynamic, function, SAS, SAS Code, where, where also, where statement
Posted in SAS | Comments Off
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: AAG, AFHood Analytics Group, attachments, conditional programming, data driven, dataset, distribution list, dynamic, notification, output to file, reports, SAS, SAS Code, SAS macro, send email, sendmail
Posted in SAS | Comments Off
The INTNX function increments dates, times, or datetimes by specific or custom intervals. Here is the basic syntax for INTNX: INTNX(interval, start, increment) The interval can be a set value like – DAY, WEEK, DTWEEK, YEAR, etc. You can also specify a custom interval. We will post more on that later. The multiple...
Read more »
Tags: AAG, add days, add months, add time, add years, AFHood Analytics Group, alignment, analytics, analytics consulting, beginning, date function, date increment, date shift, date start, datetime, decrease, dynamic, end, increase, increment, intnx, middle, same, SAS, SAS Code, sas function, time, timestamps
Posted in SAS | Comments Off
The DIM function returns the number of literal elements in an array. It functions against multi-dimensional arrays as well as one-dimensional arrays. 1-dimensional array example DIM(array_name) Multi-dimensional array examples DIM(m_array) -> returns the number of elements in the first dimension of the array DIM5(m_array) -> returns the number of elements in the 5th dimension...
Read more »
Tags: AAG, AFHood Analytics Group, analytics consulting, conditional processing, dim, dim function, do loop, do loop processing, do loops, dynamic, function, loops, multi-dimensional array, one-dimensional array, SAS, SAS Code, sas function
Posted in SAS | Comments Off
