Sorry for the late response. Took a while to get the macro to work on a unix enviroment. I am rookie when it comes to SAS so I am pretty locked into my mindset on how I should solve the issue. But seeing that you are my senior I will take anything you say into consideration and try to implement. If you have any good links to how I should procede I would appreciate that very much. I am including the entire output from the first macro step fs_season as it is the team Detroit Lions who are missing from the Team_W column. data WORK.WBW2008_FS_SEASON;
infile datalines dsd truncover;
input Team_W:$20. Team_L:$20.;
datalines4;
Arizona Cardinals,St. Louis Rams
Arizona Cardinals,Miami Dolphins
Arizona Cardinals,St. Louis Rams
Arizona Cardinals,Buffalo Bills
Arizona Cardinals,Dallas Cowboys
Arizona Cardinals,Seattle Seahawks
Arizona Cardinals,San Francisco 49ers
Arizona Cardinals,San Francisco 49ers
Arizona Cardinals,Seattle Seahawks
Atlanta Falcons,Chicago Bears
Atlanta Falcons,Oakland Raiders
Atlanta Falcons,Green Bay Packers
Atlanta Falcons,St. Louis Rams
Atlanta Falcons,Kansas City Chiefs
Atlanta Falcons,Detroit Lions
Atlanta Falcons,New Orleans Saints
Atlanta Falcons,Minnesota Vikings
Atlanta Falcons,Tampa Bay Buccaneers
Atlanta Falcons,Carolina Panthers
Atlanta Falcons,San Diego Chargers
Baltimore Ravens,Houston Texans
Baltimore Ravens,Oakland Raiders
Baltimore Ravens,Washington Redskins
Baltimore Ravens,Cincinnati Bengals
Baltimore Ravens,Cleveland Browns
Baltimore Ravens,Cleveland Browns
Baltimore Ravens,Philadelphia Eagles
Baltimore Ravens,Jacksonville Jaguars
Baltimore Ravens,Dallas Cowboys
Baltimore Ravens,Cincinnati Bengals
Baltimore Ravens,Miami Dolphins
Buffalo Bills,St. Louis Rams
Buffalo Bills,Jacksonville Jaguars
Buffalo Bills,Oakland Raiders
Buffalo Bills,San Diego Chargers
Buffalo Bills,Denver Broncos
Buffalo Bills,Seattle Seahawks
Buffalo Bills,Kansas City Chiefs
Carolina Panthers,Tampa Bay Buccaneers
Carolina Panthers,Arizona Cardinals
Carolina Panthers,Denver Broncos
Carolina Panthers,New Orleans Saints
Carolina Panthers,Chicago Bears
Carolina Panthers,Green Bay Packers
Carolina Panthers,Atlanta Falcons
Carolina Panthers,San Diego Chargers
Carolina Panthers,Detroit Lions
Carolina Panthers,Oakland Raiders
Carolina Panthers,New Orleans Saints
Carolina Panthers,Kansas City Chiefs
Chicago Bears,Jacksonville Jaguars
Chicago Bears,Green Bay Packers
Chicago Bears,Indianapolis Colts
Chicago Bears,New Orleans Saints
Chicago Bears,Minnesota Vikings
Chicago Bears,Philadelphia Eagles
Chicago Bears,Detroit Lions
Chicago Bears,Detroit Lions
Chicago Bears,St. Louis Rams
Cincinnati Bengals,Kansas City Chiefs
Cincinnati Bengals,Cleveland Browns
Cincinnati Bengals,Washington Redskins
Cincinnati Bengals,Jacksonville Jaguars
Cleveland Browns,Jacksonville Jaguars
Cleveland Browns,Cincinnati Bengals
Cleveland Browns,Buffalo Bills
Cleveland Browns,New York Giants
Dallas Cowboys,Tampa Bay Buccaneers
Dallas Cowboys,New York Giants
Dallas Cowboys,Philadelphia Eagles
Dallas Cowboys,Cleveland Browns
Dallas Cowboys,Green Bay Packers
Dallas Cowboys,San Francisco 49ers
Dallas Cowboys,Washington Redskins
Dallas Cowboys,Cincinnati Bengals
Dallas Cowboys,Seattle Seahawks
Denver Broncos,San Diego Chargers
Denver Broncos,Kansas City Chiefs
Denver Broncos,Atlanta Falcons
Denver Broncos,New York Jets
Denver Broncos,New Orleans Saints
Denver Broncos,Oakland Raiders
Denver Broncos,Tampa Bay Buccaneers
Denver Broncos,Cleveland Browns
Green Bay Packers,Indianapolis Colts
Green Bay Packers,Detroit Lions
Green Bay Packers,Detroit Lions
Green Bay Packers,Seattle Seahawks
Green Bay Packers,Minnesota Vikings
Green Bay Packers,Chicago Bears
Houston Texans,Tennessee Titans
Houston Texans,Cincinnati Bengals
Houston Texans,Green Bay Packers
Houston Texans,Jacksonville Jaguars
Houston Texans,Cleveland Browns
Houston Texans,Chicago Bears
Houston Texans,Miami Dolphins
Houston Texans,Detroit Lions
Indianapolis Colts,Jacksonville Jaguars
Indianapolis Colts,Detroit Lions
Indianapolis Colts,Baltimore Ravens
Indianapolis Colts,Minnesota Vikings
Indianapolis Colts,Cincinnati Bengals
Indianapolis Colts,Cleveland Browns
Indianapolis Colts,San Diego Chargers
Indianapolis Colts,Tennessee Titans
Indianapolis Colts,Houston Texans
Indianapolis Colts,Pittsburgh Steelers
Indianapolis Colts,Houston Texans
Indianapolis Colts,New England Patriots
Jacksonville Jaguars,Houston Texans
Jacksonville Jaguars,Green Bay Packers
Jacksonville Jaguars,Indianapolis Colts
Jacksonville Jaguars,Denver Broncos
Jacksonville Jaguars,Detroit Lions
Kansas City Chiefs,Oakland Raiders
Kansas City Chiefs,Denver Broncos
Miami Dolphins,Denver Broncos
Miami Dolphins,San Francisco 49ers
Miami Dolphins,Buffalo Bills
Miami Dolphins,Kansas City Chiefs
Miami Dolphins,Buffalo Bills
Miami Dolphins,New York Jets
Miami Dolphins,St. Louis Rams
Miami Dolphins,Oakland Raiders
Miami Dolphins,New England Patriots
Miami Dolphins,Seattle Seahawks
Miami Dolphins,San Diego Chargers
Minnesota Vikings,New York Giants
Minnesota Vikings,Houston Texans
Minnesota Vikings,Arizona Cardinals
Minnesota Vikings,Detroit Lions
Minnesota Vikings,Chicago Bears
Minnesota Vikings,Jacksonville Jaguars
Minnesota Vikings,Detroit Lions
Minnesota Vikings,Carolina Panthers
Minnesota Vikings,New Orleans Saints
Minnesota Vikings,Green Bay Packers
New England Patriots,Buffalo Bills
New England Patriots,Arizona Cardinals
New England Patriots,Oakland Raiders
New England Patriots,St. Louis Rams
New England Patriots,Seattle Seahawks
New England Patriots,Kansas City Chiefs
New England Patriots,Denver Broncos
New England Patriots,Miami Dolphins
New England Patriots,New York Jets
New England Patriots,San Francisco 49ers
New England Patriots,Buffalo Bills
New Orleans Saints,Detroit Lions
New Orleans Saints,San Diego Chargers
New Orleans Saints,San Francisco 49ers
New Orleans Saints,Atlanta Falcons
New Orleans Saints,Green Bay Packers
New Orleans Saints,Oakland Raiders
New Orleans Saints,Kansas City Chiefs
New Orleans Saints,Tampa Bay Buccaneers
New York Giants,Dallas Cowboys
New York Giants,Carolina Panthers
New York Giants,Pittsburgh Steelers
New York Giants,San Francisco 49ers
New York Giants,Washington Redskins
New York Giants,Arizona Cardinals
New York Giants,Baltimore Ravens
New York Giants,St. Louis Rams
New York Giants,Philadelphia Eagles
New York Giants,Cincinnati Bengals
New York Giants,Washington Redskins
New York Giants,Seattle Seahawks
New York Jets,Buffalo Bills
New York Jets,Kansas City Chiefs
New York Jets,Buffalo Bills
New York Jets,Arizona Cardinals
New York Jets,Miami Dolphins
New York Jets,Tennessee Titans
New York Jets,Cincinnati Bengals
New York Jets,New England Patriots
New York Jets,St. Louis Rams
Oakland Raiders,Tampa Bay Buccaneers
Oakland Raiders,Houston Texans
Oakland Raiders,New York Jets
Oakland Raiders,Denver Broncos
Oakland Raiders,Kansas City Chiefs
Philadelphia Eagles,Dallas Cowboys
Philadelphia Eagles,Cleveland Browns
Philadelphia Eagles,Atlanta Falcons
Philadelphia Eagles,New York Giants
Philadelphia Eagles,Arizona Cardinals
Philadelphia Eagles,Pittsburgh Steelers
Philadelphia Eagles,San Francisco 49ers
Philadelphia Eagles,Cincinnati Bengals
Philadelphia Eagles,St. Louis Rams
Philadelphia Eagles,Seattle Seahawks
Pittsburgh Steelers,Cleveland Browns
Pittsburgh Steelers,Cleveland Browns
Pittsburgh Steelers,Baltimore Ravens
Pittsburgh Steelers,Houston Texans
Pittsburgh Steelers,Baltimore Ravens
Pittsburgh Steelers,Dallas Cowboys
Pittsburgh Steelers,Cincinnati Bengals
Pittsburgh Steelers,New England Patriots
Pittsburgh Steelers,Cincinnati Bengals
Pittsburgh Steelers,San Diego Chargers
Pittsburgh Steelers,Jacksonville Jaguars
Pittsburgh Steelers,Washington Redskins
San Diego Chargers,Tampa Bay Buccaneers
San Diego Chargers,Oakland Raiders
San Diego Chargers,Kansas City Chiefs
San Diego Chargers,Oakland Raiders
San Diego Chargers,New York Jets
San Diego Chargers,New England Patriots
San Diego Chargers,Kansas City Chiefs
San Diego Chargers,Denver Broncos
San Francisco 49ers,Washington Redskins
San Francisco 49ers,St. Louis Rams
San Francisco 49ers,Seattle Seahawks
San Francisco 49ers,New York Jets
San Francisco 49ers,Buffalo Bills
San Francisco 49ers,Detroit Lions
San Francisco 49ers,St. Louis Rams
Seattle Seahawks,New York Jets
Seattle Seahawks,San Francisco 49ers
Seattle Seahawks,St. Louis Rams
Seattle Seahawks,St. Louis Rams
St. Louis Rams,Dallas Cowboys
St. Louis Rams,Washington Redskins
Tampa Bay Buccaneers,Kansas City Chiefs
Tampa Bay Buccaneers,Green Bay Packers
Tampa Bay Buccaneers,Atlanta Falcons
Tampa Bay Buccaneers,Seattle Seahawks
Tampa Bay Buccaneers,New Orleans Saints
Tampa Bay Buccaneers,Detroit Lions
Tampa Bay Buccaneers,Carolina Panthers
Tampa Bay Buccaneers,Minnesota Vikings
Tampa Bay Buccaneers,Chicago Bears
Tennessee Titans,Baltimore Ravens
Tennessee Titans,Green Bay Packers
Tennessee Titans,Indianapolis Colts
Tennessee Titans,Pittsburgh Steelers
Tennessee Titans,Minnesota Vikings
Tennessee Titans,Cleveland Browns
Tennessee Titans,Kansas City Chiefs
Tennessee Titans,Detroit Lions
Tennessee Titans,Jacksonville Jaguars
Tennessee Titans,Cincinnati Bengals
Tennessee Titans,Jacksonville Jaguars
Tennessee Titans,Chicago Bears
Tennessee Titans,Houston Texans
Washington Redskins,Philadelphia Eagles
Washington Redskins,Dallas Cowboys
Washington Redskins,Detroit Lions
Washington Redskins,Cleveland Browns
Washington Redskins,Seattle Seahawks
Washington Redskins,New Orleans Saints
Washington Redskins,Arizona Cardinals
Washington Redskins,Philadelphia Eagles
;;;; The issue I am having is when using my second macro it just takes the unique observations from the Team_W column and tallies a score. Seeing that Detroit Lions are missing from the Team_W column they do not display in the final output. My thought was doing a proc sql where statement saying that if team = X does not exist in column Team_W they will have 0 wins / 16 loses in the final macro step If you have good work around from this I would be grateful
... View more