PROC-X.com

When creating a new data item, you might want to combine two or more data fields to make one.  For instance, you want to create the data item Full Name from First Name and Last Name data items. Using the SAS CAT functions makes this is an easy task. There are three CAT functions available from the Expression Editor.  Each of these functions has a slight difference that is useful in various situations. For this example, you will learn how to use the CATX functions to create the Full name data item in three different ways: Employee Name is the First Name and Last Name Employee is the Last Name, First Name Employee Code uses the Employee Number and Last Name The CATX function does 3 things: Concatenates two or more data items Removes the white space at end of the character value Allows you to set a delimiter (comma, space, and so on) between the data items Create Employee Name For this data item, you want a space between the first name and last name.  When adding the code place a space between the quote marks. Create Employee For this data item, you want a comma between the last and […]

Read more →