New Technology Reviews!.: Tables

Write a PROC SQL statement. Remember that all statements in SAS are followed by a semicolon. Your initial line should look like this: PROC SQL;Provide a title for the results table in the second line of your statement, such as 'Results Table.' Be sure the name of the table is in single quotation marks. You don't need a semicolon at the end of this line since it's part of an SQL statement.Select all the data from the first table in the third line. The third line might read, "Select * From Table1." The asterisk tells SAS to select all fields from the first table. You don't need quotation marks or a semicolon.Type "EXCEPT" in the fourth line. Again, you don't need quotation marks or a semicolon.Select all the data from the second table in the fifth line. The fifth line might read, "Select * From Table2." Again, you don't need quotation marks but you do need a semicolon since you're concluding your SQL statement.Type "QUIT;" in your sixth and last line. You'll need a semicolon but no quotation marks. Run the program. Your output should show a list of records that don't match.

How to Detect Differences in Very Large SAS Tables

Write a PROC SQL statement. Remember that all statements in SAS are followed by a semicolon. Your initial line should look like this: PROC ...

<img src="http://cdn.mos.techradar.com//classifications/world%20of%20tech/images/facebookshoes-200-200.jpg"> What's more wanted than the boss of Wikileaks and more fun than burning an effigy of Nick Clegg when you're supposed to be studying? That's right: this week's Weird Tech! This editions features internet shoes, touchy-feely tables, alarming adult products and strange behaviour in Germany. There are two kinds of people in the world: those who don't want Facebook on their feet and, well, crazy people. So it's good news for the latter camp: limited edition <a href="http://www.behance.net/gallery/Adidas-Facebook-Superstars/817509">Adidas Facebook Superstars</A>. We hoped that in honour of Facebook's privacy policy the shoes would change shape every few days, hiding features you'd become used to such as the bit you put your feet in or the bits where the laces go, but sadly Gerry McKay's clever concept isn't that satirical. Microsoft gets touchy The internet's very excited about a new Microsoft patent: a touch-screen that you can actually feel. Instead of today's featureless glass slabs, Microsoft proposes using a layer of plastic that can change shape when ultraviolet light hits it. <img alt="Patent" src="http://mos.futurenet.com/techradar/classifications/world%20of%20tech/images/mspatent-420-90.jpg" width="420"></IMG> ERRRR: We're told that the finished version will look a bit more impressive than this Virtual keyboards could feel like real keys, products could be prodded and – you know this gag's coming – you really could poke people on Facebook. <a href="http://www.newscientist.com/article/dn19776-microsoft-develops-shapeshifting-touchscreen.htm">New Scientist has the details</A>. Toys for the boys The days when vibrators had to be advertised as <a href="http://en.wikipedia.org/wiki/File:Vibration-is-life.jpg">devices promoting "vigour, strength and beauty"</A> are long gone, and adult toys are big business – for the girls, anyway. <img alt="Cobralibre" src="http://mos.futurenet.com/techradar/classifications/world%20of%20tech/images/cobralibre-420-90.jpg" width="420"></IMG> INTERESTING: No, it's not a toy car. It's a toy of a very different kind. Hot Wheels eat your heart out Next step? Toys for men. <a href="http://uk.news.yahoo.com/">AFP</A> describes a range of new intimate products designed for the hairier sex, with highlights including the <a href="http://cobralibre.org/">Cobra Libre</A>. If you've ever wanted to have sex with something that looks like a toy car, now you can. Big Trak's on your back While we're on the subject of personal massagers, what could be more relaxing than having something resembling '80s robot tank Big Trak rolling around your body? Nothing, hope <a href="http://www.dreambots.com/">DreamBots</A>, whose WheeMe's "four small wheels and the rotor finger gently press and caress providing a delightful sense of bodily pleasure". By happy coincidence, it looks as if someone took the aforementioned Cobra Libre and glued wheels to it. In any case, the models in the product videos couldn't look much less comfortable if the WheeMes were being nailed to them. The WheeMe is yours for just 49 dollars, and it ships in spring. </PARAM><PARAM value="true" name="allowFullScreen"></PARAM><PARAM value="always" name="allowscriptaccess"></PARAM><EMBED src=http://www.youtube.com/v/tHMjhJQN1Q4&hl=en&fs=1 width=420 height=315 type=application/x-shockwave-flash allowfullscreen="true" allowscriptaccess="always"> </EMBED></OBJECT> Germany's Google gangs To Germany, where some people take Google Street View far too seriously. Pro-Google vigilantes are throwing eggs at the homes of people whose houses have been blurred on Street View. "Google's cool," read the notes left on the unfortunate householders' mailboxes. <img alt="Happy eggs" src="http://mos.futurenet.com/techradar/classifications/world%20of%20tech/images/happyeggs-420-90.jpg" width="420"></IMG> HAPPY EGGS: "Street View? What's Street View? The eggs would find out soon enough" [Image credit: Themonnie on Flickr] As Danny Sullivan of Search Engine Watch explains, while there are two separate <a href="http://searchengineland.com/google-fans-throw-eggs-at-houses-blurred-in-google-street-view-56763">news reports</A> of such tomfoolery "neither gives the exact number of homes involved nor are pictures of the eggings posted." Are these a few isolated incidents, or is the entire country at it? If you're German or in Germany, do let us know.

Weird Tech: Rampant robots and touchy tables

What's more wanted than the boss of Wikileaks and more fun than burning an effigy of Nick Clegg when you're supposed to be studying?...

How to Detect Differences in Very Large SAS Tables

Weird Tech: Rampant robots and touchy tables

How to Access Vertical Alignment in HTML Tables