sas training centre in gurgaon Archives - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

Tag: sas training centre in gurgaon

5 Best Tools Transforming Predictive Analytics in 2018

Posted on by Dexlab

5 Best Tools Transforming Predictive Analytics in 2018

Gone are the days of sloppy decision-making techniques. Competitive businesses are embracing predictive analytics and associated tools.

Predictive analytics is a real game changer that allows companies to implement marketing strategies and serve customers with renewed efficiency. Customers in their natural interactions and networking with a company leave behind huge amounts of data. Predictive models extract valuable information from all this data, thereby helping enhance the performance of products and services, promoting better customer retention strategies, and improving core business competencies.

‘’The capacity for predictive analytics to learn from experience is what renders this technology effective, differentiating it from other business intelligence tools and analytics techniques’’, says the predictive analytics experts at Quantzig.

From thoroughly examining data, to figuring out correlations and patterns in data, predictive analytics tools effectively manage the entire business process. In this blog, we talk about some of the latest predictive analytics tools that are all the rage in 2018! So let’s dive in!

SAP Business Objects:

  • A powerful Business Intelligence platform that provides techniques to make swift and informed business decisions.
  • Offers a novel perspective on forming scalable solutions
  • SAP Business Object helps develop insights that encourage real time actions.
  • Enables users to visualize data in a self-serving manner

Image Source: Technosap

IBM Predictive Analytics:

  • Offers predictive analytics solutions that are simple to use and meet the requirements of different types of businesses.
  • Two important softwares, namely IBM SPSS Modeler and IBM SPSS Analytics, allow all users to implement predictive analytics and improve their businesses, irrespective of their skill levels.
  • The platform helps prevent frauds and maximizes profits.
  • It transforms extraneous data into predictive insights that steer key business decisions.
  • It is built with abilities to perform geospatial analysis and text analytics.
  • Runs on open source platforms with optional coding
  • Secure and private

Image Source: SlideShare

QlikView:

  • Flexible and easy-to-use business intelligence platform
  • Created by QlikTech
  • Allows enterprises to pull out relevant information from a given data set, which in turn helps design guided analytics applications.
  • Platform adopts a user-driven approach towards building charts and creating dashboards
  • BARC’ BI Survey 10 recognizes the ‘Agile BI’ ability of QlikView

Halo:

  • Ideal pick for an uninterrupted supply chain management system that aids in business forecasting
  • A smart platform with a dependable data repository, where cases can be run over and over again in order to perfectly match predictions with results.
  • Accessible through all kinds of browsers and available for cloud or hosted.
  • Self-serving nature of supply chain management allow organizations to increase customer satisfaction.

Image Source: Software Advice

Dataiku-DSS:

  • Dataiku is capable of transforming raw data into predictions.
  • Allows users to employ analytics appropriate algorithms
  • Allows users to leverage available libraries and apply custom codes in R and Python
  • Permits integration of external libraries by means of code API’s
  • Equipped with 80+ in-built functions that help investigate and clean raw forms of data
  • The best feature is a visual data profile at each step of analysis.

Image source: The Dataiku Blog

Want to learn SAS Predictive Modeling? Contact DexLab Analytics. The industry-experts at DexLab offer excellent SAS predictive modeling training. It encompasses theoretical understanding of core concepts and hands-on experience.

 

Interested in a career in Data Analyst?

To learn more about Data Analyst with Advanced excel course – Enrol Now.
To learn more about Data Analyst with R Course – Enrol Now.
To learn more about Big Data Course – Enrol Now.

To learn more about Machine Learning Using Python and Spark – Enrol Now.
To learn more about Data Analyst with SAS Course – Enrol Now.
To learn more about Data Analyst with Apache Spark Course – Enrol Now.
To learn more about Data Analyst with Market Risk Analytics and Modelling Course – Enrol Now.

The Nitty-Gritty When It Comes to SAS 101

Posted on by Dexlab

The Nitty-Gritty When It Comes to SAS 101

SAS is a state-of-the-art business intelligence tool that is primarily designed to facilitate reporting, data analysis, mining and predictive modeling using convincing visualization and interactive dashboards. Being a powerful programming language, SAS performs complex statistical data analysis; unlike other built-in tools, like Microsoft Excel, SAS lets users to salvage and run data from a plethora of sources, along with ensuring enough control and freedom during data manipulation and compilation.

Statistical Analysis System (SAS) was introduced for organizations to explore their vast datasets in a highly interactive format. Today, SAS is largely used in machine learning, data science and business intelligence applications. Not only does it arms the organizations with the necessary tools and techniques to monitor key BI metrics, but also develops incredible insights and comprehensive reports, facilitating informed decision-making procedures.

2

SAS Fuelling Career Growth

Business analytics and incredible BI tools have become central for running medium and large-scale enterprises across the globe, efficiently. With data becoming increasingly instrumental in pushing businesses to horizons of success, a majority of organizations is betting on SAS BI analytics.

As a result, the demand for SAS consultants is surging at an accelerating rate. Since more and more companies are adopting SAS analytics and altering the ways they used to work, SAS-related jobs are flooding the market. Handsome pay-packages are being offered to the right candidates, skilled and professional.

According to a recent study, the average salary of a diligent SAS programmer is around 10.8 Lacs – organizations are looking for professionals who would not only know how to slice and dice but also know how to draw the right projections and effectively communicate the insights. This is where SAS training Delhi comes in – Head-start a data journey with DexLab Analytics, as it offers the best SAS analytics training Delhi.

Books: For Enhancing the Level of SAS Knowledge

Besides encompassing SAS certification course modules, books tend to take us all a step closer to the bubbling pool of knowledge – SAS books are carefully written, specifically keeping in mind the requirements and focused areas of programmers and analysts.

Without any further ado, let’s dive into a well-curated list of SAS books that’ll help you ace the language like a pro:

 

  • SAS Essentials: Mastering SAS for Data Analytics by Elliott and Woodward – With an advanced approach, this book is perfect for master’s students of data analysis and programming and higher-level undergraduates.
  • SAS for Dummies by McDaniel and Hemedinger – An absolute beginner’s approach to SAS, this book is widely popular for its simple language, easier representation of facts and easy-to-follow guidelines.
  • The Little SAS Book by Delwiche and Slaughter – Ideal for beginners and experienced SAS consultants, as well, this book includes self-contained lessons, plenty of examples and interesting visuals.
  • SAS Certification Prep Guide – Released by the SAS institute, this is the final and official test-prep guide to be SAS certified.
  • Learning SAS by Examples: A Programmer’s Guide by Ron Cody – If you are a fast learner, this is the one for you. Each chapter in this book ends with test problems so that you are trained SAS-ready.

 

As final thoughts, SAS analytics is the most powerful tool for performing complex data analysis. Grasping the fundamentals of SAS language will surely present you a big leg up in the analytical domain. For SAS certification courses, drop by DexLab Analytics.

 

The blog has been sourced from –

https://www.whoishostingthis.com/resources/sas-programming

https://intellipaat.com/blog/what-is-sas-analytics

https://analyticsindiamag.com/analytics-india-salary-study-2017-by-analytixlabs-aim
 

Interested in a career in Data Analyst?

To learn more about Data Analyst with Advanced excel course – Enrol Now.
To learn more about Data Analyst with R Course – Enrol Now.
To learn more about Big Data Course – Enrol Now.

To learn more about Machine Learning Using Python and Spark – Enrol Now.
To learn more about Data Analyst with SAS Course – Enrol Now.
To learn more about Data Analyst with Apache Spark Course – Enrol Now.
To learn more about Data Analyst with Market Risk Analytics and Modelling Course – Enrol Now.

6 Predictive Analytics Use Cases Proven To Ace Marketing Efforts

Posted on by Dexlab

6 Predictive Analytics Use Cases Proven To Ace Marketing Efforts

Predictive analytics includes a set of functions that leverage customer information to construct interesting assumptions about future potential customers. They play an integral role in determining a customer’s lifecycle.

What’s more, predictive analytics influences company strategy even before any prospect gets converted into a lead. That’s the way it functions, and as the leads are converted into customers, the new data collected impacts the next-generation marketing activities. The process is almost cyclical.

In this post, we will discuss about 6 use cases for predictive analytics that shows a significant impact on marketing ROI.

And here it starts:

Better Lead Scoring

With predictive analytics, lead scoring becomes a whole data-driven process that targets customers. It helps you leverage the actions of existing customers to build better future strategies. No more it remains an anecdotic listicle of measures from sales, instead it points out the ‘hot’ leads that can be pushed down through the funnel of sales.

Improved Lead Nurturing

Remember, one-size-fits-all doesn’t apply to lead nurturing.

For converting prospects into leads, a definitive plan for lead nurturing should be adopted. Predictive analytics is the hands-down tool to consider: take cue from behavioral and demographic data to push leads towards the sales funnel.

Smart Content Distribution

Today, every company invests in quality content creation. Content marketing has the power to fetch measurable ROI for your company. And this is where predictive analytics play a vital role: it analyses the type of content customers would find interesting, based on certain behavioral and demographic data and then automatically distribute them to the prospective leads.

2

Protecting Baseline Becomes Easy

Predictive analytics help learn from the past mistakes. Past behavior is a testimony of future behavior, and it holds true for customers, as well. A clear analysis of behavioral patterns of previously-churned customers in your company would help identify the red flags your present customers are showing, thus results in protecting your baseline for a better, secure future.

Develop Products Fit For Customers

Understanding what customers need becomes a tad too easier when you are armed with a set of behavioral, demographic and psychological data of your customers. Again possible with predictive analytics! Leverage customer data and figure out what they are looking for.

Design Successful Future Campaign

Past performance analysis always leads to constructing better future campaign designs. As more and more new customers seem to enter your business, you need to leverage your data more precisely and curate content based on their preferences and requirements. And may even have to target specific audiences! So, treat past data as a treasure!

As parting thoughts, these six strategies for predictive modeling are perfect for transforming your business. Today, data is the power. Clean, high-quality data have the potential to take your business venture to unforeseeable heights of success.

And for that and more, DexLab Analytics is here to help. Our skilled consultants can crack the toughest data management problems and provide solutions to make predictive modeling using SAS better. For SAS predictive modeling training, peruse over our course section on the website.

 
The article has been sourced from – https://blog.reachforce.com/blog/8-use-cases-for-predictive-analytics-in-marketing
 

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.

SAS Conducts India’s Largest Analytics Forum in Mumbai

Posted on by Dexlab

SAS Conducts India’s Largest Analytics Forum in Mumbai

This May, India is making preparations to host the largest analytics forum in association with SAS – the top notch player in the world of business analytics. The conference on machine learning, AI, IoT, fraud management and customer experience hosted by SAS Forum India is going to be held on Tuesday, 15th May 2018 at Renaissance Mumbai Convention Centre Hotel, Mumbai.

2

In its eight year, SAS Forum India is a highly acclaimed knowledge sharing platform wherein business consultants, users and industry honchos come together and meet every year to share crucial knowledge and experience in regards to Analytics. It offers incredible learning and networking experience, while focusing on the imposing role of Analytics across versatile industry domains.

Data is like a new currency impacting the world around – it’s being used right from dealing with humanitarian issues to solving intricate business challenges. In this scenario, the scope of data scientists becomes limitless. They are ushered into countless opportunities to establish connection with their customers, along with developing new profound experiences in the technology world.

Rightfully so, this year’s Forum is going to talk about the latest trends in machine learning, cognitive computing, artificial intelligence, Internet of Things, fraud intelligence, risk management, IFRS9 compliance and customer experience. Industry stalwarts and thought leaders hailing from various business verticals are expected to exchange nuanced notions about each concept to set off breakthrough outcomes and bang open doors of new possibilities.

However, this year the theme is Inspire the Extraordinary, and some of the influential speakers are noted below:

  • Mrutyunjay Mahapatra – Deputy Managing Director, State Bank of India
  • Daniel Zeo Jimenez – Regional Research Director, IDC Asia/Pacific
  • Rahul Shandilya, SVP and CIO – Customer Experience and Product Development, Mahindra & Mahindra
  • Goutam Datta – Vice President – Technology – ICICI Lombard
  • Mridul Sharma, CIO, IndusInd Bank
  • Sudip Banerjee, CTO, Reliance Capital and many more

The summit is also going to screen live demos of diverse analytics SAS solutions, including SAS Viya, the open, next-gen and cloud-ready solutions that help tackle analytics challenges, right from experimental to mission-critical.

Commenting on the occasion, Noshin Kagalwalla, Managing Director, SAS Institute India Pvt. Ltd  was found saying, “New age machine Learning & Deep Learning techniques that form the fulcrum of AI are now opening a whole new world of possibilities for businesses. At the SAS India Forum this year, we are delighted to be joined by some of the best and brightest leaders in analytics who will enlighten you on how to leverage these emerging technologies to succeed in the Analytics Economy.”

Now, as you are reading this blog we are sure you are interested in SAS certification courses. DexLab Analytics offers best SAS analytics training Delhi for aspiring candidates at decent prices. Check out the course details now!

The blog has been sourced from – http://www.dqindia.com/sas-host-indias-largest-analytics-forum-may-15-2018-mumbai

 

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.

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

Posted on by Dexlab

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.

SAS-Certification-India

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.

 

2

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.

Data Science Jobs: Luxury Today, Necessity Tomorrow

Posted on by Dexlab

Data Science Jobs: Luxury Today, Necessity Tomorrow

A general consensus: the scene of employment is changing. The jobs in data science are spiking up, and at a robust rate. According to World Economic Forum in 2016, a nuanced state of affairs with employment fluctuations is likely to happen across sectors, jobs and geography in the coming years – hold your horses and wait with bated breath!

2

Job Opportunities till 2020

A wide set of factors are expected to bring upon different effects on the varying segments of employment market till 2020. For an instance, recent demographic stats in the emerging job market are likely to ace up employment by 5% approx worldwide. On the other side, the surging geopolitical instability across the globe could reduce employment by 2.7%. Amidst this, artificial intelligence, touted as a replacement key for manpower is likely to have a minute effect on job reduction by a mere 1.5%.

Considerably, the overall figure points that the computing and mathematical jobs are going to increase by 3.2% – because a sturdy compilation of technological and geopolitical instability effect is expected to generate an altogether positive effect across various employment chains, suggesting the instability will in return result in a higher demand for programming, computing and modeling.

However, recruitment procedure is going to get more challenging.

Across every sector and every job family the perception is that recruitment will be more challenging in future #ai #sasacademic

Lower University application rates

Following the latest trends, the applications to universities by students have taken a halt – in UK, the number of people applying to universities has fallen drastically – the reason anticipated is the result of Brexit.

But irrespective of any reason, lower application rate is going to affect graduate recruitment. The emergence of a gig economy is largely considered a positive effort, but a lack of benefits like annual leave may cause some hindrance in the effectuality. Also, AI is resulting in a less number of job generation, the automation of entry-level jobs mean lesser jobs.

Hone your skills further after employment

While undergraduates and postgraduates eyes employment as the end of their education, for employers it’s an entirely different ball game. For them, employment is the just a stepping stone in the process of ongoing training to make sure the fresh workforce develops cutting-edge skills. This stands true especially in complex job areas of data science, where a shortage of graduates exists. As a result, motivate your existing workforce to develop required data analytics skills in the most accomplishing way to garner expertise and thorough know-how.

The most desirable quality in a new #DataScience hire is their dedication to continually learn more. #sasacademic #ai

To get the best kind of data science online training, drop by DexLab Analytics Delhi – it is a prime learning platform in India that helps you remain up-to-date with the latest tools and trends. The field of data analytics is evolving rapidly and continuing professional development is the need of the hour.

 
Source – blogs.sas.com
 

Interested in a career in Data Analyst?

To learn more about Data Analyst with Advanced excel course – Enrol Now.
To learn more about Data Analyst with R Course – Enrol Now.
To learn more about Big Data Course – Enrol Now.

To learn more about Machine Learning Using Python and Spark – Enrol Now.
To learn more about Data Analyst with SAS Course – Enrol Now.
To learn more about Data Analyst with Apache Spark Course – Enrol Now.
To learn more about Data Analyst with Market Risk Analytics and Modelling Course – Enrol Now.

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

Posted on by Dexlab

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”

Here’s why SAS Analytics Is a Must-Have IT Skill to Possess

Posted on by Dexlab

Here’s why SAS Analytics Is a Must-Have IT Skill to Possess

Without the great Analytical surge, everything was looking fit and fine. The economy was performing well. The IT industry was looking stable. The tech honchos were playing fine. And then IT happened! Data Analytics snatched the dazzling limelight all to itself.

It’s true once in a while, our market needs a good shaking, or else things tend to get sluggish and slow. Over time, the industries start decreasing in efficiency and business houses crumples. Therefore, the change induced by Big Data Analytics is one for good: it started pulling back the market to its former position. From medical science to military to security, the reach of Big Data Analytics can be witnessed everywhere.

The evolution of analytics is largely consistent and covers a wide span of industries. It’s not like it suddenly came into a lot of focus, its advancement was slow and steady. Now, it has strived to become extremely important to store, interpret, analyze and develop crucial insights – social media is deriving maximum benefits out of analytics, while customizing their products to make more money from advertisements. On the other hand, the service-oriented companies love to manipulate data that is generated through myriad social channels to trigger customer base.

The ABC of Summary Statistics and T Tests in SAS – @Dexlabanalytics.

Today, SAS certifications are extremely rewarding and scores high for both employee and employer. Analytics is a big word, encompassing a whole array of job roles, such as Forecaster, Market Researcher, Data Miner, Operations Researcher and Statistical Analyst – so when are you choosing this career gateway for a better future! DexLab Analytics is here with its state-of-the-art SAS training courses, help yourself.

6

3 key benefits of becoming SAS analytics professional:

Increase marketability and reach

SAS Analytics professionals possess higher marketability skills and enjoy a certain edge over competitors. Their job is to deliver nothing but the best, and they are very focused in doing that, leaving no scope for complaints.

Expand credibility for being the right technical professionals

As the SAS certified professionals have a thorough know-how about using SAS Software the employers stay relaxed and trusts their predicaments, hence, enhancing their credibility quotient.

Enhance skill and expertise in SAS area of specialization

No doubt, SAS Analytics professionals are extremely good in their field of work. Owing to their professional nature they tend to attract more lucrative job opportunities.

Data Preparation using SAS – @Dexlabanalytics.

Apart from SAS, R programming is rapidly gaining popularity. Small and large companies have realized the growing the importance of these two tools. SAS combined with R language training in Delhi opens a whole gamut of striking opportunities. Having said that, companies that have stayed traditional, through its very core, have now embraced SAS and R skills, and for the right reasons.

At DexLab Analytics, we increasingly focus on making students totally data-ready. Opt for R programming certification, and give new data-hungry souls the drive to enter the world of analytics. After all, to excel in the analytics career and sail high you need to be well-equipped with SAS and R – they are the tools of combat for the future IT domain.!

 

Interested in a career in Data Analyst?

To learn more about Data Analyst with Advanced excel course – Enrol Now.
To learn more about Data Analyst with R Course – Enrol Now.
To learn more about Big Data Course – Enrol Now.

To learn more about Machine Learning Using Python and Spark – Enrol Now.
To learn more about Data Analyst with SAS Course – Enrol Now.
To learn more about Data Analyst with Apache Spark Course – Enrol Now.
To learn more about Data Analyst with Market Risk Analytics and Modelling Course – Enrol Now.

How to Determine the Size of a SAS Data Set

Posted on by Dexlab

How to Determine the Size of a SAS Data Set

When program codes, applications and SAS data sets are developed, enough attention is often not given to EFFECIENCY, especially during the initial phases of development. Since, data size and system conduct can influence a program or an application’s functioning, SAS users need to access information about a data set’s size and content. To ascertain how much disk space a data set is using, users can easily do a few calculations to learn to access metadata content and attain the important information. Determine, estimate and understand information with this following tip, which helps improve SAS performance and fine-tuning of techniques.

Also read: How to Code Colour Values Within SAS Enterprise Guide


Implementing PROC SQL and DICTIONARY.TABLES

The SAS system accumulates valuable information (also known as metadata) about all-familiar SAS libraries, indexes, data sets (tables), system options, views, catalogs, macros and an assemblage of other “read-only” tables called Dictionary tables and SASHELP views. TABLES, a particular Dictionary table and its SASHELP view equivalent, VTABLE, consists details about a SAS session’s data set. Check the following PROC SQL code as its specification will help us get access to the contents of four columns observed in the TABLES Dictionary table, namely BNAME, MEMNAME, MEMTYPE and FILESIZE to exhibit the size of the CARS data set.

Also read: How to Use PUT and %PUT Statements in SAS: 6 Tips


PROC SQL and Dictionary.TABLES:

PROC SQL ;
  TITLE ‘Filesize for CARS Data Set’ ;
  SELECT LIBNAME,
         MEMNAME,
         FILESIZE FORMAT=SIZEKMG.,
         FILESIZE FORMAT=SIZEK.
    FROM DICTIONARY.TABLES
      WHERE LIBNAME = ‘SASHELP’
        AND MEMNAME = ‘CARS’
        AND MEMTYPE = ‘DATA’ ;
QUIT ;

Results

Size-of-SAS-data-set1

Analysis

The above results show that the CARS data set filesize is 192KB.

Nota bene: If the SIZEKMG.format is mentioned in a format=option, SAS ascertains whether it should apply KB for kilobytes, MB for megabytes or GB for gigabytes, and divide the filesize value with the help of one of the following values:

KB           1024

MB          1048576

GB           1073741824


Using PROC PRINT and SASHELP.VTABLE

In the following example, the provisions of a PROC PRINT are explained to access the constituents of three columns found in the VTABLE SASHELP view, particularly LIBNAME, MEMNAME and FILESIZE to exhibit the size of the CARS data set.

Also read: SAS Still Dominates the Market After Decades of its Inception


PROC PRINT and SASHELP.VTABLE

PROC PRINT DATA=SASHELP.VTABLE NOOBS ;
  VAR LIBNAME MEMNAME FILESIZE ;
  WHERE LIBNAME = ‘SASHELP’
    AND MEMNAME = ‘CARS’ ;
  FORMAT FILESIZE SIZEKMG. ;
  TITLE ‘Filesize for SASHELP.CARS Data Set’ ;
RUN ;

Results

Size-of-SAS-data-set2


Using DATA _NULL_, SASHELP.VEXTFL and CALL SYMPUTX

Lastly, a DATA_NULL_ is depicted to approach the contents of the VEXTFL SASHELP view with a FILENAME statement. An assignment statement is specified to determine the FILESIZE value for the size of the CARS data set. The CALL SYMPUTX left supports and chops off the trailing blanks from the digital FILSESIZE value of 196608.

Also read: Things to judge in SAS training centres


DATA_NULL_and SASHELP.VEXTFL

filename myfile 'C:\Program Files\SAS9.4\SASFoundation\9.4\\CORE\SASHELP\Cars.sas7bdat' ;
DATA _NULL_ ;
  SET SASHELP.VEXTFL (WHERE=(FILEREF=’MYFILE’)) ; 
  /* Calculate the Filesize in MB */
  FILESIZE = FILESIZE / (1024 ** 2) ;
  CALL SYMPUTX (‘FILESIZE’,FILESIZE) ;
RUN ;

Results

Size-of-SAS-data-set3

 

Learn more about SAS Predictive Modelling by taking up SAS certification courses in Delhi and Gurgaon. DexLab Analytics offers excellent SAS analytics course for data enthusiasts.

 
This post originally appeared on – blogs.sas.com/content/sastraining/2017/04/25/determining-the-size-of-a-sas-data-set
 

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.

Call us to know more

Gurgaon

+91 8676079880

Kolkata

+91 9903662244

Quick Links

Our Courses

Important dates

Copyright © 2024 DexLab Solutions Corporation | Privacy Policy | Legal Disclaimer | Terms and Conditions