Archive for

Data Analyst

link :https://www.linkedin.com/jobs2/view/29451452?trk=job_view_people_also_applied&trk=job_view_people_also_applied

#Senior Analysts – SAS VA (Visual Analytics) / SAS Fraud Framework- Good Joining Incentive

Job description

KiE Square invites you to join our Core Team of Analysts who have a sharp analytical bent, have prior experience in handling large datasets & building Statistical Models, an entrepreneurial spirit, and a natural ability to take responsibility.

The advantages of working with KiE Square would include:

The opportunity to deliver sophisticated end to end analytical solutions in an entrepreneurial environment

Working closely with the clients from across verticals and geographies

An environment devoid of rigid & structural hierarchies primed to help you deliver to your potential

An Industry leading compensation package

Desired Skills and Experience

The ideal candidate should have the below credentials:

  • Proficiency in using SAS VA/ SAS Fraud Framework.
  • Knowledge of SAS Base/ E-miner or other tool stacks would be an advantage
  • Graduation/Post Graduation Degree in Statistics or Engineering from a reputed institution.
  • At least 1-3 years of statistical analysis/ programming experience on large datasets preferably in Govt or BFSI. Other sectors can include CPG/Retail.
  • Application level Exposure to most or at least some of the key techniques of Statistical/ Predictive Modeling- Logistic Regression, Response Models, Bayesian Methods, Time Series Forecasting, Panel  Regression
  • Working knowledge of SQL and popular relational databases
  • Self-motivated and able to sustain himself/herself without direct supervision
  • Strong analytical, presentation & persuasive abilities with excellent interpersonal skills and strong oral and written communication skills

Key Skills-

SAS VA, SAS Fraud Framework, SQL, Statistical/ Predictive Modeling- Logistic Regression, Response Models, Bayesian Methods, Time Series Forecasting, Panel  Regression, Bootstrapping, Advanced Cluster Analysis

Experience                         1-3 YEARS (Minimum 2 years for Graduates)

Job Location                       Delhi/ NCR


link :https://www.linkedin.com/jobs2/view/40815862?trk=vsrp_jobs_res_name&trkInfo=VSRPsearchId%3A622659041427507264483%2CVSRPtargetId%3A40815862%2CVSRPcmpt%3Aprimary

Here are 5 examples of quick keystrokes that can save you time.

Convert case
Convert selected text to upper case: Ctrl + Shift + U
Convert selected text to lower case: Ctrl + Shift + L

Quick commenting
Wrap selection (or current line) in a comment: Ctrl + /
Unwrap selection (or current line) from a comment: Ctrl + Shift + /

Hyperjump to a line
Go to line: Ctrl + G (prompts for a line number)
Be sure to turn on Show line numbers in Program->Editor Options, or you’ll be navigating blind!

Jump to the “end of scope”
Move caret to matching parenthesis/brace: Ctrl + [, Ctrl + ]
Move caret to matching DO/END keyword: Alt + [, Alt + ]

Upgrading to R 3.1.3 on Windows

# installing/loading the latest installr package:
install.packages("installr"); library(installr) #load / install+load installr   updateR() # updating R.
Running “updateR()” will detect if there is a new R version available, and if so it will download+install it (etc.).
  • The internal method of download.file() can now handle files larger than 2GB on 32-bit builds which support such files (tested on 32-bit Rrunning on 64-bit Windows).
  • kruskal.test() warns on more types of suspicious input.
  • The as.dendrogram() method for "hclust" objects gains a checkargument protecting against memory explosion for invalid inputs.
  • capabilities() has a new item long.double which indicates if the build uses a long double type which is longer than double.
  • nlm() no longer modifies the callback argument in place (a new vector is allocated for each invocation, which mimics the implicit duplication that occurred in R < 3.1.0); note that this is a change from the previously documented behavior. (PR#15958)
  • icuSetCollate() now accepts locale = "ASCII" which uses the basic C function strcmp and so collates strings byte-by-byte in numerical order.
  • sessionInfo() tries to report the OS version in use (not just that compiled under, and including details of Linux distributions).
  • model.frame() (used by lm() and many other modelling functions) now warns when it drops contrasts from factors. (Wish of PR#16119)
  • install.packages() and friends now accept the value type = "binary" as a synonym for the native binary type on the platform (if it has one).
  • Single source or binary files can be supplied forinstall.packages(type = "both") and the appropriate type andrepos = NULL will be inferred.
  • New function pcre_config() to report on some of the configuration options of the version of PCRE in use. In particular, this reports if regular expressions using p{xx} are supported.
  • (Windows.) download.file(cacheOK = FALSE) is now supported when ‘internet2.dll’ is used.
  • browseURL() has been updated to work with Firefox 36.0 which has dropped support for the -remote interface.
  • The included version of PCRE has been updated to 8.36.
  • configure accepts MAKEINFO=texi2any as another way to ensuretexinfo 5.x is used when both 5.x and 4.x are installed.
  • R CMD check now checks the packages used in donttest sections of the examples are specified in the ‘DESCRIPTION’ file. (These are needed to run the examples interactively.)
  • R CMD check checks for the undeclared use of GNU extensions in Makefiles, and for Makefiles with a missing final linefeed.R CMD build will correct line endings in all Makefiles, not just those in the ‘src’ directory.
  • R CMD check notes uses of library() and require() in package code: see the section ‘Suggested packages’ of ‘Writing R Extensions’ for good practice.

Job | SAS with Advanced Excel- 3 -7 yrs- Gurgaon Location

Experience required for the Job: 3 – 7 years

Annual Salary of the Job: 0.0 – 9.0 Lacs

Job Location: Gurgaon

Dear Candidate,

#This is a permanent position with Teamware Solution for Client project (CMMI L-5)
#Notice period should not more than 30 days.
#Maximum upto 24 months break / gap in education / employment is permissible for valid reasons only.
#Minimum aggregrate marks of 50% and above in first attempt in class X, XII, Graduation and/or post- graduation.

Skills: SAS Developer (resource who is good at Advanced Excel (should have worked on creating macros in Excel).
Work Timings are: Mon to Wed – 1pm to 9:30pm, Thu to Fri – 8:30am to 5pm.

Manoj Kumar.K
TAG Team- Teamware Solution
+044 4012 8840

Associate Manager- Claims Analytics (ICD coding & SAS)

Job description

Role Description:-

  • Enable analytics driven decision making across various functions (primarily Claims and Medical Underwriting)
  • Continuously work with above teams, helping them to improve strategies, identify & plug leakages & drive automated decision making.
  • Provide the data driven solutions to address various business problem raised by senior management.

Job responsibilities:-

  • Perform descriptive analysis by slicing and dicing data by various parameters using Excel, BI tool, SAS, etc.
  • Produce dashboard and presentation based on regular and ad hoc requirements.
  • Help management by analysing large data and producing meaningful insights that can be used in decision making.
  • Person should be well versed with general statistical techniques like, Generalised Linear Model, Logistic Regression,
  • Cluster Analysis, Principal Component Analysis, etc. in SAS environment.
  • Candidate will be part of analytics team and would work closely with actuarial team to produce analytical reports
Desired Skills and Experience

Skills Required:-

  • 6 months to 5 years of experience.
  • Analytical bent of mind
  • Knowledge of claims dimensions and metrics (like ICD Coding, Procedure Codes, Surgical Treatments, LOS, Severity etc.)
  • Knowledge of Base SAS, SAS-EG, E-miner, SQL, VBA, MS Access, etc.
  • Knowledge of BI Tool, like Cognos, etc.

link :http://www.linkedin.com/company/apollo-munich-health-insurance-company-ltd.?trk=job_view_topcard_company_image

LIKE condition


The LIKE condition selects rows by comparing character strings with a pattern-matching specification. It resolves to true and displays the matched strings if the left operand matches the pattern specified by the right operand.

The ESCAPE clause is used to search for literal instances of the percent (%) and underscore (_) characters, which are usually used for pattern matching.

Patterns for Searching

Patterns consist of three classes of characters:

underscore (_)

matches any single character.

percent sign (%)

matches any sequence of zero or more characters.

any other character

matches that character.

These patterns can appear before, after, or on both sides of characters that you want to match. The LIKE condition is case-sensitive.

The following list uses these values: Smith , Smooth , Smothers , Smart , and Smuggle .


matches Smith , Smooth , Smothers , Smart , Smuggle .


matches Smith , Smooth .


matches Smuggle .


matches a three-letter word, so it has no matches here.


matches Smooth , Smothers .


matches Smith , Smooth .


matches the single, uppercase character Z only, so it has no matches here.


Searching for Literal % and _

Because the % and _ characters have special meaning in the context of the LIKE condition, you must use the ESCAPE clause to search for these character literals in the input character string.

These examples use the values app , a_% , a__ , bbaa1 , and ba_1 .

  • The condition like ‘a_%’ matches app , a_% , and a__ , because the underscore (_) in the search pattern matches any single character (including the underscore), and the percent (%) in the search pattern matches zero or more characters, including ‘%’ and ‘_’.

  • The condition like ‘a_^%’ escape ‘^’ matches only a_% , because the escape character (^) specifies that the pattern search for a literal ‘%’.

  • The condition like ‘a_%’ escape ‘_’ matches none of the values, because the escape character (_) specifies that the pattern search for an ‘a’ followed by a literal ‘%’, which does not apply to any of these values.

    Searching for Mixed-Case Strings

  • To search for mixed-case strings, use the UPCASE function to make all the names uppercase before entering the LIKE condition:

       upcase(name) like 'SM%';

    Note:   When you are using the % character, be aware of the effect of trailing blanks. You might have to use the TRIM function to remove trailing blanks in order to match values.  [cautionend]



From the SAS Online Doc:

RECFM= specifies the record format. Values for the RECFM= option are

      D =default format (same as variable).

      F =fixed format. That is, each record has the same length. Do not use
RECFM=F for external files that contain carriage-control characters.

      N =binary format. The file consists of a stream of bytes with no
record boundaries.

      P =print format. On output, the SAS System writes carriage-control

      V =variable format. Each record ends in a newline character.

      S370V variable S370 record format (V).

      S370VB variable block S370 record format (VB).

      S370VBS variable block with spanned records S370 record format (VBS).
If you specify RECFM=S3270VBS, then you should specify BLDSIZE=32760 and
LRECL=32760 to avoid errors with records longer than 255.

Note:   To use the S370V, S370VB, or S370VBS format to access a file that
was created under the OS/390 operating environment, the file must be of type

This option is used for both input and output.

Create a library using the Explorer window. Then copy a table into the library.

  1. In the Explorer window, display the active libraries. Then, in Active Libraries, select File then New.
  2. In the New Library window, type Mylib in the Name box and leave the Default engine selected. Select Enable at startup so that the library is created each time you start SAS.

To view available engines, click the Engine drop-down arrow. However, be sure to leave Default selected.

  1. Type the path (a directory or other storage location, as appropriate) for the library. Alternatively, click Browse, if available, and then open—not merely select—a location to use for this library. Verify that the path specified in the Folder field is correct. Then click OK to confirm the path.
  2. Click OK to assign the library. Mylib appears in the Active Libraries list.
  3. If the Explorer window contains only one pane, activate the Explorer window and select View then Show Tree. The Explorer window now contains two panes.

    You can resize the Explorer window by dragging the edge of the window. You can resize the left and right panes by clicking and dragging the split bar between the two panes. In the z/OS and CMS environments, click the window border or split bar; then click the desired location.

  1. In the left pane, single-click the Sashelp library so that the library’s contents appear in the right pane. Scroll to the icon for the Prdsale data set.
  2. Click the Prdsale table. To copy the table to your Mylib library, drag and drop it onto Mylib in the left pane. (Alternatively, you can select Copy from the pop-up menu for Prdsale. Then select Paste from the pop-up menu for Mylib.)
  3. Open Mylib and confirm that the data set was copied.

When you use the subsetting IF statement, how are observations excluded?

a.  If the expression is true, SAS excludes the observation from the input data set.

b.  If the expression is false, SAS excludes the observation from the output data set.

c.  If the expression is false, SAS excludes the observation from the PDV.

d.  If the expression is true, SAS excludes the observation from the PDV.


Ans :

%d bloggers like this: