Hi everyone, I am trying to read a txt file into SAS using the infile statement. The data look like this: Var1      Var2          Var3 "John" , "Smith",      4.3 "Bob",    "Jones" ,    5.2 "Sarah",  "Johnson"  ,  . I am using the following code: data newdata; infile 'filelocation.txt' dsd missover; input var1 $ var2 $ var3; run; The problem is that I am getting error messages for instances where Var3 is missing (missing values are noted with a period). Any help is much appreciated. Thanks! ... View more

I have a dataset composed of a number of events. Each row represents one event for one person as follows: ID       Event         Eventdate a         xyz            04/2012 b         xyz            05/2013 a         efg             08/2012 b         xyz            09/2012 What I'd like to do is look at a person's sequence of events. I was thinking I would transpose the data like this: proc transpose data=data out=new; by id; id event; var eventdate; run; That way, each person will have a sequence of dates and I will know which event is which. My question is what will happen if the same person has the same event twice, and if there's a way to tweak my code to avoid losing data. I'm also open to suggestions on non-proc transpose ways to establish a sequence of events for each person. Help is much appreciated. ... View more

Hi everyone, I have a pretty complex dataset  that looks like this: ID      Date1        Event1        Date2      Event2     1       4/5/13          a             7/4/13          r               2       5/12/13        b             8/5/13          x                   1       4/5/13          a            10/9/13         g            3       7/7/12          a             5/5/13         m            2      12/5/11          c            9/5/13          r              Basically, each time a person experiences Event1 (corresponding to Date1), it generates a row. A person can experience multiple Event1s and thus generate multiple rows (eg ID 2 in the above example). The row also includes the date and type of event2 for that person. If a person has more than one Event2, it will generate another row for each Event1 (eg ID 1 in the example above). What I want is to transpose this dataset so that it looks like this: ID      Date1        Event1        DateR      DateX        DateG     DateM         1       4/5/13          a             7/4/13          --            10/9/13       --                  2       5/12/13        b             9/5/13        8/5/13          --             --                                  3       7/7/12          a                --              --               --          5/5/13                  2      12/5/11          c            9/5/13        8/5/13           --              --                        The ultimate goal is to know how many people experienced events of each kind, and how long after the initial event. The problem is that if I transpose using the original Event2 variable as the id variable, there are repeats and I'm not sure if/how that will work. Any help is much appreciated! ... View more