*Hi,  This is the lesson and there are two solutions below.  In the first solution please let me know if you need .... count+1? both solutions are the same without it.  If it is included, what is the reasoning. Thank you!! ********************************************************; * LESSON 2, PRACTICE 1 *; * a) Open the PG2.NP_YEARLYTRAFFIC table. Notice the *; * Count column records the number of cars that have *; * passed through a particular Location. *; * b) Modify the DATA step to create a column, totTraffic,*; * that is the running total of Count. *; * b) Keep the ParkName, Location, Count, and *; * totTraffic columns in the output table. *; * c) Format totTraffic so values are displayed with *; * commas. *; ***********************************************************; data totalTraffic ; set pg2.np_yearlyTraffic; Count+1; *Running Total of Count */; retain totTraffic 0; totTraffic+Count; format totTraffic comma12.; keep ParkName Location Count totTraffic; run; /*OR*/ data totalTraffic; set pg2.np_yearlytraffic; totTraffic+Count; keep ParkName Location Count totTraffic; format totTraffic comma12.; run;   ... View more

* Macro Functions: Practice #1 * 75 *******************************/ 76 77 %let Fullname=AnTHoNY MilLeR; 78 %Let First=%scan(&fullname, 1); 79 %Let Last=%scan(&fullname, 2); 80 81 %put &=First 82 83 %put %sysfunc(propcase(&First)); ERROR: Open code statement recursion detected. 84 85 %put &=Last ERROR: Open code statement recursion detected. 86 87 %put %sysfunc(propcase(&Last)); 88 89 %put Fullname=&Fullname First=%sysfunc(propcase(&First)) Last=%sysfunc(propcase(&Last)); ERROR: Open code statement recursion detected. 90 91 %put &Fullname; ERROR: Open code statement recursion detected. 92 93 %put %upcase(&fullname); ERROR: Open code statement recursion detected. 94 95 %put The current form of the name is &Fullname and the Propercase is ERROR: Open code statement recursion detected. 96 %sysfunc(propcase(&Fullname)); 97 98 %put _user_; ERROR: Open code statement recursion detected. 99 100 %symdel Fullname ; ERROR: Open code statement recursion detected. 101 ... View more