topic Extract mobile number in text in SAS Programming

Extract mobile number in text

BrahmanandaRao — Sat, 27 Feb 2021 14:17:23 GMT

Guys in below excel sheet i have text data in column B so in that i want mobile number

its highlighted by red color for your understanding

Re: Extract mobile number in text

PaigeMiller — Sat, 27 Feb 2021 14:45:08 GMT

Most of us will not or cannot download Excel files (or any files).

Please provide your data according to these instructions: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

Re: Extract mobile number in text

BrahmanandaRao — Sat, 27 Feb 2021 14:48:29 GMT

Data like that only

Re: Extract mobile number in text

PaigeMiller — Sat, 27 Feb 2021 15:22:48 GMT

@BrahmanandaRao wrote:
Data like that only

Then many of us can't help you. (But, yes you can, by putting in a little effort, turn your data into the format requested, and then we can help you)

Re: Extract mobile number in text

BrahmanandaRao — Sat, 27 Feb 2021 15:31:58 GMT

I know solution in excel but i want SAS and Python

Re: Extract mobile number in text

PaigeMiller — Sat, 27 Feb 2021 15:40:32 GMT

So put in a little effort and change it to a SAS data set and give it to us following the instructions. Then we can show you how to use SAS to extract the phone number.

Re: Extract mobile number in text

BrahmanandaRao — Sun, 28 Feb 2021 09:17:04 GMT

I did solve using pandas
With same excel sheet without any format modifications after import the file

Re: Extract mobile number in text

Ksharp — Sun, 28 Feb 2021 11:08:55 GMT

proc import datafile='c:\temp\New Microsoft Office Excel Worksheet (3).xlsx' out=have dbms=xlsx replace;
run;
data want;
 set have;
 phone_number=scan(___VIT_AP_University_campus__Ina,-2,',');
run;