Software tools : SAS, R, Python etc Archives - Page 5 of 5 - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

Amalgamating SAS and Trilliant to Manage IoT and Energy Management Issues

With the rise of IoT and advanced systems that connects everything from a city’s surveillance grid to its transportation and utility systems, smart cities are evolving each day. They are being equipped with better street lighting, traffic conditions and utility services – an area that is in central focus is the smart street lighting that keeps its citizens safe and sound. In this regard, Trilliant, a top notch global provider of safe, enterprise wide smart energy communication systems has stepped forward with the analytics scion SAS. They have come together to sign an agreement that empowers data-driven decisions to optimize connected grid devices in the respective systems.

Amalgamating SAS and Trilliant to Manage IoT and Energy Management Issues

According to the agreement, Trilliant and SAS will jointly work to strike off system and interface compatibility, especially the analytics for the Internet of Things (IoT). While Trilliant will provide real-time data from a secure, technologically robust and multi-application networking platform, SAS will seamlessly integrate principal event stream processing for both structured and unstructured data. The latter will also provide machine learning for event detection, distributed energy resource optimization and revenue protection.

Continue reading “Amalgamating SAS and Trilliant to Manage IoT and Energy Management Issues”

The Soaring Importance of SAS in Creating jobs Across Various Industry Domains

In a survey held in 2016, 54 million employees across 350 industries picked out SAS as the most valuable skill to possess. SAS skills still top the list. With predictive analytics gaining speed and accuracy in the world, one just cannot ignore SAS – the oldest and brightest data analytics tool. Though SAS-dominating days are gone, as R and Python has come up ruling the world , 41% of talented data science professionals still prefer SAS as compared to any other languages. The data science market is conquered by R and Python to a great extent, yet you will find a substantial number of clients still putting their bet on SAS predictive modeling.


To test how SAS certification is taking the job world by storm, open your web-browser and type ‘SAS jobs’ in the search panel – the following results in front of your eyes will give you all your answers. In fact, you’ll be more than surprised to see how many jobs springs up that calls for SAS expertise. A lot of clients and data houses seek SAS certified professionals to take care of the data-induced challenges and the numbers are quite overwhelming!


In total, SAS has around 85000 clients across the globe – owing to which, the demand for SAS should come as no surprise to you.

Benefits of SAS:

  • High Salary
  • Increasing Global Demand
  • Marketability
  • Role-focused
  • Validation of Skills


Besides the benefits enumerated above, SAS certification sizzles with myriad other perks related to data and analytics, and is regarded to be extremely useful in bagging entry-level jobs in data science and analytics. A diligent SAS expert explores the broadening field of SAS ANALYTICS, while streamlining his individual skill and expertise to add credibility to his job profile.


Want to get an instant pay hike? SAS skills may come to your rescue. Once you hone your SAS analytics skill, you can start expecting 6% to 10% pay hike, which further expands, if you add data mining and data modeling skills to in your resume, likewise.


Financial analytics and SAS

To improve the performance of business and act upon the loopholes present in an organization, financial analysts backed by advanced SAS analytics skills pore over a vast amount of company’s financial data. They help you answer all the business related questions and predict the future of your organization.

Healthcare and SAS

As healthcare pushes boundaries to ace the digital transition, Statistical Analysis Systems (SAS) is bringing all kinds of latest technical updates and modifications across a wide spectrum of care, right from the way healthcare providers perform tests to measuring patient safety and health outcomes. It is playing a pivotal role in tapping a lot of disease states and assessing ways to commercialize treatments.



Who specializes in SAS and why?

SAS skill is for experienced professionals. Old timers are its biggest fan, especially those who have more than 15 years of job experience. For them, nothing suits better than this miracle tool for data analysis.

However, the tides of time is changing, the current pool of students is somewhat showing keen interest in this field of study for quite some time now. But it takes a real effort of time and practice both to excel in this highly advanced software.


Drop by DexLab Analytics to avail SAS online training. The course here is designed and delivered by industry experts with crisp content and student-friendly learning techniques. Visit their website today!


Interested in a career in Data Analyst?

To learn more about Machine Learning Using Python and Spark – click here.

To learn more about Data Analyst with Advanced excel course – click here.
To learn more about Data Analyst with SAS Course – click here.
To learn more about Data Analyst with R Course – click here.
To learn more about Big Data Course – click here.

Wake Up to a World of Data Possibilities: With SAS Certification

Of late, in spite of trending insurgence of cutting edge technology tools, SAS remains one of the most popular, in-demand programming languages for advanced analytics. It’s been more than two decades, yet it didn’t lose its importance in ruling the data science market. This shows how flexible this pioneering analytics tool is, and how adaptable it is in its functionality that it stood strong through the test of time and development.

Wake Up to a World of Data Possibilities: With SAS Certification

Possess the Right SAS Skills, Be In Demand

Organizations are utilizing the perks of advanced analytics inside out. They are realizing that not only big data analytics has secured a niche area of concentration for itself, but it has strived to be an indispensable part of any organization that is on its walk to success.

Continue reading “Wake Up to a World of Data Possibilities: With SAS Certification”

We Feel Honored To Conduct Training for Mercer in R Programming

We are back again with some awesome news! DexLab Analytics is organizing a comprehensive one-week training program for super-efficient data analytics and big data team of Mercer – a top notch multinational corporation that provides top-of-the-line solutions in Talent, Retirement and Investments worldwide.

We Feel Honored To Conduct Training for Mercer in R Programming

The training module has started from Thursday, 21st September 2017 and our in-house senior consultants are imparting cutting edge technological knowledge about R Programming to the data-hungry Mercer professionals. The training is taking place at Mercer’s corporate in DLF Phase 3, Gurgaon Office: with the rising demand of data analytics and R skills to imbibe, the advancement in the field of health, wealth and careers is witnessing a steady growth. To target a larger audience and loyal clientele base, R Programming skills need to be harnessed properly so as to flourish the future of business on a larger scale.

Continue reading “We Feel Honored To Conduct Training for Mercer in R Programming”

Decades On, SAS is Still the Market Leader

In the 2016 February report by Gartner, SAS bagged the top slot in its execution ability and was once again placed in the quadrant of leaders in the Magic Quadrant for Advanced Analytics Platforms.According to the description, as provided by Gartner, advanced analytics involves various sorts of data analysis through the use of quantitative methods of great sophistication like machine learning, statistics, simulation, data mining in its both predictive and descriptive forms as well as optimization.


Decades On , SAS Still The Leader


The goal is come up with insights that are unlikely to be discovered through approaching business intelligence traditionally like query and reporting.

Continue reading “Decades On, SAS is Still the Market Leader”

SAS Popularity Continues to Surge Upwards

SAS experienced its 40th successive year of growth as customers vied for the software in order to stay ahead of the fraud, risk and security challenges. The operating revenue of SAS stood at 3.16 billion US Dollars which was an increase of 6.4%. The sales in software also surged to 12% indicating that the SAS popularity is unlikely to abate in the coming years and it will cement its position as the market leader in the analytics sector.



Making its Presence Felt Globally

The growth of total revenue recorded was healthy across the world. The percentage growth touched double digits in most of the regions. It was no doubt facilitated by the new abilities of SAS in fraud, risk and intelligence about security.Much of the SAS revenue was fuelled by the governmental, financial and insurance sectors. The industries that led the way with greatest growth were manufacturing, banking, services and retail.

Click Here for Certification Based Training

Continue reading “SAS Popularity Continues to Surge Upwards”

Role of R In Business Intelligence

To put it simply Business Intelligence is the action of extracting and to derive information that may be of use from the available data. As might be evident the process is a broad one where the quality and the source of the data structure is variable. Transformations like this might in technical terms be described as ETL or extract, transform and load in addition to the presentation of information that is of use.


role of r in business intelligence

R Programming in Business Intelligence

Some R Programming Experts hold that R is fully able to take on the role of the engine for processes related to BI. Here we will focus only on the BI function of R i.e. to extract, transform load and present information and data. The following packages correspond to indicated processes in Business Intelligence.






  •  RODBC
  • DBI
  • data.table’s fread



In addition to these, there are several other packages that support data in a variety of formats.




  • data.table
  • dplyr




  • DBI


Let’s Take Your Data Dreams to the Next Level




Presenting data is a wholly different ball game than the previously mentioned process of ETL. Never fear, it may be outsourced with ease to tools of BI dashboard with ease by populating the structure of data according to the expectations of the particular data tool. R is able to create a dashboard of a web app directly from within itself through packages like:


  •  shiny
  • httpuv
  • opencpu
  • rook


These packages let you play host to interactive web apps. They have the ability to query the data in an interactive manner and generate interactive plots. The basis for all of these is an R session engine and is able to execute all functions of R and may leverage the capabilities of statistics of all packages in R.






The above mentioned packages serve as the core whose functionality may be simplified through the use of the packages mentioned below:


  • db.r
  • ETLUtils
  • Sqldf
  • Dplyr
  •  shinyBI
  • dwtools



The following factors are critical while R is adopted by businesses:


  • Extraction / Loading
  • Performance and scalability
  • Presentation
  • Support and licensing


For more details on R Programming, get yourself enrolled in superior R programming courses in Pune. R programming certification in Pune by DexLab Analytics is extremely popular.


Interested in a career in Data Analyst?

To learn more about Machine Learning Using Python and Spark – click here.
To learn more about Data Analyst with Advanced excel course – click here.
To learn more about Data Analyst with SAS Course – click here.
To learn more about Data Analyst with R Course – click here.
To learn more about Big Data Course – click here.

Trials Against WPL Awarded SAS With Damages

In a groundbreaking trial judgment, WPL (World Programming Ltd.) was found to have conducted software license breach and fraud and was made to pay damages to SAS. A federal jury found that WPL violated its software license for SAS learning edition with reverse engineering parts of the product to create their own WPS or World Programming System software while still using the SAS Learning edition to meet their production requirements.

Trials against WPL awarded SAS with damages


After the jury found this misconduct, the company was directed to pay SAS a penalty of USD 26.4 million in damages. Furthermore, WPL was also found to have committed fraud against SAS by the jury that required them to further pay another USD 3 million to SAS in terms of punitive damages. It was also concluded by the jury that WPL violated the NC Unfair and Deceptive Trade Practices Act that mandates the company to pay treble damage charges to SAS. The cumulative penalty judgment amounted to as much as USD 79 million. As per reports SAS will seek the help of parliament injunction on the issue to control sale of or use of WPS products in the US.

A representative of SAS revealed in a statement that the proofs they were able to collect enabled the jury to come to a conclusion quite fast that further validated the talk of the town about the practices of WPS that suggests that they did take part in unfair practices.SAS is currently the leading programming software in the world of Business Analytics. As per records the program helps users of more than 75,000 websites to make better and faster decisions using data.

Their work philosophy of – giving clients around the world “the power to know” (as is their tagline); using data tools is slowly taking over the market. They have been operating in the data industry since 1976. And all their products and services are trademarked under the name SAS Institute Inc. in the US and other countries.


Source :

Delimiters And Delimited Data in SAS

In this blog post we will delve into the world of delimiters as found in the SAS system of data analysis tools. Delimiters are an essential part of SAS without whose guidance SAS would be in some blind inspite of all the data that surrounds it as the data supplied to it either internally or as an external file.


sas courses

What are Delimiters?

Delimiters are essentially symbols to SAS that lets SAS know that the data is separate. They distinguish one set or category of data from others. This should give you an idea about how essential a part of data analytics, a delimiter plays.

How are the Delimiters Symbolized?

SAS accepts the following symbols and key strokes as delimiters:

  •  ,
  •  :
  • Tab
  •  ~
  • &
  •  –

How to Import Delimited Data?

This command imports data infile

Data claim_data;

infile datalines dlm = “,”;

Input sex $ name $ claim_amount ; datalines;








data claim_data ;

Infile E:\Project FT\SAS\Course Material\Class 1\Claim Data comma.txt’ dlm = “,”;

Input sex $ name $ claim_amount ;


What are the Functions of Delimiters?

An INFILE option, the DSD or delimiter-sensitive data serves varied functions. They are as follows:

  • The default delimiters are changed to wanted ones from the default blank.
  • In case a row contains two delimiters, SAS interprets that there is an instance of a case of missing value.
  •  Delimiters also strip the quotes within which character values are placed.

So the command would boil down to:

data claim_data ;

Infile E:\Project FT\SAS\Course Material\Class 1\Claim Data comma.txt’ dsd;

Input sex $ name $ claim_amount ;


How to Read Data from an External CSV file?

Our next task is to read data from external CSV files. In order to do so we have to input the following:

proc import datafile = “E:\Project FT\SAS\Course Material\Class 1\exam_results.csv”

dbms = csv replace out = class_10_result; Getnames = yes; run;

In a Nutshell

What are Format, Informat and DSD?

  • Informat : This command instructs SAS how exactly to going about reading the data.
  • Format : This instructs SAS about the exact way in which to show the details.
  • DSD : This defines how data is separated by a delimiter.

Call us to know more