#syntax of proc freq procedure

[greatonlinetrainingsposts]

How Do You Use a SAS Tutorial to Learn Data Cleaning Techniques?

Before you start analyzing data, it's important to understand how clean your dataset is. If your data has missing values, duplicate entries, or inconsistent formatting, it can throw off your entire analysis. Even the most advanced model won’t work well if the data going into it is flawed.

That’s where SAS programming comes in. When you follow a SAS tutorial, you’re not just learning how to write code—you’re learning how to think through data problems. A good tutorial explains what each step does and why it’s important.

Here’s how to use a SAS tutorial to build your data cleaning skills, step by step.

1. Start by Inspecting the Data

The first thing most SAS tutorials will show you is how to explore and inspect your dataset. This helps you understand what you’re working with.

You’ll learn how to use:

PROC CONTENTS to see the structure and metadata

PROC PRINT to view the raw data

PROC FREQ and PROC MEANS to check distributions and summaries

As you review the outputs, you’ll start spotting common problems like:

Too many missing values in key variables

Numbers stored as text

Values that don’t make sense or fall outside expected ranges

These early steps help you catch red flags before you go deeper.

2. Learn How to Handle Missing Data

Missing data is very common, and a good SAS tutorial will show you a few ways to deal with it.

This includes:

Using IF conditions to identify missing values

Replacing them with zeros, averages, or medians

Removing variables or rows if they’re not useful anymore

The tutorial might also explain when to fill in missing data and when to just leave it out. Real-world examples from healthcare, marketing, or finance help make the decisions easier to understand.

3. Standardize and Format Your Data

A lot of data comes in messy. For example, dates might be stored in different formats or categories might use inconsistent labels like "M", "Male", and "male".

With SAS programming, you can clean this up by:

Converting dates using INPUT and PUT functions

Making text consistent with UPCASE or LOWCASE

Recoding values into standardized categories

Getting your formatting right helps make sure your data is grouped and analyzed correctly.

4. Remove Duplicate Records

Duplicate records can mess up your summaries and analysis. SAS tutorials usually explain how to find and remove duplicates using:

PROC SORT with the NODUPKEY option

BY group logic to keep the most recent or most relevant entry

Once you understand the concept in a tutorial, you’ll be able to apply it to more complex datasets with confidence.

5. Identify Outliers and Inconsistencies

Advanced tutorials often go beyond basic cleaning and help you detect outliers—data points that are far from the rest.

You’ll learn techniques like:

Plotting your data with PROC SGPLOT

Using PROC UNIVARIATE to spot unusual values

Writing logic to flag or filter out problem records

SAS makes this process easier, especially when dealing with large datasets.

6. Validate Your Cleaning Process

Cleaning your data isn’t complete until you check your work. Tutorials often show how to:

Re-run summary procedures like PROC MEANS or PROC FREQ

Compare row counts before and after cleaning

Save versions of your dataset along the way so nothing gets lost

This step helps prevent mistakes and makes sure your clean dataset is ready for analysis.

Why SAS Programming Helps You Learn Faster

SAS is great for learning data cleaning because:

The syntax is simple and easy to understand

The procedures are powerful and built-in

The SAS community is active and supportive

Whether you're a beginner or trying to improve your skills, SAS tutorials offer a strong, step-by-step path to learning how to clean data properly.

Final Thoughts

Learning data cleaning through a SAS tutorial doesn’t just teach you code—it trains you to think like a data analyst. As you go through each lesson, try applying the same steps to a dataset you’re working with. The more hands-on experience you get, the more confident you’ll be.

If you want to improve your data analysis and make better decisions, start by getting your data clean. And using SAS programming to do it? That’s a smart first move.

[karonbill]

SAS Institute A00-231 Practice Test Questions

In order to help you pass the A00-231 SAS 9.4 Base Programming - Performance-Based Exam, PassQuestion provides you the latest SAS Base Programming Specialist A00-231 Practice Test Questions, which have a very close similarity with real exam. They use professional knowledge and experience to provide SAS Base Programming Specialist A00-231 Practice Test Questions for people ready to participate in SAS Institute A00-231 exam. The accuracy rate of SAS Base Programming Specialist A00-231 Practice Test Questions provided by PassQuestion is very high and they can 100% guarantee you pass the SAS Institute A00-231 exam successfully for one time.

A00-231 Exam Overview - SAS 9.4 Base Programming - Performance-Based Exam

The SAS Base Programming Specialist (A00-231) exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. This exam is based on SAS 9.4 M5. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis.

Exam Information

Exam Name: SAS 9.4 Base Programming - Performance-Based Exam Exam Code: A00-231 Exam Conducted: This exam is administered by SAS and Pearson VUE. Total Questions: 40-45 multiple-choice and short-answer questions. Exam Duration: 135 minutes to complete the exam. Exam Price: $180 USD Passing score: 725 (score range from 200 to 1,000 points). Exam Format: This exam is based on SAS 9.4 M5.

Exam ObjectivesAccess and Create Data Structures: 20-25%

Create temporary and permanent SAS data sets.

Investigate SAS data libraries using base SAS utility procedures.

Access data.

Combine SAS data sets.

Create and manipulate SAS date values.

Control which observations and variables in a SAS data set are processed and output.

Manage Data: 35-40%

Sort observations in a SAS data set.

Conditionally execute SAS statements.

Use assignment statements in the DATA step.

Modify variable attributes using options and statements in the DATA step.

Accumulate sub-totals and totals using DATA step statements.

Use SAS functions to manipulate character data, numeric data, and SAS date values.

Use SAS functions to convert character data to numeric and vice versa.

Process data using DO LOOPS

Restructure SAS data sets with PROC TRANSPOSE.

Use macro variables to simplify program maintenance.

Error Handling: 15-20%

Identify and resolve programming logic errors.

Recognize and correct syntax errors.

Generate Reports and Output: 15-20%

Generate list reports using the PRINT procedure.

Generate summary reports and frequency tables using base SAS procedures.

Enhance reports system user-defined formats, titles, footnotes and SAS System reporting options.

Generate reports using ODS statements.

Export data

View Online SAS 9.4 Base Programming A00-231 Free Questions

Which statement about SAS libraries is true? A. You refer to a SAS library by a logical name called a libname. B. A SAS library is a collection of one or more SAS files that are referenced and stored as a unit. C. A single SAS library must contain files that are stored in different physical locations. D. At the end of each session, SAS deletes the contents of all SAS libraries. Answer: B

Assume that Work. Ds1 and Work.Ds2 exist and the following SAS program is submitted: ods pdf file='results.pdf'; proc print data=work.ds1; run; proc freq data=work.ds1; proc freq data=work.ds2; run; ods pdf close; How many PDF files are created? A. 1 PDF file with all the output combined B. 2 PDF files -- one file for each data set used C. 2 PDF files -- one for the PRINT output and one for the FREQ output D. 3 PDF files -- one per procedure request Answer: A

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session: data sasuser.one; x=1; y=27; output one; run; A. The data set Sasuser.One is created with 2 variables and 3 observations. B. The data set Sasuser.One is created with 2 variables and 0 observations. C. The data set Work.One is created with 2 variables and 1 observation. D. The data set Sasuser.One is created with 2 variables and 1 observation. Answer: B

A PROC PRINT report was created with the following title: Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles? A. title "Distribution by Make"; B. title "Asia Sports Vehicle Summary"; title "Distribution by Make"; C. title "Asia Sports Vehicle Summary"; title2 "Distribution by Make"; D. title "Asia Sports Vehicle Summary"; subtitle "Distribution by Make"; Answer: C

The variable Name in the data set Employee has a $CHAR10. format. The variable Name in the data set Sales has a $CHAR15. format.The following SAS program is submitted: data both; merge employee sales; by name; run; What is the format for the variable Name in the data set Both? A. no format defined B. $CHAR C. $CHAR10 D. $CHAR15 Answer: C

[cymareads]

Chi Square Test

Chi-Square Statistics example evaluated here determines whether the location of a person is independent of their type of insurer. The results show that there is a significant different between the location and the type of insurer the person opts for. 

SYNTAX

PROC SQL; CREATE TABLE WORK.query AS SELECT HLTH1 , INS2A , PQ_HL3A , livepl , gender FROM _TEMP1.privateinsured; RUN; QUIT; LABEL HLTH1="Rate overall health"         INS2A="Covered through employer on union"         PQ_HL3A="Frequency of regular physical checkups"         livepl ="Living in urban, suburban, rural";

PROC FREQ; TABLES livepl*INS2A/CHISQ;

Comparison of whether the type of insurance varies based on where a person lives

 Frequency Procedure

Since the categorical variable has more than two levels, the chi-square test alone does not provide insights into why null hypothesis can be rejected. There is an indication that the type of insurer is not the same across the living space categories, but it does not indicate which categories are different from each other. For this purpose, we need to perform the Post-hoc Analysis on the Chi Square statistic.

First we perform the Bonferroni Adjustment, based on the formula, 3 categories means (0.05/3=0.017), thus we will reject the null hypothesis of the p-value is less than .017.

  PROC DATASETS NOLIST NODETAILS; CONTENTS DATA=WORK.query OUT=WORK.details; RUN; proc glm data=_TEMP0.PRIVATEINSURED;       class PQ_HL3A;       model gender=PQ_HL3A;       means PQ_HL3A / hovtest=levene welch plots=none;       lsmeans PQ_HL3A / adjust=tukey pdiff alpha=.05;       output out=work.Oneway_stats lcl=lcl ucl=ucl lclm=lclm uclm=uclm /alpha=0.05;       run; quit; PROC PRINT DATA=WORK.details; RUN; PROC FREQ; TABLES livepl*INS2A/CHISQ; DATA COMPARISON1; SET NEW; IF livepl=1 OR livepl=2; PROC SORT; BY IDNUM; PROC FREQ; TABLES livepl*INS2A/CHISQ; RUN; DATA COMPARISON2; SET NEW; IF livepl=1 OR livepl=3; PROC SORT; BY IDNUM; PROC FREQ; TABLES livepl*INS2A/CHISQ; RUN; DATA COMPARISON1; SET NEW; IF livepl=2 OR livepl=3; PROC SORT; BY IDNUM; PROC FREQ; TABLES livepl*INS2A/CHISQ; RUN;

 The Post-hoc analysis based on Bonferroni adjustment indicates that there is significant difference between means of rural and urban insurers in their type of insurer selected.

[siva3155]

300+ TOP SAS Interview Questions and Answers

SAS Interview Questions for freshers experienced :-

1. What is SAS? What are the functions does it performs? SAS means Statistical Analysis System, which is an integrated set of software products. Information retrieval and data management Writing reports and graphics Statistical analytics, econometrics and data mining Business planning, forecasting, and decision support Operation research and Project management Quality Improvement Data Warehousing Application Development 2. What is the basic structure of the SAS base program? The basic structure of SAS consist of ==DATA step, which recovers & manipulates data. ==PROC step, which interprets the data. 3. What is the basic syntax style in SAS? To run the program successfully, and you have the following basic elements: There should be a semi-colon at the end of every line A data statement that defines your data set Input statement There should be at least one space between each word or statement A run statement For example: In file ‘H: \StatHW\yourfilename.dat’; 4. Explain data step in SAS The Data step creates a SAS dataset which carries the data along with a “data dictionary.” The data dictionary holds information about the variables and their properties. 5.What is PDV? The logical area in the memory is represented by PDV or Program Data Vector. At the time, SAS creates a database of one observation at a time. An input buffer is created at the time of compilation which holds a record from an external file. The PDV is created following the input buffer creation. 6. Approximately what date is represented by the SAS date value of 730? 31st December 1961 7. Identify statements whose placement in the DATA step is critical. INPUT, DATA and RUN… 8. Does SAS 'Translate' (compile) or does it 'Interpret'? Compile 9. What does the RUN statement do? When SAS editor looks at Run it starts compiling the data or proc step, if you have more than one data step or proc step or if you have a proc step. Following the data step then you can avoid the usage of the run statement. 10. Why is SAS considered self-documenting? SAS is considered self documenting because during the compilation time it creates and stores all the information about the data set like the time and date of the data set creation later No. of the variables later labels all that kind of info inside the dataset and you can look at that info using proc contents procedure.

SAS Interview Questions 11. What are some good SAS programming practices for processing very large data sets? Sort them once, can use firstobs = and obs = , 12. What is the different between functions and PROCs that calculate the same simple descriptive statistics? Functions can used inside the data step and on the same data set but with proc's you can create a new data sets to output the results. May be more ........... 13. If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE? I would use TRANSPOSE if the variables are less use arrays if the var are more ................. depends 14. What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data? In unsorted data you can't use First. or Last. 15. How do you debug and test your SAS program? First thing is look into Log for errors or warning or NOTE in some cases or use the debugger in SAS data step. 16. What other SAS features do you use for error trapping and data validation? Check the Log and for data validation things like Proc Freq, Proc means or some times proc print to look how the data looks like ........ 17. How would you combine 3 or more tables with different structures? I think sort them with common variables and use merge statement. I am not sure what you mean different structures. 18. What areas of SAS are you most interested in? BASE, STAT, GRAPH, ETSBriefly 19. Describe 5 ways to do a "table lookup" in SAS. Match Merging, Direct Access, Format Tables, Arrays, PROC SQL 20. What versions of SAS have you used (on which platforms)? SAS 9.1.3,9.0, 8.2 in Windows and UNIX, SAS 7 and 6.12 21. What are some good SAS programming practices for processing very large data sets? Sampling method using OBS option or subsetting, commenting the Lines, Use Data Null 22. What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data? The result of any operation with missing value will result in missing value. Most SAS statistical procedures exclude observations with any missing variable vales from an analysis. 23. How would you create a data set with 1 observation and 30 variables from a data set with 30observations and 1 variable? Using PROC TRANSPOSE 24. What is the different between functions and PROCs that calculate the same simple descriptive statistics? Proc can be used with wider scope and the results can be sent to a different dataset. Functions usually affect the existing datasets. 25. If you were told to create many records from one record, show how you would do this using array and with PROC TRANSPOSE? Declare array for number of variables in the record and then used Do loop Proc Transpose with VARstatement 26. What are _numeric_ and _character_ and what do they do? Will either read or writes all numeric and character variables in dataset. 27. How would you create multiple observations from a single observation? Using double Trailing @@ 28. For what purpose would you use the RETAIN statement? The retain statement is used to hold the values of variables across iterations of the data step. Normally, all variables in the data step are set to missing at the start of each iteration of the data step.What is the order of evaluation of the comparison operators: + - * / ** ()?(), **, *, /, +, - 29. How could you generate test data with no input data? Using Data Null and put statement 30. How do you debug and test your SAS programs? Using Obs=0 and systems options to trace the program execution in log. 31. What can you learn from the SAS log when debugging? It will display the execution of whole program and the logic. It will also display the error with line number so that you can and edit the program. 32. What is the purpose of _error_? It has only to values, which are 1 for error and 0 for no error. 33. How can you put a "trace" in your program? By using ODS TRACE ON 34. How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs? Missing values will be assigned as missing in Assignment statement. Sort order treats missing as second smallest followed by underscore. 35. How do you test for missing values? Using Subset functions like IF then Else, Where and Select. 36. How are numeric and character missing values represented internally? Character as Blank or “ and Numeric as. 37. Which date functions advances a date time or date/time value by a given interval? INTNX. 38. In the flow of DATA step processing, what is the first action in a typical DATA Step? When you submit a DATA step, SAS processes the DATA step and then creates a new SAS data set.( creation of input buffer and PDV) Compilation Phase Execution Phase 39. What are SAS/ACCESS and SAS/CONNECT? SAS/Access only process through the databases like Oracle, SQL-server, Ms-Access etc. SAS/Connect only use Server connection. 40. What is the one statement to set the criteria of data that can be coded in any step? OPTIONS Statement, Label statement, Keep / Drop statements. 41. What is the purpose of using the N=PS option? The N=PS option creates a buffer in memory which is large enough to store PAGESIZE (PS) lines and enables a page to be formatted randomly prior to it being printed. 42. What are the scrubbing procedures in SAS? Proc Sort with nodupkey option, because it will eliminate the duplicate values. 43. What are the new features included in the new version of SAS? The main advantage of version9 is faster execution of applications and centralized access of data and support. There are lots of changes has been made in the version 9 when we compared with the version8. The following are the few:SAS version 9 supports Formats longer than 8 bytes & is not possible with version 8. Length for Numeric format allowed in version 9 is 32 where as 8 in version 8. Length for Character names in version 9 is 31 where as in version 8 is 32. Length for numeric informat in version 9 is 31, 8 in version 8. Length for character names is 30, 32 in version 8.3 new informats are available in version 9 to convert various date, time and datetime forms of data into a SAS date or SAS time. ·ANYDTDTEW. - Converts to a SAS date value ·ANYDTTMEW. - Converts to a SAS time value. ·ANYDTDTMW. -Converts to a SAS datetime value.CALL SYMPUTX Macro statement is added in the version 9 which creates a macro variable at execution time in the data step by · Trimming trailing blanks · Automatically converting numeric value to character. New ODS option (COLUMN OPTION) is included to create a multiple columns in the output. 44. WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS. The SAS 9 Architecture is fundamentally different from any prior version of SAS. In the SAS 9 architecture, SAS relies on a new component, the Metadata Server, to provide an information layer between the programs and the data they access. Metadata, such as security permissions for SAS libraries and where the various SAS servers are running, are maintained in a common repository. 45. What has been your most common programming mistake? Missing semicolon and not checking log after submitting program, Not using debugging techniques and not using Fsview option vigorously. Name several ways to achieve efficiency in your program.Efficiency and performance strategies can be classified into 5 different areas. CPU time Data Storage Elapsed time Input/Output Memory CPU Time and Elapsed Time- Base line measurements 46. Few Examples for efficiency violations:Retaining unwanted datasets Not sub setting early to eliminate unwanted records. Efficiency improving techniques: Using KEEP and DROP statements to retain necessary variables. Use macros for reducing the code. Using IF-THEN/ELSE statements to process data programming. Use SQL procedure to reduce number of programming steps. Using of length statements to reduce the variable size for reducing the Data storage. Use of Data _NULL_ steps for processing null data sets for Data storage. 47. What other SAS products have you used and consider yourself proficient in using? Data _NULL_ statement, Proc Means, Proc Report, Proc tabulate, Proc freq and Proc print, Proc Univariate etc. What is the significance of the 'OF' in X=SUM (OF a1-a4, a6, a9);If don’t use the OF function it might not be interpreted as we expect. For example the function above calculates the sum of a1 minus a4 plus a6 and a9 and not the whole sum of a1 to a4 & a6 and a9. It is true for mean option also. 48. How to use IF THEN ELSE in PROC SQL? PROC SQL; SELECT WEIGHT, CASE WHEN WEIGHT BETWEEN 0 AND 50 THEN ’LOW’ WHEN WEIGHT BETWEEN 51 AND 70 THEN ’MEDIUM’ WHEN WEIGHT BETWEEN 71 AND 100 THEN ’HIGH’ ELSE ’VERY HIGH’ END AS NEWWEIGHT FROM HEALTH; QUIT; 49. How to remove duplicates using PROC SQL? Proc SQL noprint; Create Table inter.Merged1 as Select distinct * from inter.readin ; Quit; 50. How to count unique values by a grouping variable? You can use PROC SQL with COUNT(DISTINCT variable_name) to determine the number of unique values for a column. 51. What is the one statement to set the criteria of data that can be coded in any step? Options statement. 52. What is the effect of the OPTIONS statement ERRORS=1? The –ERROR- variable ha a value of 1 if there is an error in the data for that observation and 0 if it is not. 53. What do the SAS log messages "numeric values have been converted to character" mean? What are the implications? It implies that automatic conversion took place to make character functions possible. 54. Why is a STOP statement needed for the POINT= option on a SET statement? Because POINT= reads only the specified observations SAS cannot detect an end-of-file condition as it would if the file were being read sequentially. 55. How do you control the number of observations and/or variables read or written? FIRSTOBS and OBS option SAS Questions and Answers Pdf Download Read the full article

[nox-lathiaen]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs Source: http://jobrealtime.com/jobs/technology/sas-tableau-consultant_i3962

[ebaggusa]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://ebagg.com/jobs/technology/sas-tableau-consultant_i4005

[jobsaggregationco]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ��  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://jobsaggregation.com/jobs/technology/sas-tableau-consultant_i3962

[qoholiccom]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://www.qoholic.com/jobs/technology/sas-tableau-consultant_i5570

[jobrealtimeco]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://jobrealtime.com/jobs/technology/sas-tableau-consultant_i3962

[jobsaggregationcom]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://jobsaggregation.com/jobs/technology/sas-tableau-consultant_i3962

[cvwing]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://cvwing.com/jobs/technology/sas-tableau-consultant_i5230

[qoholicjobs]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://www.qoholic.com/jobs/technology/sas-tableau-consultant_i5570

[robertflehman]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs from Latest listings added - JobRealTime http://jobrealtime.com/jobs/technology/sas-tableau-consultant_i3962

[linkhello]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs source http://linkhello.com/jobs/technology/sas-tableau-consultant_i4155

[dexnurseyheadcanons]

SAS/ Tableau Consultant

Job Title: SAS/ Tableau Consultant Location: Indianapolis IN Duration: Contract Client: UST Global/ Anthem   Job Description: Skill-SAS/Tableau(Anthem EDS or EDWARDS exp is mandatory)  SAS EG intermediate to advanced SAS programmer/user with at least 3-6 years of PC SAS or SAS EG experience (recent experience) · Must be proficient in writing syntax, specifically using the following procedures and functionalities, i.e. ü  DATA STEP ü  PROC SQL ü  PROC SORT ü  PROC FREQ ü  PROC TABULATE ü  PROC REPORT ü  ODS (HTML, EXCEL, PDF) ü  Macros ü  Arrays ü  Format/Informats Tableau, a minimum of 3 years of experience using Tableau including the connection to data and creation of dashboards. Skills and experience to include: ü  Connecting to data, edit and save a data source. ü  Knowledge of Tableau terminology. ü  Use the Tableau interface / paradigm to effectively create powerful visualizations. ü  Use of statistical techniques to analyze data. ü  Use of parameters and input controls to give users control over certain values. ü  Prepping data for analysis. ü  Combining data sources using data blending. ü  Combining data from multiple tables in the same data source using joins. ü  Experience using the Data Engine, extracts, and efficient connection methods to improve visualization performance. ü  Creating intermediate to advanced calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations. ü  Representing data using the following complex visualization types: o   Cross tabs o   Advanced geographic mapping techniques.  Using custom images and geocoding to build spatial visualizations of non-geographic data. o   Heat maps o   Tree maps o   Pie charts and bar charts o   Dual axis and combined charts with different mark types o   Highlight Tables o   Scatter Plots o   Building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. ns to business partners · Proactive in nature with customer satisfaction as primary goal. Reference : SAS/ Tableau Consultant jobs Source: http://jobsaggregation.com/jobs/technology/sas-tableau-consultant_i3962