topic SAS programming in SAS Programming

SAS programming

UcheOkoro — Tue, 07 Jul 2020 20:05:37 GMT

I want to create a new variable(CC_new) from a Chief Complaint variable (CC). The CC variable has some observations with multiple Chief Complaints separated by a semicolon e.g. Headache;fever;sore throat. However, I only need the first Chief Complaint to create the CC_new variable.

Please, I need help with this.

Thank you.

Re: SAS programming

Shmuel — Tue, 07 Jul 2020 20:15:19 GMT

Is that what you are looking for?

cc_new = scan(cc,1,',');

Re: SAS programming

UcheOkoro — Tue, 07 Jul 2020 20:21:11 GMT

Thank you for your response. I tried the following but it did not help.

data Permanent_data3;
set Permanent_data;
cc_new = scan(cc,1,',');run;

Re: SAS programming

ketpt42 — Tue, 07 Jul 2020 20:28:34 GMT

Semicolon is your delimiter, right? If so, use:
cc_new=scan(cc,1,';');

Re: SAS programming

UcheOkoro — Tue, 07 Jul 2020 20:32:27 GMT

It worked. Thank you.