Thanks All, FIrst--I have to say I am an absolute Newbie to SAS...so, please bear with me... Second...not sure on SAS/OR... I will have to ask our techies... To give more info on the issue: This is pathogen sampling data and is in a database that I pull using SQL... For each sample, there is an associated form with a unique ID. Each sample is assigned a 'ParentSample' Number. You always know which is the parent because the ChildSample# is null... (Actually in the DB, the ParentSample is Null and the ChildSample not--the ChildSample is then the ParentSample. I just swap this in the SQL used to pull the data). One sample could be analyzed for multiple pathogens...e.g., Salmonella and Campylobacter... Each Pathogen can have multiple isolates with its own serotype and other factors... So you could have (This is how I would like the data): Form# 1 ParentSample#1 -- Salmonella Positive / Campylobacter Positive ChildSample#2 Salmonella Enteritidis => Grandchild#3 PFGE Pattern => GreatGranchild#4 Antimicrobial Resistance ChildSample#5 Salmonella Heidelberg => Grandchild#6 PFGE Pattern => GreatGranchild#7 Antimicrobial Resistance ChildSample#8 Campylobacter Jejuni => Grandchild#9 PFGE Pattern I used consecutive numbers in the example--actually they are multidigit numbers--I just used the above to show that they should be unique within the FormID/ParentSample The data is always split between the variables ParentSample and ChildSample with the added info (e.g. Pathogen, Serotype, Antimicrobial Resistance) in additional variables... So, the above would be in the DB as such: FormID# ParentSample# ChildSample# Info 1 1 - Salmonella + / Campylobacter + 1 1 2 Enteritidis 1 2 3 PFGE 1 3 4 Antimicrobial Resistance 1 1 5 Heidelberg 1 5 6 PFGE 1 6 7 Antimicrobial Resistance 1 1 8 Jejuni 1 8 9 PFGE Normally, it will be sorted by FormID, ParentSample, ChildSample: FormID# ParentSample# ChildSample# Info 1 1 - Salmonella + / Campylobacter + 1 1 2 Enteritidis 1 1 5 Heidelberg 1 1 8 Jejuni 1 2 3 PFGE 1 3 4 Antimicrobial Resistance 1 5 6 PFGE 1 6 7 Antimicrobial Resistance 1 8 9 PFGE I should also mention that normally there is only one Grandchild, GreatGrandChild, etc per Child... So, there can be multiple Children per Parent--but usually everything from there is singular back to the Child. So PGStats data above would collapse like this: 1 2 20 200 1 2 30 1 2 40 500
... View more