Question: 2. Creating New Columns with Character and Date Functions (5 points) The pg1.eu_occ table contains individual columns for nights spent at hotels, short stay accommodations,

2. Creating New Columns with Character and Date Functions (5 points) The pg1.eu_occ table contains individual columns for nights spent at hotels, short stay accommodations, or camps for each year and month. The YearMon column is character. a. Open a new program. Write a DATA step to create a temporary table named eu_occ_total based on the pg1.eu_occ table. Create the following new columns: . Year - the four-digit year extracted from YearMon. Page 1 of 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
