rhinohas.blogg.se - Import data sas university edition

#Import data sas university edition how to#
#Import data sas university edition install#
#Import data sas university edition code#

We notice that 74.2 % of women on board survived, but only 18.89% of men.

Most interestingly perhaps we can see the percentages of men and women who survived.

The number of people who survived (342) and the number that did not (549).

We can also see the number of females (314) and the number of males (577).

The bottom right number tells us the total number of passengers in the dataset (891).

This table tells us lots of useful information. The output window should automatically be shown and should display something similar to the below. Note that we use the NOROW and NOPERCENT options to suppress the printing of some unwanted information.

#Import data sas university edition code#

This code produces a two way frequency table. To do this we use the PROC FREQ procedure as follows:Įnter the following into the code window, highlight it and execute the block of code either with the F3 key or by pressing the running man icon. Next we look to see what effect the gender of the passenger has on their chances of survival.

To check that the import has worked as expected, open the train dataset within the work library as shown below. NOTE: PROCEDURE IMPORT used (Total process time): NOTE: The data set WORK.TRAIN has 891 observations and 12 variables. NOTE: WORK.TRAIN data set was successfully created. 891 rows created in WORK.TRAIN from /folders/myfolders/train.csv. The log file will show something similar to the below, confirming that the import was successful, it will also have information on the variables which have been created. The program will import the CSV file into SAS and convert it to a SAS dataset.

The GETNAMES option tells the procedure that the first row of the CSV file contains the values that will be used to label the variables in the TRAIN dataset.Įxecute the code by pressing F3, or by clicking on the little running man.

The REPLACE option tells the procedure that if the TRAIN file already exists in the work library then it should be overwritten.

The OUT = option gives the name of the output file, as we are not specifying a LIBREF this dataset is created in the work library.

The DBMS option tells the procedure the type of file it will be reading.

Here the DATAFILE option tells the procedure the name and location of the input file (note how this is relative to the shared folder you setup when you installed SAS University Edition).

Enter the following code into the code window as shown below. To import the CSV file, we will use the PROC IMPORT procedure. Now launch the virtual machine and log onto the SAS University Edition.ĭownload the train.csv and test.csv file from the Kaggle website and store them within the shared folder you setup when installed SAS unviersity edition, usually this will be : C:\SASUniversityEdition\myfolders\ .

If you haven’t done this yet that you can follow the tutorial here.

#Import data sas university edition install#

Outputting a dataset to a CSV file in preparation for submitting it to Kaggleīefore you get started you will need to install a virtual machine and then the SAS university edition files.Using the KEEP statement to only keep variables that you want in your dataset.Using IF…THEN.ELSE logic to modify a dataset.Calculating the proportion of men and women who survived using PROC FREQ.Reading a CSV file into SAS using PROC IMPORT.

#Import data sas university edition how to#

It explains how to use the SAS University Edition to do the following: It should be useful both for people who want to learn SAS, but also for those who want to use SAS to enter the Kaggle competition. The tutorial is designed to be roughly equivalent to the first excel lesson available on the Kaggle website. This is the first of our tutorials on using SAS university edition to explore the data from the Kaggle Titanic: Machine Learning from Disaster edition.