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.
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”
Basically the number of functions present in the SAS program amount to three. They are Character Functions, Numeric Functions and Date and Time Functions. In this post we are going to take a brief look at Character functions of a basic nature.
Suppose that there is this program with the following lines of command:
Data Len_func ; input name $ ; cards; Sandeep Baljeet
data Len_func; set Len_func ; Len=length(name);
Len_N=lengthn(name); Len_C=lengthc(name); run;
proc print; run;
- The function called LENGTH returns the character value’s length.
- The function LENGTHN is more or less identical to the LENGTH function. The sole difference between the two lies in the fact that for a value missing character it returns the length that equals to 0 whereas LENGTH returns a value of 1.
- The function LENGTHC returns to the program the storage length of particular strings.
Again let us consider the following lines of code:
Data case ; input name $ ;cards;
sandeep baljeet neeta
proc print; run;
Here the following functions are introduced:
- The function UPCASE converts all of the letters to the uppercase.
- The function PROPCASE serves to capitalize the first letter of all words and converts the remaining to lowercase.
- As might be guess from the convention conformed to while naming the function, LOWCASE transforms all letters to their lowercase counterparts.
In the following program commands:
Data AMOUNTS; input NAME $20.; cards;
RAD-HIKA SHARMA RAJARAM PAND-IT SURESH
Set AMOUNTS; NAME1=COMPRESS(NAME,'-'); NAME2=COMPBL(NAME);
Here we can see the following syntax:
- Compress (Variable, ”want to remove”);
- Compbl (Variable)
- The function COMPRESS removes blanks by default. It can also remove a particular specified character value as indicated by the code. In the example cited the character value ‘-‘is compressed.
- On the other hand the COMPBL function serves to result in a single blank from multiple ones.
For expert guidance, you will be well advised to enroll yourself in a SAS course from a reputed SAS Training institute. You may consider DexLab Analytics if you are in the vicinity of Delhi or noida.
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.