Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Using an Iterative and Conditional D0 Loop The pg2.eu_sports table contains European Union trade amounts for sport products. Belgium wants to see their exports
3. Using an Iterative and Conditional D0 Loop The pg2.eu_sports table contains European Union trade amounts for sport products. Belgium wants to see their exports exceed their imports for golf and racket products. They expect to annually increase exports by T% and want to achieve their goal within [0 years. a. Open p206p05.sas from the practices folder. Run the program and review the results. Notice that the golf export number is farther from the golf import number as compared to the racket export and import numbers. Belgium Golf and Racket Products - 7% Increase in Exports Obs SporLProduct Year AmtJmport AmLExport 1 GOLF 2015 14,923,000 0,600,390 2 MCKET i2015 14,005,000 11,759,300 b. Add a conditional DO loop around the assignment statement for Amt_Export. i. Use a DO WHLLE statement that executes while the export value is less than or equal to the import value. ii. Create a Year column that increments by a value of 1. iii. Create a row of output for each year. c. Run the program and review the results. Partial Results (5 of [3 Rows) Belgium lGolf and Racket Products - Ht. Increase in Exports om BporLProduct | Year 1 mumpon AmLExport 14,923,000 0,009,390 14.920000 7,072.04? 04,023,000 r,50r,091 14,023,000 0090,03? 14,923,000 d. How many years did it take until the exports exceeded the imports, and what is the nal Year value for each sport product? d. How many years did it take until the exports exceeded the imports, and what is the nal Year value for each sport product? Sport_Prud Number of Final Year uct Yea rs GOLF RACKET e. Modify the DO statement to include an iterative portion before the conditional portion. The iterative portion needs to be based on Year values of 2016 to 2025 (10 years). f. Within the DO loop, delete any statements related to the incrementing of Year. g. Run the program and review the results. The results show 14 data rows. h. Complete this table based on your last modication
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started