Hello, I'm trying to come up with some method to efficiently organize some data to get some particular results. Below is some sample data: ================================================================ DATA WORK.INFO; INPUT Team1_Name $ 1-9 Team1_Score 11 Team2_Name $ 13-27 Team2_Score 28 Game_Type $ 30-50 Venue $ 52-62; DATALINES; Spain     1 Italy          0 Friendly              Madrid Aruba     2 Guam           2 Friendly              Oranjestad Namibia   1 Congo          0 Continental Qualifier Windhoek Spain     2 Bolivia        0 Friendly              Seville Australia 0 Spain          3 FIFA World Cup Final  Curitiba France    1 Spain          0 Friendly              Paris Ethiopia  1 Algeria        2 Continental Qualifier Addis Ababa Spain     5 Venezuela      0 Friendly              Malaga Nepal     0 Maldives       1 Continental Qualifier Kathmandu Spain     2 Serbia         0 Friendly              St. Gall Spain     4 Korea Republic 1 Friendly              Berne ; RUN; DATA WORK.STUFF; SET WORK.INFO; /** ALL ORGANZATION GOES HERE AND NO WHERE ELSE. **/ /** SO, PROC SQL IS OFF THE TABLE. **/ RUN; ================================================================ I'm trying to create a new data set (WORK.STUFF) using only statements within the data step that adheres to the following conditions. 1. The data set must only hold observations including "Spain" (Can be observed in Team1_Name and Team2_Name variables). 2. The data set must have only one observation with two variables ("S_Goals" and "O_Goals" -- Spain goals and opponent goals).      "S_Goals" is the average number of goals scored by Spain per game. "O_Goals" is the average number of goals scored by the opponents of Spain per game. Anyone have any clue? The only thing I can come up with this splitting the data where Spain is either Team1_Name or Team2_Name and then interleaving them into a single data set. The goal is to get this result and adhere to the above guidelines. If anyone has a clue, I'd appreciate it. ... View more

Hello guys, I'm having an awful time trying to come up with how a particular code is to be written. Below is the basis of what I have now: View image: img1 When that code is run, it looks like this: View image: img2 As you can see, basically it's a layout of all 2014 world cup games (The image is cropped short, there are actually 64 observations). What I need to do within a DATA step is combine all distinct team observations (whether they be listed as Team1_Name or Team2_Name) and total their score in a new variable called 'GF'. For example, in image two 'Spain' is listed in observations 3 and 33. In observation 3, Spain scored 1 goal, in observation 33, Spain scored 3 goals. If those were the only two observations in which Spain appeared, it's output would look like: Team_Name, GF Spain, 4 Here is an image I put together using data lines to try and help imagine it (the observations are limited and the goal numbers made up): View image: img3 The code probably has to be some complicated combination of IF, THEN, DO, SELECT, WHERE... I have no idea, and I've been banging my head against the wall. Any suggestions would be greatly appreciated. ... View more