Posted on

Not seeing a MySQL table I just created

I created a new blank MySQL database.  I couldn't see it when accessing it via. phpMyAdmin.   I only saw two old MySQL databases.

It turns out that the new one was associated with a different user name.   I had to log out of the screen first by clicking on one of the icons on the left-upper side of the phpMyAdmin window.   After the log-out, I logged in with the right user name and the password, when I was able to see all MySQL databases I needed to see.

Each phpMyAdmin session is specific to each of the users I created.

Posted on

When the computer stops connecting to the Internet

My company laptop stopped connecting to the Internet.  It was connected to Wifi, but my Outlook, Skype, the browsers were not responding.  The problem was that the computer was not finding the right parameters for IP and DNS server addresses.   This is how the technician fixed it for me.

Right-click the wi-fi icon at the right bottom corner of the screen and chose "open network and sharing center."

On the left side of the window that just opened, click on "Change adapter settings."  Find the computer icon that is active.  In my case, I see seven computer icons and one of them with "Wi-Fi" is highlighted.  Other icons say "disabled," "not connected," "network cable unplugged," etc.  Right-click on the right computer icon and choose "properties."

The window "Wi-Fi properties" will pop up.  Scroll down to Internet Protocol Version 4 and click on it.  If your setting is right, you will see the following two active/clicked on:

  • Obtain an IP address automatically
  • Obtain DNS server address automatically

If these were not selected (and instead the specific values were chosen), you need to select them.

I think the automatic setting means that the computer will flexibly and dynamically choose whatever IP address and DNS server address are relevant at the time of active connection.  In other words, the reason why the computer was not connecting to the Internet was that the specific values for the IP and DNS server addresses were imposed on  the computer for an unknown reason.

 

 

 

Posted on

Suppress graphic printing in SAS

SAS prints graphics by default.  This can be suppressed by:

ods graphics off;

To suppress printing specifically of PROC REG, add the following to the PROC REG  statement:

PLOT(MAXPOINTS=NONE)

 

Official examplanation:

MAXPOINTS=NONE | max <heat-max>

suppresses most plots that require processing more than max points. When the number of points exceeds max but does not exceed heat-max divided by the number of independent variables, heat maps are displayed instead of scatter plots for the fit and residual plots. All other plots are suppressed when the number of points exceeds max. The default is MAXPOINTS=5000 150000. These cutoffs are ignored if you specify MAXPOINTS=NONE.

Thanks MM.

Posted on

PHP if statement

if ($money > $taxIncludedPrice) {
echo 'You can buy this item';
} elseif ($money == $taxIncludedPrice) {
echo 'You can buy this item, but you will not have any money left';
} else {
echo 'You cannot buy this item';
}

Posted on

Baseline equivalence for QED (Quasi-experimental study)

https://ies.ed.gov/ncee/wwc/Document/33#/typesout

"In addition, if there is evidence that the populations were drawn from very different settings, the principal investigator may decide that the environments are too dissimilar to provide an adequate comparison. The High School Mathematics review team also will examine other baseline characteristics (when available) to assess baseline equivalence of studies. These characteristics include, but are not limited to, the following:

  • Gender
  • Socioeconomic status
  • Racial/ethnic breakdown
  • Percentage of English as a second language students
  • Percentage of bicultural students
  • “At-risk” status (as provided by study authors)
  • Location of the schools involved
  • Homogeneous groupings of students
  • School type (public, private, religious)
  • School SES (e.g., Title I school)
  • Average class size (small, medium, large)
  • Average teacher characteristics (e.g., teacher education and experience)
  • School size

The provision of all such information, however, is not a requirement of the review."

 

Posted on

How I activated a new Essential phone without visiting a Verizon store

-- October 17th, 2018

I dropped my Samsung Phone and broke it.   I was planning to buy a new phone anyways, so I ordered a ESSENTIAL phone on Amazon.   The price was $340 plus tax, which was substantially cheaper than an i-phone or a Samsung phone (price range $800-$1000).  If you directly order it from Essential website, the price is $499 and the phone comes with accessories (click here).

I always bought my phones at a Verizon service vendor, but my cousin assured me that buying a smartphone online is easy.  My cousin also told me that ESSENTIAL phones are made by Andrew Rubin who created the android OS system.  Their website was sharp looking and Internet reviews were positive.  One review said that Essential phones are compatible with my phone provider, Verizon.  To state my conclusion first:

  • I got the phone started within two hours of receiving it
  • I was able to get it started without calling Verizon or changing options on my Verizon online account.   A Verizon store would charge me at least $20 to switch a SIM card.  I did not have to order a new SIM card from my online account.
  • I needed
    • a small flat screw driver to open the old Sam Sung phone's back cover and a sharp and tiny need-like thing to open the Essential phone's SIM slot (the Essential phone came with a pin to open the phone's SIM slot).
    • a pair of scissors to cut the SIM card to the nano size (my original Sam Sung phone SIM card was one size larger than the nano size).

When the Essential phone arrived the next day, I took out the SIM card out of my old Samsung Galaxy S4.  I had to flip the backside panel open using a sharp object (I used the IFIXIT driver kit tool).  With the new phone, I pressed the SIM card slot inward till it popped out.

The SIM card was larger than the nano SIM card required by Essential ph-1.  Following the Internet discussion, I cut the plastic part of the card to make it small.  I didn't use the size template that people said one should use.  I just used a pair of scissors.  I cut it too small, so I put a Scotch tape on the back of the SIM card to stick it to the slot firmly.  I didn't want the tape to touch the golden side of the SIM card too much, but my understanding is that the only essential part is the center part of the gold side.

I thought hard about which side should be up, but the card can fit into the slot only in one way (because one corner of the card and the slot are both diagonally cut and they only match in one way/direction).

The phone did not start working immediately.  I took the SIM card out and put it back a couple of times.  At one point the phone started receiving texts.  I was also able to send texts.  The phone still did not work.  It started working when I followed the Internet instruction "Disable Enhanced 4G LTE Mode."  This option was somewhere in the setting.

The downside of this product.  As I predicted with confidence on Day 1, I lost an audio adopter (called Type C) necessarily to use the headset.  The essential phone does not take the standard 3.5mm cable that an i-phone or a Samson phone uses.  I ordered a cable on Amazon ($7.89), but the product that came (this) did not work with my essential phone.  I had to pay $15 and shipment fee ($7.95) to order a new one at:

Audio Adapter

So all together losing the adopter cost me 31 US dollars.

Posted on

SAS propensity score matching procedure

proc psmatch data=psm region=cs;
where &outcome ne .;
class FLAG  districtname SCHOOLNAME ;
psmodel FLAG(Treated="Y")= &exactvar &predictors;
match method=greedy(k=1)/*(order=random)*/ exact=districtname stat=lps caliper=&caliper;
output out(obs=match)=outgs lps=_Lps matchid=_matchID;
run;
proc sort data=outgs;by _matchID;run;