Join us for our NEXT MEETING- a FREE webinar!
Date: Thursday, December 7
Time: Noon - 1:00 PM ET
Place: Online
Cost: Free- but please register by Tuesday, December 5. The webinar link will be sent out to all registered attendees by Wednesday, December 6.
Register Now!
Time: Noon - 1:00 PM ET
Place: Online
Cost: Free- but please register by Tuesday, December 5. The webinar link will be sent out to all registered attendees by Wednesday, December 6.
Register Now!
Agenda
sometimes referred to as “horizontal sorts” because they sort variables rather than observations. That is,
all elements within a SORTC or SORTN sort must be maintained in a single observation. A limitation of
SORTC and SORTN is their inability to sort more than 800 variables when called inside the FCMP
procedure. To overcome this disagreeable, arbitrary threshold, user-defined subroutines can be engineered
that leverage the hash object to sort limitless variables. The hash object orders values that are ingested
into it using the ORDERED argument, which can specify either ASCENDING or DESCENDING. This text
demonstrates three failure patterns that occur when the OF operator specifies an array inside the FCMP
procedure, which affect both character and numeric arrays, and which cause all built-in functions and
subroutines to fail with runtime errors.
savory, salty, sometimes spicy delicacy! Thus, when reviewing a data set that contains potential tikka
masala ingredients, an initial data quality evaluation should differentiate approved from unapproved
ingredients. Cumin, yes please; chicken, the more meat the merrier; coriander, of course; turmeric,
naturally; yeast, are you out of your naan-loving mind?! Too often, SAS® practitioners first ingest a data
set in one DATA step, and rely on subsequent DATA steps to clean, standardize, and format those data.
This text demonstrates how user-defined informats can be designed to ingest, validate, clean, and
standardize data in a single DATA step. Moreover, it demonstrates how the FORMAT procedure can
leverage the OTHER option to create a user-defined informat that calls a user-defined FCMP function to
perform complex data evaluation and transformation while simulating _ERROR_ variable functionality.
Control what you put inside your tikka masala with this straightforward solution that epitomizes data-driven
software design while leveraging the flexibility of the FORMAT and FCMP procedures!
- Sorting a Bajillion Variables-When SORTC and SORTN Subroutines Have Stopped Satisfying, User-Defined PROC FCMP Subroutines Can Leverage the Hash Object to Reorder Limitless Arrays - Troy Martin Hughes
sometimes referred to as “horizontal sorts” because they sort variables rather than observations. That is,
all elements within a SORTC or SORTN sort must be maintained in a single observation. A limitation of
SORTC and SORTN is their inability to sort more than 800 variables when called inside the FCMP
procedure. To overcome this disagreeable, arbitrary threshold, user-defined subroutines can be engineered
that leverage the hash object to sort limitless variables. The hash object orders values that are ingested
into it using the ORDERED argument, which can specify either ASCENDING or DESCENDING. This text
demonstrates three failure patterns that occur when the OF operator specifies an array inside the FCMP
procedure, which affect both character and numeric arrays, and which cause all built-in functions and
subroutines to fail with runtime errors.
- Make You Holla' Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Facilitate Data Ingestion Data Quality - Troy Martin Hughes
savory, salty, sometimes spicy delicacy! Thus, when reviewing a data set that contains potential tikka
masala ingredients, an initial data quality evaluation should differentiate approved from unapproved
ingredients. Cumin, yes please; chicken, the more meat the merrier; coriander, of course; turmeric,
naturally; yeast, are you out of your naan-loving mind?! Too often, SAS® practitioners first ingest a data
set in one DATA step, and rely on subsequent DATA steps to clean, standardize, and format those data.
This text demonstrates how user-defined informats can be designed to ingest, validate, clean, and
standardize data in a single DATA step. Moreover, it demonstrates how the FORMAT procedure can
leverage the OTHER option to create a user-defined informat that calls a user-defined FCMP function to
perform complex data evaluation and transformation while simulating _ERROR_ variable functionality.
Control what you put inside your tikka masala with this straightforward solution that epitomizes data-driven
software design while leveraging the flexibility of the FORMAT and FCMP procedures!
Next Webinar!
Date: Thursday, January 18
Time: Noon - 1:00 PM ET
Place: Online
Cost: Free- registration will open in early December. Please register in order to receive the webinar link.
Time: Noon - 1:00 PM ET
Place: Online
Cost: Free- registration will open in early December. Please register in order to receive the webinar link.
Agenda
Bob Rodriguez retired from SAS in 2018 after serving as senior director for the development of statistical software. He received his PhD in statistics from the University of North Carolina at Chapel Hill and is a Fellow of the American Statistical Association. The webinar draws from his book, Building Regression Models with SAS: A Guide for Data Scientists, which was published by SAS Press in 2023.
- Getting Started with Building Regression Models for Prediction - Robert N. Rodriguez
Bob Rodriguez retired from SAS in 2018 after serving as senior director for the development of statistical software. He received his PhD in statistics from the University of North Carolina at Chapel Hill and is a Fellow of the American Statistical Association. The webinar draws from his book, Building Regression Models with SAS: A Guide for Data Scientists, which was published by SAS Press in 2023.
We are always looking for speakers for future meetings - please contact us if you are interested in presenting!
We are always looking for speakers for future meetings - please contact us if you are interested in presenting!
If you are interested in speaking at a future MSUG meeting, please contact us at info@misug.org. We also welcome reviews of SAS Press books- please see our Book Review Process.
About Us
Mission Statement
The Michigan SAS Users Group is organized to further the interests of programmers and users of the SAS Software System. Members share information on building applications with SAS Software and how to better use programming tools and user interfaces. MSUG also provides a forum for informing attendees and members of career opportunities.
Newsletter
Members automatically receive email announcements of upcoming meetings, along with a copy of the MSUG newsletter, which is published occasionally. Notes and Notices, users coding tips and tricks and "help wanted" ads are included in the newsletter. See our archive of Newsletters and Past Proceedings.
Membership
There are no membership dues at the moment.If you wish to join MSUG, please go to our mailing list website and add your email address to our distribution list for newsletters and meeting announcements! If you have questions, please contact us.
Advertising/Sponsorship
Download a description of MSUG's sponsorship program. If your company wishes to sponsor an MSUG event, please contact info@misug.org.
The Michigan SAS Users Group is organized to further the interests of programmers and users of the SAS Software System. Members share information on building applications with SAS Software and how to better use programming tools and user interfaces. MSUG also provides a forum for informing attendees and members of career opportunities.
Newsletter
Members automatically receive email announcements of upcoming meetings, along with a copy of the MSUG newsletter, which is published occasionally. Notes and Notices, users coding tips and tricks and "help wanted" ads are included in the newsletter. See our archive of Newsletters and Past Proceedings.
Membership
There are no membership dues at the moment.If you wish to join MSUG, please go to our mailing list website and add your email address to our distribution list for newsletters and meeting announcements! If you have questions, please contact us.
Advertising/Sponsorship
Download a description of MSUG's sponsorship program. If your company wishes to sponsor an MSUG event, please contact info@misug.org.
