Question

SASCan someone help me with B part. Please

Report 3. A regional SAS conference will be held in a few weeks time. The raw data file Conference.cav contains information about the registered attendeos: first name, last name, attendeo ID, business phone, home phone, mobile phone, OK to contact attendee at business (Yes/No), OK to contact at home (Yes/No), OK to contact attendee at mobile (Yes/No), registration rate, will attend Wednesday mixer (Yes/No), will attend Thursday lunch (Yes/No), willing to volunteer at the conference (Yes/No), and dietary restrictions. (a) Use a DATA step to read the raw data file into a permanent SAS data set called location.conference. The red in the previoul file name indicates that you can store the file in any SAS Library of your creation (like our statcomp Library in class) (b) Use a separate DATA step to read the obeervations from conference into a new permanent SAS data set called location.conference2. In this new data set, use the registration rate variable to create a new variable called Registration that groups attendees as Early, Regular, or On-Site according to Table 1 Registration Rates Early$150 (Student), $295 (Academic), or $395 (ludustry) Regular On-sites550 $200 (Student), $350 (Academic), or $150 (Industry) Table 1: Listing of regional SAS conference registration rates

Answer 1

Sol:

use set statement to copy a datset from work location to permanent library location

assuming conference in work library.

SAS PROGRAM:

data location.conference2:

set conference;

if Rates in (150,295,395) then Registration= "Early";

if Rates in (200,350,450) then Registration= "Regular";

if Rates in (550 ) then Registration= "0n-site";

run;