Name that Function: Punny Function Names With Multiple MEANings and Why You Do Not Want to be MISSING Out Ben Cochran and Art Carpenter Ben and Art have been abusing semi-colons for so many years that SAS Institute has awarded both of them with negative birthdays. Even bolstered with this esteemed recognition they are only just barely FUNCTIONing. WUSS 2018

Welcome to a presentation on DATA step functions We will prompt you for the name of a function Such as: We are glad that you have ________ to attend this presentation. The CHOOSEN function The CHOOSEN function returns the ith element of a list of numeric values (opposite of the WHICHN function). OK some of these are punnier than others. It may be to your credit to not get the joke each time.

WUSS 2018 3 The Functions are divided into The following categories: Travel and Leisure Walking and Hiking Personal Health and Relationships Personal Hygiene Las Vegas Food Worldly Military

Miscellaneous WUSS 2018 4 Travel and Leisure Question: What function might you get at the beach? Answer: The TAN or ATAN function The TAN function measures the tangent of an angle, while ATAN returns the ArcTangent of an angle (the inverse of the tangent).

WUSS 2018 5 Travel and Leisure Question: When you take a day off work, you are said to be on __________ ! a. b. c. d. WUSS 2018

Answer: VACATION PTO HOLIDAY None of the above 6 Travel and Leisure Question: When you take a day off work, you are said to be on __________ ! Answer: c. HOLIDAY

The HOLIDAY function returns the SAS date value of a specified holiday for a specific year. WUSS 2018 7 Travel and Leisure Question: What function might remind you of Halloweenn? a. b. c.

d. WUSS 2018 Answer: PUMPKINN COSTUMEN MASKN WHICHN 8 Travel and Leisure Question: What function might remind you of Halloweenn?

Answer: d. WHICHN The WHICHN function searches for a numeric value that is equal to the first argument, and returns the index of the first matching value. WUSS 2018 9 Travel and Leisure Question: When on vacation, what might you want to do late into the morning?

Answer: a. b. c. d. WUSS 2018 SNOOZE NoneOfYourBusiness SLEEP CHOWDOWN 10 Travel and Leisure

Question: When on vacation, what might you want to do late into the morning? Answer: c. SLEEP The SLEEP function suspends the execution of a program that invokes this function for a period of time. WUSS 2018 11 Travel and Leisure

Question: To get to know someone special, you could go on a __________. Answer: The DATE function The DATE function returns the current date as a SAS date value and is just like the TODAY function. WUSS 2018 12 Travel and Leisure Question:

On a date you might go to see this movie: __________ Private Ryan. Answer: The SAVING function The SAVING function returns the future value of a periodic saving. WUSS 2018 13 Travel and Leisure Question: Which function will remind you to fill your

car up with gas? Answer: The ARCOS function The ARCOS function returns the value of the arccosine of an angle. WUSS 2018 14 Travel and Leisure Question: What function might give you a place

to rest? Answer: The COT function The COT function is in the trigonometric category and returns the cotangent. WUSS 2018 15 Travel and Leisure Question: What function is a favorite of a golden retriever?

Answer: a. b. c. d. WUSS 2018 SNOOZE SQUIRREL STICK FETCH 16 Travel and Leisure

Question: What function is a favorite of a golden retriever? Answer: d. FETCH The FETCH function reads the next non-deleted observation from a SAS data set into the Data Set Data Vector. WUSS 2018 17 Travel and Leisure

Question: What function is the least favorite of a golden retriever? Answer: The CAT function The CAT function returns a concatenated character string without removing leading or trailing blanks. WUSS 2018 18 Travel and Leisure Question:

What function do you use to pack away your extra linens? Answer: a. b. c. d. WUSS 2018 CLOSET TRUNC All of the above None of the above 19

Travel and Leisure Question: What function do you use to pack away your extra linens? Answer: b. TRUNC The TRUNC function truncates a numeric value to a specified number of bytes. WUSS 2018 20

Travel and Leisure Question: What function could help you pack your suitcase? a. b. c. d. WUSS 2018 Answer: COMPRESS SitOnIt PushItDown

TRIM 21 Travel and Leisure Question: What function could help you pack your suitcase? Answer: a. COMPRESS The COMPRESS function returns a character string with specified characters removed (by default) from the original string. WUSS 2018

22 Travel and Leisure Question: What function did the fisherman lie about? Answer: The LENGTH function The LENGTH function returns the length of the value of a character variable. WUSS 2018

23 Travel and Leisure Question: What function helps to lower the level of light? Answer: The DIM function The DIM function returns the number of elements in an array. WUSS 2018 24

Travel and Leisure Question: The movie was terrible; it was such a __________. Answer: The BOR function The BOR function returns the bitwise logical OR of two arguments. WUSS 2018 25

Travel and Leisure Question: Which function reminds us of the play Arsenic and Old Lace? Answer: The POISSON function The POISSON function returns the probability that an observation is from a Poisson distribution WUSS 2018 26 Walking and Hiking

WUSS 2018 27 Walking and Hiking Question: When hiking in woods, you should remember this function. Answer: The PATHNAME function The PATHNAME function returns the physical name of an external file or a SAS library.

WUSS 2018 28 Talking and Hiking Question: What function tends to fall behind on a walk? Answer: a. b. c. d. WUSS 2018

LAG SLOW SNAIL BarelyMoving 29 Talking and Hiking Question: What function tends to fall behind on a walk? Answer: a. LAG The LAG function returns values from a queue.

WUSS 2018 30 Walking and Hiking Question: What function reminds us of a fallen tree? Answer: The LOG function The LOG function returns the natural (base e) logarithm.

WUSS 2018 31 Personal Health And Relationships WUSS 2018 32 Personal Health and Relationships Question:

What function is a goal of a good psychologist? Answer: The NORMAL function The NORMAL function returns a random variate from a normal distribution. WUSS 2018 33 Personal Health and Relationships Question: What function does the psychologist

guard against? Answer: The DEVIANCE function The DEVIANCE function returns the deviance based on a probability distribution. WUSS 2018 34 Personal Health and Relationships Question: One goal of couples therapy is to do this to marital issues.

Answer: The RESOLVE function The RESOLVE function returns the resolved value of the argument after the argument has been processed by the macro facility. WUSS 2018 35 Personal Health and Relationships Question: The husband was ______ and it made the wife ______.

Answer: The MEAN and MAD functions The MEAN function calculates the arithmetic average. The MAD function returns the median absolute deviation from the median. WUSS 2018 36 Personal Health and Relationships Question: After the divorce the ex-wife did this.

a. b. c. d. WUSS 2018 Answer: REMARRIED MovedAway RENAMEd All of above 37 Personal Health and Relationships

Question: After the divorce the ex-wife did this. Answer: c. RENAMEd The RENAME function renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory. WUSS 2018 38 Personal Health and Relationships

Question: What your mother always said: _______ I said so. Answer: The COS function The COS function is a trigonometric function that returns the cosine. WUSS 2018 39 Personal Health and Relationships

Question: Trust but ______ . Answer: The VERIFY function The VERIFY function returns the position of the first character in a string that is not in any of several other strings. WUSS 2018 40 Personal Health and Relationships Shakespeare wrote:

Shall I ______ thee to a summers day? Answer: The COMPARE function The COMPARE function returns the position of the left most character by which two strings differ. WUSS 2018 41 Personal Health and Relationships A Shakespeare misquote might read: To be or to ______ that is the question.

Answer: The BNOT function The BNOT function returns the bitwise logical NOT of the argument (if only Shakespeare had known that!). WUSS 2018 42 Personal Hygiene and Health WUSS 2018 43

Personal Hygiene and Health Question: What function will help you fix your hair? Answer: a. b. c. d. WUSS 2018 BRUSH COMB SPRAY

PICK 44 Personal Hygiene and Health Question: What function will help you fix your hair? Answer: b. COMB The COMB function computes the number of combinations of n elements taken r at a time. WUSS 2018

45 Personal Hygiene and Health Question: Be sure to shave daily to remove the ______ . Answer: The FUZZ function The FUZZ function returns the nearest integer if the argument is within 1E-12 of that integer. WUSS 2018 46

Personal Hygiene and Health Question: You may not need a haircut, but at least get a ______. Answer: The TRIM function The TRIM function trims all trailing blanks from a character string. WUSS 2018 47

Personal Hygiene and Health Question: The person went to the hairdresser to get a ______. Answer: The PERM function The PERM function computes the number of permutations of n items that are taken r at a time. WUSS 2018 48 Personal Hygiene and Health

Question: What function could be overcome by going to the gym? Answer: The WEEK function The WEEK function reads a SAS date value and returns the number of elapsed weeks within the calendar year of the SAS date value. WUSS 2018 49 Personal Hygiene and Health

Question: What function is built up (improved) by going to the gym? Answer: The ABS function The ABS function returns the absolute (nonnegative) value that is equal in magnitude to the argument. WUSS 2018 50 Personal Hygiene and Health Question:

After working out at the gym regularly, what do people say about you? Answer: The SUMABS function The SUMABS function returns the sum of the absolute values of the non-missing arguments. WUSS 2018 51 Personal Hygiene and Health Question: If you do not bathe regularly, what

function might you smell like? Answer: a. b. c. d. WUSS 2018 STRONG RANK BO RANUNI 52

Personal Hygiene and Health Question: If you do not bathe regularly, what function might you smell like? Answer: b. RANK Returns the position of a character in the ASCII or EBCDIC collating sequence. WUSS 2018 53

Las Vegas WUSS 2018 54 Las Vegas Question: The nickname for Las Vegas contains this function name. Answer: The SIN function (Sin City) The SIN function returns the SINE, which is a trigonometric function of an angle.

WUSS 2018 55 The SIN and COS Function You can use the SIN and COS functions to draw things. No, but you will be able to program circles around the other programmers!

Will mastering these functions increase your marketability and make you a better SAS programmer ? Will mastering these functions help you to pass a certification exam? WUSS 2018 56 Las Vegas Question: What is a function that you do NOT want to catch in Las Vegas (or anywhere). Answer: The STD function Use the STD function to calculate the standard

deviation of a list of values. WUSS 2018 57 Las Vegas Question: What type of show should you avoid? Answer: The PEEK function Different than a peep show, the PEEK function stores the contents of a memory address into a numeric variable.

WUSS 2018 58 Las Vegas Question: All the big casinos are on the __________. Answer: The STRIP function The STRIP function removes leading and trailing blanks.

WUSS 2018 59 Food WUSS 2018 60 Food Question: Where do the milk cows call home? Answer:

The DAIRY function Returns the derivative of the AIRY function. Which reminds us of the valley girl who was such an AIRY head. WUSS 2018 61 Food Question: Where do beef cattle call home? Answer: The RANGE function Returns the difference between the largest and

smallest values. WUSS 2018 62 Food Question: Eat your food one of these at a time. Answer: The BYTE function Returns the ASCII or EBCDIC code given a decimal value.

WUSS 2018 63 Food Question: What function helps us put the plates on the dinner table. Answer: The SET Function The CALL SET routine links data set and macro variables and allows the user to create a large number of macro variables based on the values in a data set.

WUSS 2018 64 Worldly WUSS 2018 65 Worldly Question: What SAS function is the favorite

of the Russian president? This function is also rumored to be the favorite of: Answer: The PUTN Function Similar to the PUT function, but PUTN allows you to specify a numeric format at execution time. WUSS 2018 66 Worldly

Question: What SAS function reminds us of Mike Pompeo? ( The ___ of State). Answer: The SEC Function The SEC function returns the secant, which is the inverse of the cosine. WUSS 2018 67

Worldly Question: Use this function to communicate in another language. Answer: The TRANSLATE function The TRANSLATE function converts characters values within a character string. WUSS 2018 68 Worldly

Question: What functions help us deal with contracts? Answer: You can CLOSE negotiations and CIEL the deal. The CLOSE function closes a SAS data set and the CEIL function truncates to the next larger integer. WUSS 2018 69 Worldly Question: Those who do not study history are

doomed to _________ it. Answer: The REPEAT function Generates a string of repeated characters. Generates a string of repeated characters. Generates a string of repeated characters. Generates a string of repeated characters. Generates a string of repeated characters. Generates a string of repeated characters. WUSS 2018 70 Military

WUSS 2018 71 Military Question: The marine wore this function with pride. Answer: The UNIFORM function Returns a random variate from a uniform distribution. Same as the RANUNI function.

WUSS 2018 72 Military Question: The colonel had more of this than the lieutenant. Answer: The RANK function Not the same as a bad odor, this function returns the collating sequence ranking. Lower numbers sort first.

WUSS 2018 73 Military Question: This was John Philip Sousas favorite function. Answer: The BAND function The BAND function returns the bitwise logical AND of two arguments. WUSS 2018

74 Military Question: The ancient Romans used this military tactic, _______ and conquer. Answer: The DIVIDE function Perform division by using the DIVIDE function, which protects the user from division by zero. WUSS 2018

75 Miscellaneous WUSS 2018 76 Miscellaneous Question: What function should you not fear? Answer: The DREAD function Read the names of members within a

directory using the D-READ function. Not to be confused with dreadlocks. WUSS 2018 77 Miscellaneous Question: What function contains no fiction? Answer: The FACT function Calculate the factorial of a number using the FACT function.

WUSS 2018 78 Miscellaneous Question: What function helps us recover lost objects? Answer: The FIND function Similar to INDEX, the FIND function allows you to search for characters within a text string.

WUSS 2018 79 Miscellaneous Question: What function helps you lay down new carpet? Answer: The FLOOR function You can truncate a number down to the next lowest integer using the FLOOR function. WUSS 2018

80 Miscellaneous Question: What function could remind you of Dracula? Answer: The COUNT function This function COUNTs the number of times a text sub-string appears within a text string. WUSS 2018

81 Miscellaneous Question: What function helps you sell stocks and bonds? Answer: The SEC function The SEC function returns the secant of an angle, which is the inverse of the cosine (COS). WUSS 2018

82 Miscellaneous Question: Did you know that criminals cannot sink __________? Answer: The ANYLOWER function The ANYLOWER function returns the position of the first lower case letter. WUSS 2018 83

Miscellaneous Question: What function helps you start a fire? Answer: The ARSIN function The ARSIN function returns the arcsine of an angle, which is the inverse of the sine (SIN). Dont do this at home its a crime! WUSS 2018 84

Miscellaneous Question: When purchasing an item never buy a pig in a ______. Answer: The POKE function The CALL POKE routine writes a value directly to memory. WUSS 2018 85 Miscellaneous

Question: What function do you use when scrubbing the internet? Answer: The SOAPWEB function The SOAPWEB function calls a Web service by using basic Web authentication. WUSS 2018 86 Miscellaneous Question:

What function do you use when you want to destroy something? Answer: The DCREATE function The DCREATE function creates directories. WUSS 2018 87 Miscellaneous Question: What function determines the gold metal winner?

Answer: The FIRST function The FIRST function returns the first character in a string. The SECOND function determines the silver medal, and the NOTFIRST function is a disappointment. WUSS 2018 88 Miscellaneous Question: What function determines the

gold metal winner? Answer: The FIRST function And the REVERSE of the FIRST function is _______. The LAST function in this presentation! WUSS 2018 89 Miscellaneous Question: What function determines the Wait there

is no LAST function! gold metal winner? Will this talk never end? Answer: What function will end this talk? The FIRST function We need a stop ________! And the REVERSE of the FIRST function is _______. The LAST function in this presentation! The SIGN function returns the sign of a value.

WUSS 2018 90 WUSS 2018 SUMMARY With over 450 DATA step functions there is a lot to learn

Knowing your functions can yield SAVINGS in programming effort Take NOTE, you dont want to be MISSING out ANY questions? 91 Name that Function: Punny Function Names With Multiple MEANings and Why You Do Not Want to be MISSING Out Ben Cochran The Bedford Group 3224 Bedford Avenue Raleigh, NC 27607

Art Carpenter CA Occidental Consultants 10606 Ketch Circle Anchorage, AK 99515 Work Phone: 919.741.0370 Email: [email protected] (907) 865-9167 [email protected] Continue the Discussion on sasCommunity.org

WUSS 2018