topic get/cut some words in the midle of field in SAS Programming

get/cut some words in the midle of field

Handihusen — Sat, 19 Feb 2022 20:30:00 GMT

Please somebody can help me:
How can i get/cut some words in the middle of field with delimetted? For example i want get word "adminFee" and next characthers (the amount of admin fee) ?
Examples:
I have field "Remarks" with contents: //name://davids://amount://100000://adminfee://500//date://20220131//city://jakarta//

Re: get/cut some words in the midle of field

sbxkoenk — Sat, 19 Feb 2022 21:49:53 GMT

Hello,

Build upon this :

data _NULL_;
remarks = '//name://davids://amount://100000://adminfee://500//date://20220131//city://jakarta//';
pos=index(remarks,'adminfee'); put pos=;
adminfee=substr(remarks,pos,20); put adminfee=;
adminfee_amount = input(compress(adminfee,'abcdefghijklmnopqrstuvwxyz:/'),best12.); put adminfee_amount=;
run;

Koen

Re: get/cut some words in the midle of field

Handihusen — Sun, 20 Feb 2022 02:11:38 GMT

Thanks a lot mr/miss Koen.. you are the best 👍👍