SAS Contextual Analysis : Getting Data

rk3664 — Sat, 18 May 2019 07:13:20 GMT

Hi,

Presently I am working on a project which requires to read data from Website into SAS Contextual Analysis.

The objective is to find out whether one of client customers name is appearing on a given website.

One of the websites from which we need to read the data is "https://www.moneycontrol.com/news/"

I need some advice on how to read data from websites using SAS Visual Analytics or any other SAS tools and

How to Create a dataset from extracted data and pulling in data set to SAS Contextual Analysis.

Urgent advice is needed.

Thanks

Rakesh Kumar

Contact - +91-9008964466

Re: SAS Contextual Analysis : Getting Data

rajdeep — Tue, 13 Aug 2019 11:56:30 GMT

Hi Rakesh,

I think you can use PROC HTTP to extract the tags from a websites and then use any pattern matching technique to find the common pattern and set a status as Success or some flag.

For example:

filename src temp;
proc http
 method="GET"
 url= "https://www.moneycontrol.com/news/"
 out=src;
run;
data rep;
infile src length=len lrecl=32767;
input line $varying32767. len;
 line = strip(line);
 if len>0;
run;

data _Trials_(drop=recordline record nextpage);
length Status $25 ;
retain Status;
retain recordLine 0; *=1 means this line may contain needed information;
set rep;
if prxmatch('/>Study</i',line) then recordLine=1;
if (recordLine=1) then do; *now get the related information;
if prxmatch('/>Study</i',line) then status='Success';
run;

So in the above fashion you might try to search something inside the parser as per your requirement and if you want to store the number of occurrences of the same word then you can use the call prxnext.

Thanks and Gud luck.

topic SAS Contextual Analysis : Getting Data in SAS Data Science

SAS Contextual Analysis : Getting Data

Re: SAS Contextual Analysis : Getting Data