When SAS-importing is not working

proc import out=work.test

datafile='C:\sastest\excelfile.xlsx'

dbms=xlsx replace;

sheet='Sheet1';

run;

proc export data=sashelp.class

outfile='C:\sastest\excelfile2.xlsx'

dbms=xlsx replace;

sheet='Sheet2';

run;

Logitech H800 no sound problem

I have to say I spent about an hour trying to figure out how to use it off a PC. It worked immediately for my Samsung phone, but it refused to produce sound off my PC. After internet-searching for solutions, I made it work. Here is how:

a) Go to http://support.logitech.com/en_us/product/wireless-headset-h800and scroll down to […]

R Studio

DPLYR is some kind of module that allows efficient data management.

library(dplyr)

 

This keeps rows that has a specified value:

filter(dataname,School=="Ad High School")

x <- filter(dataname,School=="Ad High School")

 

How to derive standard deviation from standard error

Algorithm:

SD=Standard error * sqrt(N);

 

Reference:

http://handbook.cochrane.org/chapter_7/7_7_3_2_obtaining_standard_deviations_from_standard_errors_and.htm

 

QC: I checked the algorithm using SAS. The result was consistent with the algorithm (i.e., SD=standard error*sqrt(N)).

proc means data=sashelp.class mean std stderr n; var height; run;

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ Mean 62.3368421

SD 5.1270752

Stadard Error 1.1762317

N 19 ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Open source softwares

 

–Python 3.5

https://www.python.org/downloads/

–PHP & MySQL (from WampServer)

http://www.wampserver.com/en/

Statistical Analysis Program

–R

https://cran.cnr.berkeley.edu/

–GPower

http://www.gpower.hhu.de/en.html

–Optimal Design

https://sites.google.com/site/optimaldesignsoftware/home

Editing Programs

— NotePad++

https://notepad-plus-plus.org/download/v7.1.html

–Sigil

https://github.com/Sigil-Ebook/Sigil/releases/tag/0.9.6 (There is a link to the exe file at the bottom of the page. […]

Code Academy PHP problem sets

<html> <p> <?php // Create an array and push on the names // of your closest family and friends $fam=array(); array_push($fam,"Jeana"); array_push($fam,"Niko"); array_push($fam,"Kaz"); array_push($fam,"Hiroko"); array_push($fam,"Yoko"); print count($fam); $n_elements=count($fam); // Sort the list sort($fam); // Randomly select a winner! $roll=rand(1,$n_elements); print $roll; $which_person= $array[$roll]; print $which_person; // Print the winner's name in ALL CAPS $which_person2=strtoupper($which_person); print […]

Data and Statistical Programming downloads

Programming

–Python 3.5

https://www.python.org/downloads/

 

–PHP & MySQL (from WampServer)

http://www.wampserver.com/en/

 

Statistical Analysis Program

–R

https://cran.cnr.berkeley.edu/

–GPower

http://www.gpower.hhu.de/en.html

–Optimal Design

https://sites.google.com/site/optimaldesignsoftware/home

 

Editing Programs

— NotePad++

https://notepad-plus-plus.org/download/v7.1.html

–Sigil

https://github.com/Sigil-Ebook/Sigil/releases/tag/0.9.6 (There is a link to the exe file at the bottom of the page.

 

 

 

 

How to implement an algorithm using R

This is an example for calculating Body Mass Index using height and weight.

The first line sets the working directory in which the CSV file is located.

setwd("C:/Users/123/Documents/R")

temp <- read.csv(file="practice_data.csv",header=TRUE,sep=",")

bmi=temp$weight/temp$height

bmi

 

This is the CSV file, practice_data.csv.

Name,height,weight John,1.6,50 Mary,1.7,55 Ed,1.5,44 David,1.3,65

RCTs and QEDs

The last two digits of Social Security Number are random numbers.

Online Universities

Coursera https://www.coursera.org