book

PROC FCMP User-Defined Functions

Name: PROC FCMP User-Defined Functions
Author: Troy Martin Hughes
ISBN: 9781685800284

by Troy Martin Hughes

April 2024

Intermediate to advanced

344 pages

9h 14m

English

SAS Institute

Read now

Unlock full access

About This Book
About the Author
Acknowledgments
Chapter 1: Introducing Functions
What Is a Function Anyway?Functions Versus FunctionalityThe Many Facets of Software Quality and PerformanceSoftware ModularitySoftware ReadabilitySoftware ConfigurabilitySoftware ReusabilitySoftware MaintainabilitySoftware IntegrityFunctional Components and OrganizationFunction SpecificationFunction ImplementationFunction InvocationFunction NomenclatureCalling Module, Callable Module, and Called ModuleFunctions Versus ProceduresFunctions Versus SubroutinesParameters Versus ArgumentsReturn Values Versus Return CodesBuilt-in Functions Versus User-Defined FunctionsConclusion
Chapter 2: Basic FCMP Syntax
PROC FCMP WrapperPROC FCMP StatementPROC FCMP OUTLIB OptionConfiguring the CMPLIB System OptionENCRYPT OptionTerminating PROC FCMP: QUIT Versus RUNFunction Declaration and SignatureFunction NamingDeclaring ParametersDeclaring Zero ParametersSpecifying Parameter Call Method Using the OUTARGS StatementThe VARARGS OptionDeclaring a Return ValueDifferences between DATA Step and FCMP SyntaxUse Caution When Modifying Call-by-Value Scalar ParametersDO Loop DifferencesFILE LOG Statement to Direct SAS Output to SAS LogPUT Statement DifferencesUsing Optional Arguments in Built-in Functions Called inside PROC FCMPConcluding a Function or SubroutineThe RETURN StatementENDFUNC and ENDSUB StatementsConclusion
Chapter 3: Arrays
Arrays in the DATA StepDATA Step Array DeclarationDATA Step Array InitializationPassing an Array to a FunctionPassing Multi-Element Arguments to a Built-in FunctionPassing an Array to a User-Defined FunctionDeclaring an Array inside a FunctionDeclaring a Numeric Array to Calculate Median Word LengthDeclaring a Numeric Array to Make Change“Returning” an Array from a FunctionPassing a One-Dimensional Array by ReferencePassing a Two-Dimensional Array by ReferenceExtending the Functionality of SORTC to a Descending SortDifferences between DATA Step Arrays and FCMP ArraysThe DO OVER Statement Is Not Supported by FCMPFCMP Arrays Do Not Support the IN OperatorFCMP Arrays Do Not Support the OF OperatorArrays Cannot Be Declared in Reverse within FCMPLeft-Handed SUBSTR Functionality Incompatible with Arrays%SYSFUNC and %SYSCALL Complexities with ArraysPerforming Matrix Calculations Using PROC FCMP ArraysLinear Algebra Problem SetLong-Hand SolutionSAS/IML SolutionPROC FCMP SolutionUsing READ_ARRAY to Read a Matrix from a Data SetUsing WRITE_ARRAY to Write a Matrix to a Data SetConclusion
Chapter 4: Hash Objects
Data ValidationValidation Using the PROC FORMAT CNTLIN OptionValidation Using a DATA Step Hash ObjectValidation Using an FCMP Hash ObjectSingle Variable InitializationData Initialization Using a User-Defined FormatData Initialization Using a User-Defined Function Hash ObjectMultivariable InitializationA Procedural Approach to Multivariable InitializationA Functional Approach to Multivariable InitializationCounting Hash KeysCounting Keys Using a Running CountCounting Keys with a Post Hoc Hash IteratorSorting Hash KeysBuilding Dynamic Hash Using the SAS Macro LanguageStatically Defining a Hash Lookup OperationDynamically Defining a Hash Lookup OperationConclusion
Chapter 5: RUN_MACRO and RUN_SASFILE
Introducing the RUN_MACRO FunctionImplementing the DEQUOTE Function to Remove Automatic QuotingCautious Declaration of Macro Parameters When Calling Macro via RUN_MACROGenerating a Return Value from a RUN_MACRO MacroReuse of Variable Names with RUN_MACROScope Considerations for RUN_MACRO Macro VariablesGlobal Macro Variable Interaction with RUN_MACROPassing Special Characters Using RUN_MACRORunning DATA Steps and SAS Procedures via RUN_MACROExecuting a SAS Procedure inside a DATA StepExecuting a DATA Step inside a DATA StepComparison of RUN_MACRO to DOSUBL FunctionRUN_SASFILELeveraging RUN_MACRO to Overcome FCMP LimitationsConclusion
Chapter 6: Getters and Setters
A Business Case for Evaluating Nutritional DataGET_CAL Getter to Retrieve Caloric ContentDATA Step Setter to Initialize Caloric ContentFCMP Procedure Setter to Initialize Caloric ContentFCMP Procedure Setter to Initialize and Add Caloric ContentDifferentiating Attributes in Getter FunctionsDifferentiating Attributes in Setter FunctionsDifferentiating Data Types in Getter FunctionsDifferentiating Data Types in Setter FunctionsConclusion
Chapter 7: Recursion and Memoization
Introducing the FCMP STATIC StatementUsing STATIC to Count Function CallsCalling STATIC Functions and Subroutines Using %SYSFUNC and %SYSCALLRecursionCalculating a FactorialMaking Change RecursivelyMaking Change Recursively with STATICMaking Change Recursively without STATIC or a Counter VariableMemoization—No That’s Not a Spelling Error!The STATIC Statement Supporting MemoizationThe Hash Object Supporting MemoizationThe Dictionary Object Supporting MemoizationConclusion

Chapter 8: Python Component Object
Requirements and SetupDefining a Python Function inside a Python Program FileImporting a Python Program File in the FCMP ProcedureUsing the INFILE Method to Import a Python Program FileUsing the SUBMIT INTO Statement to Import a Python Program FileDefining a Python Function inside the FCMP ProcedureCreating KML Files Using PROC FCMP and Python GeocodingScenario Setup, Requirements, and Data IngestionCreating a PROC FCMP Wrapper to Invoke Python GeocodingGeocoding in Python Using the Google Maps APICalculating Latitude and Longitude Coordinates in SASCreating a PROC FCMP Wrapper to Invoke Python Distance CalculationsCalculating Distance in Python Using the Google Maps APICalculating Coordinates and Calculating Distances in SASIntroducing Memoization for GeocodingIntroducing Memoization for Distance CalculationsCreating a KML File for Las Vegas RestaurantsConclusion
Chapter 9: Expanding the Application of Functions
User-Defined Functions Applied as Formats and InformatsLimitations of Functions Called by PROC FORMATUser-Defined Format Calling a User-Defined FunctionUser-Defined Function and Format PerformanceMore User-Defined Function and Format PerformanceUser-Defined Informat Calling a User-Defined FunctionDesigning a User-Defined Informat to Validate Roman NumeralsDesigning a User-Defined Informat That Throws ExceptionsDesigning a User-Defined Informat That Evaluates Complex Business RulesApplying User-Defined Functions in PROC REPORTCreating a Basic HTML ReportAdding Getter Functionality to Support Dynamically Color-Coded ReportDifferentiating Report Color-Coding Based on Subroutine Business RulesAdding More Getter Functionality to Query a Lookup TableConclusion
References
Index

Content preview from PROC FCMP User-Defined Functions

Chapter 9: Expanding the Application of Functions

Whereas the first chapter introduced functions and function nomenclature, and other chapters described and demonstrated function design and development, this chapter stands alone in focusing on function invocation. Thus far, myriad examples have demonstrated calling functions and subroutines from the DATA step, as well as calling functions via the %SYSFUNC function and subroutines via the %SYSCALL statement. User-defined functions have also been called from the SQL procedure and the FCMP procedure. This chapter demonstrates two final methods of invoking user-defined functions—using the OTHER option of the FORMAT procedure and inside the COMPUTE block of the REPORT procedure.

SAS formats and informats ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Segmentation and Lifetime Value Models Using SAS

Publisher Resources

ISBN: 9781685800284

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

PROC FCMP User-Defined Functions

by Troy Martin Hughes

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.