BiSpecialist

Tuesday, April 21, 2015

SAS - Introduction

SAS - Statistical Analysis System

Data Sets: SAS stored data in 'SAS data sets'. Data sets are like tables in a database.

Rows (records) are called Observations

Columns (fields) are called variables.

Libraries: SAS stores data sets in Libraries (like directories or folders). 'Work' is a default library.

Sunday, April 12, 2015

Shutdown mysql

sudo mysqladmin shutdown

Sunday, February 22, 2015

Font-Family


   font-family: Menlo, Monaco, Consolas, monospace;

Saturday, December 27, 2014

Android Studio Was Unable To Find a Valid JVM

Run the following at terminal:

launchctl setenv STUDIO_JDK /Library/Java/JavaVirtualMachines/jdk1.8.0_25.jdk

do shell script "launchctl setenv STUDIO_JDK /Library/Java/JavaVirtualMachines/jdk1.8.0_25.jdk"

(OR)

Wednesday, November 12, 2014

D3 local webserver

Command line:

for Python3.x:

python3 -m http.server 8888 &

(or)

for Python2.x:

python -m SimpleHTTPServer 8888 &

The above code will activate the port 8888.

Then open the following URL.

http://localhost:8888/

Tuesday, September 2, 2014

String Function - STUFF

SELECT HD.GroupName,

STUFF((SELECT distinct '; ' + D.Name FROM HumanResources.Department D

WHERE D.GroupName = HD.GroupName

FOR XML PATH('')), 1, 1, '') Name_Group

FROM HumanResources.Department HD

GROUP BY HD.GroupName

ORDER BY HD.GroupName