For the variables C1-C5 in data set CHARI (problem 18.1), change all lowercase values to uppercase, and set any remaining values other than ‘Y’, ‘N’, or blank to missing. You may wish to use an ARRAY to solve this problem. Problem 18.1 First, create a data set called CHAR1 by running the following DATA step: […]

Run the following DATA step to create a SAS data set called GOOD_BAD. Valid characters in the string ANSWER are ABC. abc, and 0123456789. Note that ANSWER is 40 bytes in length, and you want to ignore trailing blanks (embedded blanks are to be flagged as errors). Write a SAS DATA step to read in

You are given a data set (PHONE) with phone numbers stored in a variety of formats.. Run the following program to create the PHONE data set and create a new variable, NUMBER, that is a numerical variable derived from the character variable CHAR_NUM with all extraneous symbols and blanks removed. Assume that the longest phone

You have two data sets, ONE and TWO, ONE has a variable called ill, which is a character variable in the form 123-45-6789. TWO has a variable called ill, which is numeric (nine digits). You want to merge data sets ONE and TWO by the Il) variables to create a new data set (BOTH) with

The data set (EX PER) created by running the following program contains the variables ID, GROUP, and DOSE. Create two new variables as follows: One is a 2-byte character variable created from the second and third bytes of ID. The other is a variable created by concatenating GROUP and DOSE. T11isvariable should be 6 bytes

You have lines or data containg subject numbers (SUBJ) and weights (WEIGHT). The weight values are either in kilograms, in which case they are followed by kg (in upper- or lowercase, with or without a period). Weights in pounds either have nothing following the number or Ibs. (again, in upper- or lowercase, with or without

Using the data set EXPER from problem 18.9, create a new variable (lD2) from ID. Make this new variable 6 bytes in length and place an asterisk in the sixth byte if the fourth byte of TD has a value of 5 or more. To solve this problem, create a numeric variable based on the

(3) Write a SAS program to read the following lines of data. You want this data set to contain a variable called NUMBER, which is a two-digit number following the first occurrence of the string ‘XYZ’ in each of the lines. For example, in line 1,the value of NUMBER is 78; in line 2, it

Merge the two data sets created by running the following program using the GENDER. date of birth (DOB), and the SOUNDEX equivalent of the NAME to determine matches. Keep only those observations where a match is successful. Call the new data set COMBINED. There should be three observations in data set COMBINED.

Run the following program to create the SAS data set VERSE. The variable LONG_STRING contains several words separated by blanks or blanks and commas. Count how many times the word ‘the’ appears in each line. Ignore case. First do this by breaking LONG_STRING into words and testing each word (do this in a loop-exit the