Hi All,   I have a data set of patient visits. We want to extract only the patients who have at least 2 visits. How do I do this?   Have: id      visit# a         1 a         2 a         3 a         4 b         1 c         1 c         2 c         3 d         1   The data set I want would only include ids a and c.   Thanks!   ... View more

  Posts: 97   Creating a counter for hospitaliz ations [ New ]   2 seconds ago Hi All,   I have a large claims dataset where patients had a number of procedures on the same and different hospitalizations. I want to create a counter that counts the number of hospitalizations for each patient. This is easy to do if each row represents a different hospitalization, but many patients have several rows for the same hospitalization. How do I create this type of counter? The counter varaible Hospital_count is what I want to create in the data set below:   Want: Patient      Hospital_admission_date   Procedure_code     Hospital_count 1               01/01/1999                         1.1                          1         1               01/01/1999                         2.5                          1 1               02/01/1999                         2.3                          2 1               02/01/1999                         1.5                          2 2               01/01/1999                         2.2                          1 2               01/03/1999                         1.5                          2 ... View more

Hi All,   I need to import an excel sheet that has the field names in the second row and the data begins in the 3rd. Further, I need to import only a certain range. The following code gives me an error if I use the range: PROC IMPORT OUT = NEW                DATAFILE= "F:\data.xls"               DBMS=XLS REPLACE;               SHEET="Data";             RANGE="A2:GF332";             NAMEROW=2;             DATAROW=3;             GETNAMES=YES;    RUN;   If I use the .XLSX format file I can use the range option, but not the NAMEROW option. How do I get both?   Thanks, Sarah ... View more

Hi All,   I need help with some code using either if, then, else, or an array.   I have a data set with many medication fields (wide data set). They are labeled medication1-medication29. I want to create a new variable called "code" that is equal to 1, if any of the 29 medications = 258. Then if medications =225 or 265 then code =2.   Here is some sample code I was playing with: if (medication1 or medication2 or medication3 or medication4 or medication5...medication29)=258 then code=1; else if (medication1 or medication2 or medication3 or medication4 or medication5...medication29)=225 or (medication1 or medication2 or medication3 or medication4 or medication5...medication29)=265 then code=2; ...   Thanks! Sarah   ... View more

Hi All, I have two data sets that I want to merge based on the values of one variable in one of the data sets. Below is the Inspector table I have and I want to merge it with the building table. Inspector Table Building #      Inspector #    Inspection_Day_I 22                    1                    1      22                    2                    4 25                    1                    1 25                    2                    1 25                    3                    2 25                    4                    2 25                    5                    3 Building table Building #    Inspection_Day_B    Var1   Var2 22                    1                         S         1       22                    2                         1         0        22                    3                         0         1 22                    4                         1         T 25                    1                         S         0 25                    2                         1         1 25                    3                         S         1 I want to keep only the observations from the Building table from the Days the inspector came. So my final table will look like this: Want Building #      Inspector #    Inspection_Day_I    Inspection_Day_B   Var1  Var2 22                    1                    1                          1                          S     1 22                    2                    4                          4                         1       T 25                    1                    1                          1                         S      0 25                    2                    1                          1                         S      0 25                    3                    2                          2                          1      1    25                    4                    2                          2                          1      1  25                    5                    3                          3                         S       1 All the observations from the Inspection table are used, but only the selected days from the Building table are in the want data set. Rows 2 and 3 from the building data set were not merged with the Inspector table. How do I do this? ... View more

Hi All, I need to take a '.' out of 44 variables: var_1-var_44 and would like to do this with an array. The following code is not working. Can you help me troubleshoot? Data...      length vrn $8.;      array varnew (*) var_1-var_44;              do i=1 to dim(varnew);             vrn=compress(trim(vrn), '.');         end;         drop i; .... run; Thanks. ... View more