Hello,    I am having trouble with this basic if then statement. I am trying to sort the table into 4 different categories but when I run this piece of code the whole capacity_label column has 4s in it even though not all the capacity variables are <25. Do I need to change my syntax?    Thank you.    data in_capacity2; set in_capacity; if Capacity > 80 then Capacity_label=1; if 50 >Capacity > 79 then Capacity_label=2; if 25 >Capacity > 49 then Capacity_label=3; if Capacity <25 then Capacity_label=4; run; ... View more

Hello,    I am trying to export a sas table to excel but I want the columns labels to be printed instead of the column names. Does anyone know how to do this? ... View more

Hello,    I am trying to extract the month from a date value that looks like this    Date1 20080201 20080301 20080401   and I want to create a new variable that is    Date2 02 03 04    So i tried using  Date2=SUBSTR(Date1, 5, 2);   But it did not work. Can you help?     ... View more

Hello,    I am wondering if it is possible to use the where or if statements to select certain observations that have a lot of text in them. For instance consider the following example table:   Description                                                                                                                Count  17-Hydroxypregnenolone (Hormone) Level                                                                 11 3d Radiographic Procedure                                                                                          62 3d Radiographic Procedure With Computerized Image Postprocessing                      31 Abdominal Removal Of Uterus Cervix And Lymph Nodes                                            28 Procedure for Abdominal Pain                                                                                      57   And if I only wanted to keep the observations that contained "procedure" somewhere in the title, how would I do that?    Thank you.    ... View more

Hello,    I am trying to create sums by group and create a new variable that is a count of all the observations with the same ID number. See sample data set below:    ID    X      Y 1    10     15 1    7       19 1    13      11 2    10     15 2    11    17 3    35    21 3    12    8 3     11    7 I want the total aggregate sums of X and Y for each ID group, and a new variable that is a count of all the entries for each ID number (for example count for ID 1 would be 3, ID 2=2, ID 3= 3)   Thank you! ... View more

Hello,    I am trying to create a table of the sum of observations by grouping. For instance, consider the following data table:    ID    X     Y 1    10     15 1    7       19 2    10     15 2    11    17 2    35    21   I want the total aggregate sums of X and Y for each ID group.    Thank you! ... View more

Hello,    I am trying to create a macro variable to add a new column. There are 15 primary columns (primary1-primary15) and i want to make a new variable called "Code" that has "tax-" and then the same number as in the primary variable. See example:   if primary1= "Y" then Code=tax1; if primary2= "Y" then Code=tax2; if primary3= "Y" then Code=tax3; ... up until if primary15="Y" then  Code=tax15   Can someone help me please? ... View more

Hello,    I am trying to create new date variables that are 1) 9 months before and 2) 3 months after a certain date variable.    For example, if I had a variable called date1 with date in the format of mm/dd/yyyy, and I wanted two new date functions, date2 and date3, where date2=date1-9months and date3=date1+3months how would I do this using the INTNX function?    Thank you! ... View more

I am trying to edit a table down by selecting only the observations with certain entries. I want a table where the only observations are the ones where the variable CODE is equal to 59400, 59410, 59510, 59515, or 59610 .   Here is the code:      DATA want; SET have; if CODE =  59400 59410 59510 59515 59610 then keep ; run;   But for some reason I keep getting a table with 0 observations. Does anyone know why this is?   ... View more