I am working with an advertising database for a school project and I've been using the online SAS Studio. I am trying to create a new categorical variable ('TVSpend') from a numerical variable ('TVBudget' which shows the amount spent on TV Advertising) with my dataset. I am having issues with it, but the first 2 variables I created worked fine. I'm sure it is something small I am overlooking, can anyone help? The error I am getting is right after "If TVBudget >= 100 and < 200 then TVSpend = 'Medium'; else" and the message is: _ _______ _ 22 180 180 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. ERROR 180-322: Statement is not valid or it is used out of proper order. Here is my code: Libname Final '/home/pavlockb30/my_courses/SASSpring2019/MyData/FinalProject';
Data Final.Advertising;
Infile '/home/pavlockb30/my_courses/SASSpring2019/MyData/FinalProject/Advertising.csv' DSD Firstobs=2;
Input Observation TVBudget RadioBudget NewspaperBudget Sales;
If Sales > Sum(TVBudget, RadioBudget, NewspaperBudget) then Profit = 'Yes'; else
If Sales < Sum(TVBudget, RadioBudget, NewspaperBudget) then Profit = 'No'; else
If Sales = Sum(TVBudget, RadioBudget, NewspaperBudget) then Profit = 'Breakeven';
If TVBudget > RadioBudget and NewspaperBudget then LargestExpenditure = 'TV'; else
If RadioBudget > TVBudget and NewspaperBudget then LargestExpenditure = 'Radio'; else
If NewspaperBudget > TVBudget and RadioBudget then LargestExpenditure = 'Newspaper';
If TVBudget = . then TVSpend = 'Missing'; else
If TVBudget < 100 then TVSpend = 'Low'; else
If TVBudget >= 100 and < 200 then TVSpend = 'Medium'; else
If TVBudget <= 200 then TVSpend = 'High';
Run;
Proc Print Data = Final.Advertising Noobs;
Run;
... View more