Jonas V. Bilenas

Thanks for joining me!

I have been using SQL and SAS® software in the Banking Industry for a number of years. This site contains some of the papers I have presented since 2000 at SAS User Conferences (NESUG, SGF, SESUG, PNWSUG, SUGI, and PharmaSUG) and at Local SAS User Group meetings (PHILASUG, HASUG, NYASUG, NJSUG). Data for these presentations are not from banks I worked at but are simulated data, fabricated data, or data obtained from other industries taken from web sources or text books.

I also had authored the book “The Power of PROC FORMAT” published by SAS® Press but is no longer in print. You maybe able to find a copy on Amazon.

Also during my academic days I presented at American Statistical Association (ASA), The Institute of Management Sciences (TIMS) and other conferences. Not based on using SAS® which I learned during my corporate years.

I am currently available for presentations, typically at SAS User Group Conferences and Local SAS User Group Meetings. I am also currently available for contract work.

The contents of this Blog site are the work of the author and do not necessarily represent the opinions, recommendations, or practices of any company that I have worked for or are currently working for.There is no warranty on any of the code illustrated in this blog site.  

LinkedIn Site

SAS® is a registered trademark of SAS Institute Inc., Cary, NC USA. This web site has no affiliation with, not sponsored by, or endorsed by SAS INSTITUTE INC. #SAS



Short Topics Page:

Future Presentations:

  • At the Winter 2020 PhilaSUG meeting hosted by K3-Innovations at the
    Penn State Great Valley Campus, 30 E. Swedesford Road, Malvern, PA 19355. At the main building, room 126/127. Meeting date is Wednesday March 18, 2020. My presentation is Using the %SCAN Function.

Abstract: The SAS® macro %SCAN function is useful to process a string of values separated by spaces or commas, scanning in each value one at a time. Once the value is processed the next value is selected until all values are exhausted. An interesting application that will be reviewed is how to automatically rename all lower case SAS variable names into upper case in a SAS data set. The second application will show you how to break huge SGSCATTER PLOTS into mutliple plots using %SCAN and other #SAS tricks.

Looking forward to meet many #SAS users at the event. Membership is only $30 a year! Log into to register. If you don’t see the new newsletter, Winter 2020, then return a few days to check the full agenda and confirm attendance on the registration link (note that payment is only required in person at the site).

More details are available at:

Registration desk at Penn State Great Valley Campus Winter 2011 PhilaSUG Meeting

Note that this event has been cancelled due to Corona Virus Concerns.