Thanks this is very cool! I definitely need to investigate all of this further as what I had in mind regarding a topo map was to show the contour lines of the lake. Example here: "https://webapp.navionics.com/#boating@11&key=otlhFtwduP"   Maybe there's a way to add this as a second layer. Regardless I appreciate all the info and the examples are great.  ... View more

You're mixing up PROC IMPORT with a Data step. PROC IMPORT is done as my previous example above. What you've done here is closer to a DATALINES step except your missing that key syntax.   Below is what you need to do (keep in mind this isn't 100% working due to missing data).   /*naming our dataset */ data have; /* Setting input to declare our variables (column headers) */ input Mouse Day3 Day6 Day9 Day12 Day15 Day18 Day21; /* calling datalines which allows us to put in the values */ datalines; 1 0.109 0.388 0.621 0.823 1.078 1.132 1.191 2 0.218 0.393 0.568 0.729 0.839 0.852 1.004 3 0.394 0.549 0.700 0.783 0.870 0.925 4 0.209 0.419 0.645 0.850 1.001 1.026 1.069 5 0.193 0.362 0.520 0.530 0.641 0.640 0.751 6 0.201 0.361 0.502 0.530 0.641 0.640 0.751 7 0.202 0.370 0.498 0.650 0.795 0.858 0.910 8 0.190 0.350 0.666 0.819 0.879 0.929 9 0.219 0.399 0.578 0.699 0.709 0.822 0.953 10 0.255 0.400 0.545 0.690 0.796 0.825 0.836 11 0.224 0.381 0.577 0.756 0.869 0.929 0.999 12 0.187 0.329 0.441 0.525 0.621 0.796 13 0.278 0.471 0.606 0.770 0.888 1.001 1.105 ; RUN When you look over the above and run it you should notice that your data doesn't line up starting at Mouse 4. Given Day3-Day21 are all numeric values you need to identify the blanks as missing. To do that you need to place a period for those areas.   /*naming our dataset */ data have; /* Setting input to declare our variables (column headers) */ input Mouse Day3 Day6 Day9 Day12 Day15 Day18 Day21; /* calling datalines which allows us to put in the values */ datalines; 1 0.109 0.388 0.621 0.823 1.078 1.132 1.191 2 0.218 0.393 0.568 0.729 0.839 0.852 1.004 3 0.394 0.549 0.700 0.783 0.870 0.925 . 4 0.209 0.419 0.645 0.850 1.001 1.026 1.069 5 0.193 0.362 0.520 0.530 0.641 0.640 0.751 6 0.201 0.361 0.502 0.530 0.641 0.640 0.751 7 0.202 0.370 0.498 0.650 0.795 0.858 0.910 8 0.190 0.350 0.666 0.819 0.879 0.929 . 9 0.219 0.399 0.578 0.699 0.709 0.822 0.953 10 0.255 0.400 0.545 0.690 0.796 0.825 0.836 11 0.224 0.381 0.577 0.756 0.869 0.929 0.999 12 0.187 0.329 0.441 0.525 0.621 0.796 . 13 0.278 0.471 0.606 0.770 0.888 1.001 1.105 ; RUN/*naming our dataset */ data have; /* Setting input to declare our variables (column headers) */ input Mouse Day3 Day6 Day9 Day12 Day15 Day18 Day21; /* calling datalines which allows us to put in the values */ datalines; 1 0.109 0.388 0.621 0.823 1.078 1.132 1.191 2 0.218 0.393 0.568 0.729 0.839 0.852 1.004 3 0.394 0.549 0.700 0.783 0.870 0.925 . 4 0.209 0.419 0.645 0.850 1.001 1.026 1.069 5 0.193 0.362 0.520 0.530 0.641 0.640 0.751 6 0.201 0.361 0.502 0.530 0.641 0.640 0.751 7 0.202 0.370 0.498 0.650 0.795 0.858 0.910 8 0.190 0.350 0.666 0.819 0.879 0.929 . 9 0.219 0.399 0.578 0.699 0.709 0.822 0.953 10 0.255 0.400 0.545 0.690 0.796 0.825 0.836 11 0.224 0.381 0.577 0.756 0.869 0.929 0.999 12 0.187 0.329 0.441 0.525 0.621 0.796 . 13 0.278 0.471 0.606 0.770 0.888 1.001 1.105 ; RUN   ... View more

So the article I sent previously provides examples (https://documentation.sas.com/?docsetId=proc&docsetTarget=n1w1xy48wd290bn1mqalitn7wy13.htm&docsetVersion=9.4&locale=en#n1w1xy48wd290bn1mqalitn7wy13) on how to do this. Your data in the text file needed to be reformatted (Just line everything up so all the variables are separated with your TAB button and all columns are on top) correctly but once done you can use the following:   proc import datafile='C:\MiceWeight.txt' /* Your path goes here directly to the .txt file */ out=have dbms=dlm replace; delimiter='09'x; run; data want; set have; weightdiff = day21-day3; run;   I'd recommend you try following through with @Tom as well and his solution which is a different approach from this but will probably make more sense to you once you actually learn it. Best of luck! ... View more

1. Import the data you want. https://documentation.sas.com/?docsetId=proc&docsetTarget=n18jyszn33umngn14czw2qfw7thc.htm&docsetVersion=9.4&locale=en   2. Add new column with your calculation. (There are many examples of how to do this on google) https://communities.sas.com/t5/SAS-Programming/How-do-I-create-a-calculated-column-in-an-existing-dataset/td-p/438296   If you run into errors with the above ask away.   Edit: As I feel it's important to mention, google is your friend with learning anything. When it comes to programming you can generally either find an example of someone doing what you are attempting or at the very least find documentation. The sooner you get used to this the easier it's going to be. ... View more

What exactly is your question? ... View more

Below will run according to what you requested; keep in mind if your expected output changes this likely won't cross over well.   Edit: Made correction to code.   proc sql; create table want as select SubjectID, SUM(Value1=1)+SUM(Value2=1)+SUM(Value3=1) As Total from have group by SubjectID; quit; ... View more