SAS programming (600 USD)Browse Courses Email to a Friend Course details How online training happens?
Steps: Free session -> Make offer or Register -> Mentor accepts and Invoices -> Pay us -> Course begins
Price: 600 USD
Get a free session
Email to a friend
Feedbacks on online training Post feedback
|Would recommend it to someone, who has never seen an ETL tool before and if they need an intro and want to familiarise with the tool.Most of the basics have been dealt with.|
|I believe this to be my best foot forward so far. Anirban has been an inspirational tutor with the Oracle EBS Suite and I will recommend any and everyone interested to pursue this opportunity in Oracle Financials/CRM/SCM to learn from him. He has - Tutored me to detail - Spared time to clear any question I have at any possible time - Been on schedule for every class - The intricate knowledge of the entire EBS suite. Ive rarely thought a virtual class could be so effective MJM|
|If I have to summarize the quality of Anirban's Oracle RAC Traianing course in a word, I would say "EXCELLENT". Worth every penny. That should tell you everything you need to know. Go ahead and take the course.|
|This was my second class with Anirban. Anirban is an expert on Oracle RAC and High Availability. He has real world experience and as such he can answer any question, right from very basic to very advanced/complicated. His style of teaching is excellent. He explains in a very clear, concise manner and then shows an example of "How to do it". This helped me understand all the topics quickly. The documentation he provided was very helpful. The powerpoint slides, MS-word and Text documents he provided are very useful. I highly recommend him to anyone planning to take Oracle RAC/High Availability classes.|
|Anirban is an expert in Oracle RAC, DataGuard and Replication. He explains very complex topics in a clear, concise manner. The lab exercises give you a very good hands-on experience. He answered all my questions to my satisfaction ( he also answered some questions that were not directly related to Oracle RAC). I highly recommend him for any Oracle class. I am planning to take his classes on Data Guard.|
Read All Comments
Questions on online training
|No questions asked yet|
Description of online training
Mentor: Anirban Dhar Contact: firstname.lastname@example.org / 978 996 0551
INTRODUCTION TO SAS 1. What is SAS system? 2. The SAS language 3. SAS data sets 4. SAS Variables 5. The two parts of a SAS program 6. The DATA step’s built-in loop 7. The SAS Log and Output files 8. Using SAS system for Windows 9. Using SAS system options 10. HELP!!!
|Mentor Profile||ƒæ Technical professional with 17 years of experience in Application Development, Architecture, Data Warehouse & CRM, ETL, Data mining, Analytics, DATAMART and Reporting, Database management, technical training and IT management. ƒæ Comprehensive background as an application manager, project manager, application and database architect, system developer, training manager and technical advisor. Proactive leader and conceptual thinker with a superior work ethic. ƒæ Multiple Functional expertise include risk management, fraud checking, customer acquisition system, credit verification and authentication, PREPAY, PREAPPROVALS and customer LEADS, Retail Management System (RMS), telecom, banking, consumer finance and manufacturing. ƒæ Proven expertise in the development and deployment of technical strategies and solutions in support of strategic customer business initiatives. Skilled in developing and directing cross-disciplinary technical teams. Adept in working within service level agreements with various clients to achieve maximum customer satisfaction. ƒæ Energetic and self-motivated team player/builder. Effective in work situations requiring an ability to manage multiple, concurrent and senior-level projects and responsibilities. ƒæ Exceptional communication, interpersonal, technical, analytical, strategic planning, troubleshooting, problem solving and leadership skills. Thrive in both independent and collaborative work arenas. ƒæ SOX, ISO 9002 and SEI CMM level 5 quality management procedure implementation experiences in past organizations. Certified by STQC(BIS) as an internal auditor.|
Mentor: Anirban Dhar Contact: email@example.com / 978 996 0551
INTRODUCTION TO SAS 1. What is SAS system? SAS system is an integrated applications system that provides complete data processing and analysis capabilities. • SAS can access variety types of data. • Data management features include updating, rearranging, combining, editing, and subsetting (and many more). • Analytical tools range from simple descriptive statistics to more advanced and specialized analyses for biostatistics and epidemiologic applications (and many others). • Data presentation capabilities range from simple lists and tables to multidimensional plots and full-color graphics. 2. The SAS language SAS provides a full-featured, high-level programming language that gives you total control over your data. SAS programs • A SAS program is a sequence of statements: Executable and nonexecutable statements. • SAS statements are step-by-step instructions that tell SAS to perform specific tasks. • Each group of statements is called a SAS step: Data step and Proc step. • SAS programs may consist of one or many SAS steps. SAS statements • Every SAS statement ends with a semicolon (;). • SAS statements can be in upper or lower case, can take up more than one line, and can start in any column. Errors • Syntax errors are errors made in SAS statements. Examples are misspelled keywords, missing semicolons, unmatched quotes, and other punctuation errors. • Data errors occur when data values do not match the values expected. An example is not specifying a character variable ($) for character data in the INPUT statement. • Logic errors occur when conditions and/or sequence of SAS statement are written incorrectly. SAS does not produce error messages for logic errors, so the errors could only be found in unexpected results. Examples are mis-specified conditions and misplaced SAS statements. 3. SAS data sets SAS reads data and organizes the data into a SAS data set. • Data must be stored in a SAS data set for SAS to be able to identify and access. • SAS can then be used to display, revise, and analyze data. SAS data sets contain data values organized into variables and observations. • A variable is a set of data values that describe a specific characteristic (e.g. age or gender). • Each column of data values in a SAS data set is a variable. • Each variable is identified by a variable name. • An observation is a set of data values for the same item (e.g., person or visit). • Each row of data values in a SAS data set is an observation. 4. SAS Variables • In SAS Version 8, variable names may be up to 32 characters long (8 characters in Version 6), start with a letter or _ (underscore), and cannot include special characters (%, &, $, #, @, *, !). • Numeric data may contain numbers, +,-, decimal points, scientific notation (E). • Character data may contain anything. • Missing numeric data are represented by a dot (.); missing character data are represented by a blank (‘ ’). 5. The two parts of a SAS program The DATA step • A SAS Data step is a group of statements that builds a SAS data set. • Each Data step begins with a DATA statement and ends with a RUN, DATA or PROC statement. • The purpose of a Data step is to create or modify data. Data steps may also be used to produce raw data (ASCII file) from an existing SAS data set. • Data steps generally produce no results or reports in the SAS Output window. The PROC step • A SAS Proc step (or a SAS procedure) is a prewritten computer program that processes or analyzes SAS data sets. • Each Proc step begins with a PROC statement and ends with a RUN, DATA or PROC statement. • The purpose of a Proc step is to perform a specific analysis or function. • Proc steps generally produce results or reports in the SAS Output window. 6. The DATA step’s built-in loop DATA steps execute line-by-line and observation-by-observation. • SAS reads the DATA statement, creates the structure of a SAS data set, and marks the statement as the point to begin processing for each data line. • SAS assigns missing values to all variables (except the special variable _N_) before the INPUT statement is executed. _N_ is incremented by one for each iteration of the data step (_N_=1 before the first iteration; _N_=2 before the second iteration). • SAS uses the description in the INPUT statement to read the data line and produce an observation, substituting the actual data values for the missing values. These values are placed in the Program Data Vector (PDV), which is a temporary holding area where data values are held before being written to the SAS data set. • SAS then uses the observation to execute any other SAS statements that are present (creation of new variables, variable recodes, etc.). • Finally, SAS adds the observation to the data set being created. • This cycle continues until all the observations have been written to the SAS data set. 7. The SAS Log and Output files • The SAS log contains the SAS version number, program statements, number of observations, variables in data set, computer resources used, page numbers to locate output (if any), error messages, warnings, and other notes. • Read the log!! • The output file contains any output requested in the SAS program–there may be no output if the program did not request any output. • There may be no output if the program bombed–read the log!! 8. Using SAS system for Windows Writing and editing SAS programs in program editor • Type text of program in editor window, or open existing program by following file-open menu path. • Submit SAS programs or to edit other text files (e.g., data and output files). • Graphical environment enables use of edit menu for cutting and pasting, etc. Executing programs • Use locals-submit menu path to submit program. Viewing the log and output • Click on the appropriate window or choose globals-log (for SAS log) or globals-output (for program output) menu path. • Use help-keys to see how function keys are defined. • Use edit-clear text to clear window. • Use locals-recall text to get program back in editor window. 9. Using SAS system options • System options stay in effect for duration of SAS session. • To see current system settings, type: PROC OPTIONS; RUN; • OPTIONS statement: keyword options followed by the option. • Common options include: center | nocenter, date | nodate, number | nonumber, linesize=n where n=64-256, pagesize=n where n=15-32767, pageno=x (x=1 if you want page no.1 to be at the top of each new requested output during a SAS session), compress=yes. 10. HELP!!! • www.sas.com SAS online documentation
How to Join a live session, clas schedule info
How to Join live session
Class start, payment details and refund policy
- Step 1: When you pay, you only "authorize" us to pay. The actual money moves from your account after the class starts. If class does not start in the pre-scheduled time, you have an option of withdrawing your authorization.
- Your money is held in a escrow account class gets started. After the course gets over, we check with you if you are satisfied, then only money passed to the mentor. In case you are not, complete or partial refund is given to you after case is handled by our dispute resolution department.
Always remember to complete your transactions on LearnersParadise-
it's the safer way to do business.
Is there an offer to pay for the course or get paid directly outside LearnersParadise? If so, please help make the this marketplace safer by reporting it to us. These "outside" transactions may be unsafe and are against our policy.
- All our learning/training happens online. So you can join from any part of the world as long as you have broadband internet connection. In fact 25% of our students are from UK, Europe and India. For audio, you can use Skype and for visual you can just use our online meeting tools which works the same way from any location.
For payment, we accept all International Visa or Master cards. Since the
course fees are all listed in USD, you still pay in USD. In your credit
card statement, it will show in the currency from your country.
For example: if the course fees is $ 100 and you are from India and exchange rate for that day is = Rs 46.5 You can use your Master/Visa card or paypal to pay 100 in USD just like any studnet from US. your bank statement it will show Rs. 4,650.00 transaction from LearnersParadise.com
Class Start date
- mentor is currently busy with students and has not decide yet on the next class start date or ..
- mentor took a break and have not yet activated the class or fogotten to do so.
- Step 1: Send a quick message to mentor with your interest and see if he/she gets back and activates the listing.
- Note: Mentor may not respond despite your efforts in case he is not available to take the course any more. From our experience in the past most of the mentors respond once they hear from interested people even if their course listing is not showing them active.