Latest from the blog

A Truly Fundamental of SQL Statements.

November 19, 2013 Billy Aung Myint No comment

The SELECT clause is used to restrict the columns , or expressions returned from the table.
The WHERE clause uses a condition to quantify or restrict the query results to only …

Oracle SQL Programming Course

November 15, 2013 Billy Aung Myint No comment

Just done with the oracle SQL programming and phew! It certainly wasn’t as light as I had thought. Even with basic SQL experience done at the Degree level , I …

SAS Programming Language – Inconsistencies

November 10, 2013 Billy Aung Myint No comment

Here are two SAS programs , data and sort

data work.comp;
set myLib.sales;
Bonus=500;
Compensation=sum(Salary,Bonus);
BonusMonth=month(Hire_Date);
run;

Note that temporary library , work , comes before the permanent library from where the data …

SAS – Base Programming – Tutorial 1 – Sort

November 9, 2013 Billy Aung Myint No comment

*Set the library name and path. Note that this is a permanent library.
libname mylib ‘d:\temp\prg1’;
 
*Call the proc sort and set output the sorted data , by descending Country and within …

R Statistical Language for Analysis – Libraries

November 9, 2013 Billy Aung Myint Comments Off on R Statistical Language for Analysis – Libraries

Okie dokie … here is how you go about installing R libraries or packages as they are called in R , actually they are called both … Wonder why.

>install.packages(“package-name”)

Steps in Data Analysis

November 9, 2013 Billy Aung Myint Comments Off on Steps in Data Analysis

Things I learn from Coursea , Data Analysis – John Hopkins – Jeffrey Leek.

Define the question
Define the ideal data set
Determine what data you can access
Obtain the data
Clean the data
Exploratory data …

SAS Training Experience

November 4, 2013 Billy Aung Myint Comments Off on SAS Training Experience

Recently , I thought of how I can improve myself both as a person and career and started to find something I can grow into. Then registered for a few …