KB: SAS cheat sheet

Histogram

proc univariate data=passenger;
 histogram N;
 run;

Mean, Frequency

proc means data=passenger;
 var N;
 run;

proc freq data=t1_santa;
weight n;
tables believe*age / chisq;
run;

ROC

proc logistic data=challenger_data descending plots=(EFFECT ROC(id=prob));
   model failure = temp;
run;

Reading tab delimited text file

data t2_crab;
infile "c:\temp\crab.txt" dsd dlm='09'x;
input id t wt w sa;
run;

Reading tab delimited text file, skipping the header row

data t2_crab;
infile "c:\temp\crab.txt" dsd dlm='09'x firstobs=2;
input id t wt w sa;
run;

Reading tab delimited text file, with string longer than 8 chars

data epl;
infile "C:\temp\epl.txt" dsd dlm='09'x ;
input season_team:$40. season:$9. stage team:$30. opp:$30. team_season_pos opp_season_pos team_goal opp_goal net_pos net_goal home_away:$1. result:$1. form:$3.;
run;
Advertisements

KB: R script sample

coupon <- c("A","B","C","D")

generate_set<-function(coupon_set,i,n){
  if(i==n){
    cat(coupon_set)
    cat("\n")
  }else{
    for(c in coupon){
      generate_set(paste(coupon_set,c,sep=""),i+1,n)
    }
  }
}

sink("d:/temp/q6_10.txt")
generate_set("",0,10)
sink()

q6<-read.table(file="d:/temp/q6_10.txt")
q6$win<- grepl("A",q6$V1) & grepl("B",q6$V1) & grepl("C",q6$V1) & grepl("D",q6$V1)
summary(q6$win)
sum(q6$win)/nrow(q6)

KB: Simple Line Chart in R

x=seq(-10,10,0.1)
y2=x^2
y3=x^3

plot(
  x=x,
  y=y2, type="l", ylim=c(-100,100), col="red", ylab="f(x)"
)
lines(x,y3, type="l", ylim=c(-100,100), col="blue")
legend("bottomright",c("f(x)=x^2","f(x)=x^3"), lty=c(1,1), col=c("red","blue"))

HOWTO: OpenWRT and Fiddler for HTTP and HTTPS Transparent Proxy traffic capture – Part 2

Goal:

  • Setup a Hyper-V test lab for capturing traffic from an Android client.
  • Use OpenWRT as the routing gateway for the private VM network and Transparent Proxy HTTP and HTTPS traffic to Fiddler.
  • Config Fidder for traffic capture.

See Also:


Configuring OpenWRT for Transpart Proxy

  • Create Port Forward / Pre-routing rules for TCP port 80 and 443 to forward traffic to Fiddler.
    • Assuming Fiddler is running at 192.168.1.2, port 8888 for HTTP proxy and 8443 for HTTPS proxy.
    • Exclude the Fiddler machine from the port forward.


  • Create Source NAT / Post-routing rule


     

  • OR write the rules in the Firewall Custom Rules page.


     

Configuring Fiddler for Transpart Proxy

  • Enable “Allow remote computers to connect” in Fiddler Options and open corresponding ports in the Windows Firewall.


  • Use the command “!listen 8443 your_dummy_CN” to make Fiddler to listen to port 8443 for HTTPS proxy.
    • The dummy CN value is important. Without the CN value Fiddler will not handle the HTTPS handshake.


  • Use the command “prefs set fiddler.network.https.SetCNFromSNI true” to make Fiddler to generate the cert with CN to match the incoming request.