How do you read a SPSS file using R?

SPSS files are created using the SPSS software from IBM. You could read these files using R provided you can install the 'haven' library from one of the CRAN sites.

Rlib_Haven.png


Install 'haven'
--------------
> install.packages("haven")
Warning in install.packages("haven") :
  'lib = "C:/Program Files/Microsoft/R Client/R_SERVER/library"' is not writable
also installing the dependencies ‘assertthat’, ‘lazyeval’, ‘Rcpp’, ‘readr’, ‘hms’, ‘tibble’, ‘BH’
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/assertthat_0.1.zip'
Content type 'application/zip' length 44884 bytes (43 KB)
downloaded 43 KB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/lazyeval_0.2.0.zip'
Content type 'application/zip' length 137793 bytes (134 KB)
downloaded 134 KB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/Rcpp_0.12.7.zip'
Content type 'application/zip' length 3265183 bytes (3.1 MB)
downloaded 3.1 MB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/readr_1.0.0.zip'
Content type 'application/zip' length 1167814 bytes (1.1 MB)
downloaded 1.1 MB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/hms_0.2.zip'
Content type 'application/zip' length 20730 bytes (20 KB)
downloaded 20 KB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/tibble_1.2.zip'
Content type 'application/zip' length 614069 bytes (599 KB)
downloaded 599 KB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/BH_1.60.0-2.zip'
Content type 'application/zip' length 15529292 bytes (14.8 MB)
downloaded 14.8 MB
trying URL 'https://mran.revolutionanalytics.com/snapshot/2016-11-01/bin/windows/contrib/3.3/haven_1.0.0.zip'
Content type 'application/zip' length 800532 bytes (781 KB)
downloaded 781 KB
package ‘assertthat’ successfully unpacked and MD5 sums checked
package ‘lazyeval’ successfully unpacked and MD5 sums checked
package ‘Rcpp’ successfully unpacked and MD5 sums checked
package ‘readr’ successfully unpacked and MD5 sums checked
package ‘hms’ successfully unpacked and MD5 sums checked
package ‘tibble’ successfully unpacked and MD5 sums checked
package ‘BH’ successfully unpacked and MD5 sums checked
package ‘haven’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
        C:\Users\TEMP.HODENTEK9.000.001.002\AppData\Local\Temp\Rtmp84xjOn\downloaded_p
-----
Load the library
> library(haven)
-------------
I will try to read a file called 'employees.sav' which I downloaded to my laptop from internet here :

(https://www.spss-tutorials.com/spss-opening-data-with-syntax/).

Now I run this statment in R (Microsoft Client R.GUI)

Rlib_Haven_1

That's all folks!

What is SPSS?

Data Science is trending. What with Machine Learning and Artificial Intelligence, learning to work with statistical analysis tools will take you far.

Here is an IBM one liner for SPSS:

"Propel research & analysis with a fast and powerful solution"

SPSS is an acronym for Statistical Software for Social Sciences. Its beginnings dates back to 1968 and it was acquired by IBM in 2009. Files created by this software have the extension .sav. SPSS outputs tables and charts that can processed by MS Word, Google Docs, Open Office, etc.

SPSS can be used for editing and analyzing data similar to other software such as R, Excel, Python, etc.

Here is a PR demo from IBM




More SPSS stuff here:

https://hodentekhelp.blogspot.com/2018/09/is-spss-software-free.html

https://hodentekhelp.blogspot.com/2018/09/how-do-you-read-spss-file-using-r.html

What is Linius Video Virtualization?

Video content need not be a black-box containing the various stuff that go into video like, images, audio, etc. Video Virtualization takes your video file and converts it into another file where the individual pieces in the original video can be edited.

Microsoft, Amazon and IBM are investing in Video Virtualization. Microsoft with the help of Magenic is making Video Virtualization available on Microsoft Azure.

Here is a video that explains Video Virtualization of Linius.


Linius has perfected Video Virtualization protected by patents that all the three previously mentioned cloud companies are using (going to use?).

This is serious stuff as most user experience these days are driven by videos, be it entertainment, news or anything else. Being a single technical source, Linius will profit hugely.

I was driven by curiosity and wanted to see how far I can go in creating a Virtual Video file using Linius Video Virtualization Engine (VVE). I did get to the part of bringing in my video file here:

---------------------------------
Video created to describe a visit to Amalfi in Italy. https://youtu.be/xF1o0uJlk_I

I was able to get this file into VVE at this site: http://VVEplay.com/

When I tried to edit, the software broke my file (which was actually a slide-show) into attached individual frames for each slide. There were no controls in Step 2 where you can edit. Anyway, I published it after the second step and it produced another file at the VVE site.

Now I am not sure how to go from here to edit this '186490283' file. The above produced an error on a web page.

Some of my unanswered questions are:
Do I need to get to the file on VVE site to edit it?
How do I edit it? Graphic User Interface? If Programmatic, how?
How do I use its features, Search, modifying content, introduce ads, etc.?

What is ODBMS? and Who is the leader in this segment?

This is the definition of Operational Database Management System(ODBMS) according to Gartner (5/10/2016):

"The operational database management system (OPDBMS) market is concerned with relational and nonrelational DBMS (see Note 1) products suitable for a broad range of enterprise-level transactional applications, and DBMS products supporting interactions and observations as alternative types of transactions"

Based on this definition and other considerations Microsoft is the leader edgin higher than the secodn Oracle. This is what you see in the Magic Quadrant. Microsoft shares the vision with others such as Oracle, SAP, AWS and IBM.

Here is copy of the Quadrant:

Detailed report here to download after registering:
https://info.microsoft.com/gartner-odbms-magic-quadrant-register.html?ls=website