topic how to create a new variable in New SAS User

how to create a new variable

manjuhiten28 — Tue, 14 Jan 2020 07:11:56 GMT

I have a datset of Comcast Telecom Consumer Complaints .I need help . To create a new variable in my existing dataset in new column.

. i am poviding a screenshot of my dataset in photos

Data Dictionary

Ticket #: Ticket number assigned to each complaint
Customer Complaint: Description of complaint
Date: Date of complaint
Time: Time of complaint
Received Via: Mode of communication of the complaint
City: Customer city
State: Customer state
Zipcode: Customer zip
Status: Status of complaint
Filing on behalf of someone
Analysis Task

Create a new categorical variable with value as Open and Closed. Open & Pending is to be categorized as Open and Closed & Solved is to be categorized as Closed

i tried many ways but unable to create new variable

1)
data mylib.concast4;
set mylib.concast;
if Status in('Open','Pending') then new_status='Open';
else Status in('Closed ','Solved' ) then new_status='Closed';
run;
error is 
 error: statement is not valid or out of  proper order.
2)
proc sql;
create table mylib.concast4 as
select * from  mylib.concast
case
when status in ('open' ,'pending') then new_status='open'
when status in ('closed','solved') then new_status='closed'
else 'others'
end as new_status
from  mylib.concast;
quit;

error is ;
ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT, 
               JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE.  
 
 ERROR 76-322: Syntax error, statement will be ignored

please help me.

Re: how to create a new variable

andreas_lds — Tue, 14 Jan 2020 07:26:34 GMT

Please post the complete log as text.

Re: how to create a new variable

Kurt_Bremser — Tue, 14 Jan 2020 07:28:09 GMT

0) DO NOT post data in pictures, use a data step with datalines so we can easily recreate your dataset.

1) a "then" always needs an "if":

data mylib.concast4;
set mylib.concast;
if Status in('Open','Pending') then new_status='Open';
else if Status in('Closed ','Solved' ) then new_status='Closed';
run;

2) why do you have two "from" clauses in your SQL select? Only one is needed, and it has to come AFTER the column list:

proc sql;
create table mylib.concast4 as
select
  *, 
  case
    when status in ('open' ,'pending') then new_status='open'
    when status in ('closed','solved') then new_status='closed'
    else 'others'
  end as new_status
from  mylib.concast;
quit;

Make sure that your literals match the contents of status in terms of spelling and capitalization.

Re: how to create a new variable

Gupta — Tue, 21 Apr 2020 03:33:24 GMT

Can you please share complete solution for this to me, Thank you for your kind help in advance.