Hi,    I have dataset that looks like this:    Locker ID Locations Person A Person B Person C Person A Code Person B Code Person C Code 101 Hampersmith, Silvershine Sam Copewell Amy Baker John Aston 123A 234B 345C 102 Coleridge, Brisbake Claude Tremaine Marissa Carter   567D 678E   103 Waterloop, Sturrey Brian Amble Charlie Springwater Mandy Smith 012G 134H 245J   I want to split this data set into multiple rows by the persons like so:   Locker ID Locations Person Person Code 101 Hampersmith, Silvershine Sam Copewell 123A 101  Hampersmith, Silvershine Amy Baker 234B 101 Hampersmith, Silvershine John Aston 345C 102 Coleridge, Brisbake Claude Tremaine 567D 102 Coleridge, Brisbake Marissa Carter 678E 103 Waterloop, Sturrey Brian Amble 012G 103 Waterloop, Sturrey Charlie Springwater 134H 103 Waterloop, Sturrey Mandy Smith 245J   Please can you help, all numbers/letters are just placeholders so avoiding code that specifies any of that.   Appreciate your help! ... View more

Hi guys,   Need some help with this please!   If I have the following data    User ID Dates 23576 08/10/1998 23576 08/11/1998 23576 08/12/2000 23576 09/10/1998 85028 07/09/1976 85028 07/10/1967 85028 10/07/1967 13857 19/03/2001 13857 18/03/2001   What I want is all possible pairs of the dates associated with that user ID.    So for ID 23576 I would want table like this: User ID Date A Date B 23576 08/10/1998 08/11/1998 23576 08/10/1998 08/12/2000 23576 08/10/1998 09/10/1998 23576 08/11/1998 08/12/2000 23576 08/11/1998  09/10/1998 23576 08/12/2000 09/10/1998   Hope that makes sense.   Thank you so much! ... View more

Hi Guys!   Quick question on merging and joining datasets: If I have two datasets and if they both have a matching obs (by a certain key), how can i output both observations from each dataset into my output dataset please?   ... View more

Hi Guys,   Need some help please!    I am trying to import a .dat file into SAS using infile.    The data is pipe(|) delimited. However some of the data is like the following: a|b|c|d|"Mr John|Smith"|e|f|. As you can see the delimiter is embedded in between two data columns but in between double quotes (there are some with single quotes too). How can I get around this so that the delimiter is recognised and the data is imported correctly?    Example of my data step:   data library.file;         infile "filepath" DLM = '|' DSD MISSOVER firstobs=3;         format         var1 $99.         var2 $99.         var3 $99.         var4 $99.         firstname  $99.         surname $99.         var5  $99.         var6  $99.         ;         input         var1 $         var2 $         var3 $         var4 $         firstname  $         surname $         var5  $         var6  $         ; run; Thank you!  ... View more