My current date character value is stored as ddmmmyyyy so I used date9. when changing it to the numeric value. The problem is that when I look at my data set the value for that variable is the SAS date. I tried using "format date date9.;" to convert the SAS date to Date 9. but I am getting the following error message: ERROR 48-59: The format $DATE was not found or could not be loaded. What am I doing wrong? Thanks.   My code: format date date9.; datel=input(date,date9.); totday=intck('day',daterand,date);     example of data:  Date                   Subject #                Visit #           Randomization date 01May1996            1                           1                        15Jan1996 25July1996             1                           2                        15Jan1996 15Aug1995             2                          1                          20Mar1995 ... View more

I have little experience with handling survey data with this many questions and that requires manipulation.  I have survey data with 38 questions and the responses are recorded in the dataset as Not at all, A little bit, Somewhat, Quite a bit,  and Very much.  I am trying to convert the responses to numeric scores so they can be summed up.  I would like the recode to be Not at all=0, A little bit=1, Somewhat=2, Quite a bit=3 and Very much=4. My Q1-38 are a numbered range so I would think I should be able to use the range during recoding.    I am trying to avoid typing Q1-Q38 individually in an if then else statement.  I saw the "of" statement and thought it may be useful but it seems that the scenarios I have seen it used in are for mathematical operations.   Current format of the data: patient ID VISIT Q1                  Q2             Q3             Q4               Q5....             Q38 1                1       somewhat     very much   a little bit   somewhat   quite a bit....   very much 1                2       a little bit     somewhat   very much   somewhat   quite a bit....   a little bit . . . 450   I would like it to be: patient ID VISIT Q1                  Q2             Q3             Q4               Q5....             Q38 1                1       2                     4                1                 2                3....                4 1                2       1                     2                4                2                 3...                 1 . . . . 450   Does anyone have any suggestions on how I can handle this recoding? I am using SAS 9.4.  Please let me know if any additional information is needed.   Thanks. ... View more