Reference

SQL vs DATA step

subset

columns

select col1, col2
from

rows

select *
from **
where (condition)

use calculated variable

where calculated newvar > 14;

based on summary stats

SELECT * FROM ex.admits
WHERE (bp_sys GE
	(SELECT MEAN(bp_sys)+ 2*STD(bp_sys))
		FROM ex.admits))
			OR (bp_sys LE
(SELECT (MEAN(bp_sys) - 2*STD(bp_sys))
FROM ex.admits));

subquery

Join

Inner

rows matched in both tables

from dat1 as a, dat2 as b
where a.id = b.id

or

from dat1 a INNER JOIN dat2 b
on id1 = id2

Three table

from a, b, c
where (id1 = id2) AND (hosp = hosp_id)

Left

keep the rows not matched in left

Summary

COUNT = N
MIN
MAX

operator

where primdx LIKE '410%'
IN

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">

  // Load the Visualization API and the piechart package.
  google.load('visualization', '1.0', {'packages':['corechart']});

  // Set a callback to run when the Google Visualization API is loaded.
  google.setOnLoadCallback(drawChart);

  // Callback that creates and populates a data table,
  // instantiates the pie chart, passes in the data and
  // draws it.
  function drawChart() {

    // Create the data table.
    var data = new google.visualization.DataTable();
    data.addColumn('string', 'Topping');
    data.addColumn('number', 'Slices');
    data.addRows([
      ['Mushrooms', 3],
      ['Onions', 1],
      ['Olives', 1],
      ['Zucchini', 1],
      ['Pepperoni', 2]
    ]);

    // Set chart options
    var options = {'title':'How Much Pizza I Ate Last Night',
                   'width':400,
                   'height':300};

    // Instantiate and draw our chart, passing in some options.
    var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
    chart.draw(data, options);
  }
</script>


Published

02 May 2014

Modified

liuminzhao 01/24/2015 22:21:25

Tags