What Kinds of Data Sets Can I Upload to Sas Viya

To start the Import Sorcerer, click File > Import Information. Let's import our sample data, which is located in an Excel spreadsheet, every bit an illustration of how the Import Sorcerer works.

A new window will popular up, called "Import Wizard – Select import type".

This starting time screen will ask y'all to cull the type of data y'all wish to import. Click Standard information source and and so choose the program that is the source of your data from the drop downwardly menu. (The 2nd choice, specifying a file format, is non covered in this tutorial.)

In our example, the dataset nosotros want to import is an Excel file, and then select Microsoft Excel Workbook. As you can see, SAS provides y'all with a large variety of information types to import. In one case you've chosen the information source, click Next.

Now you need to tell SAS where to observe the file you lot desire to import. You can either type the file directory into the text box, or click Browse and choose the file to import.

In one case yous've added the file path to the text box, click OK. SAS then asks y'all what sheet from the file you want to import. In this example we will choose Sheet 1 since our information appears on Sail ane in the Excel file. And so click Options. Exist sure and select the options that are right for your dataset. The default is for all options to be checked, and that works for our purposes. Click Next.

This adjacent stride tells SAS where you desire to store the newly imported dataset. The first driblet-down menu is a list of available libraries that you can choose to store your newly imported SAS dataset in. If you want information technology to be temporarily stored for now, cull WORK. If you've already created a library with a LIBNAME statement, you tin can choose one of those instead.

The side by side dropdown bill of fare, under Fellow member, requires you to name the dataset. You can type in a dataset name here, or choose a dataset from the list. NOTE: Choosing an existing dataset from the listing volition over-write that data; the existing file in the library will be replaced with the file yous are importing. Then, click Next.

The concluding step allows you to save the statements that SAS generates while executing the Import Magician into an Editor file. This is recommended. This way you have the import steps saved, and you tin can go back and re-run it or modify it later if you lot need to. Y'all can type the file directory directly into the text box, or click on Browse to locate a binder to save the programme in. Don't forget to name information technology. The last step is to click Finish.

How do I know if information technology worked?

Clicking on the cease button was probably anticlimactic, because nothing seems to happen. No data appears for you to run across and enjoy; no Editor file appears for you to manipulate and play with. Just allow's look a little closer. Remember the earlier tip to look at your Log window afterward you execute any statements in SAS. Running the Import Wizard executes statements in SAS – it's just behind the scenes a chip because the Wizard writes the statements for you – and so then the Log window is the offset place you should look. If you look in the Log window y'all'll come across at that place was some action:

The Log window provides this Annotation statement that tells you lot your dataset was successfully created. If there had been a problem with the import, a Warning or Error would have appeared instead.

You will besides probably want to look at your data to make certain everything looks right. You can view whatever of your SAS datasets by finding them in the Explorer window. In the Explorer window, double-click on Libraries to display the Libraries that are available in this session. In this case, the imported dataset is in the temporary Work library, so double-click on Work. Locate the dataset icon and double-click on it. This volition open your data to view in SAS.

Finally, we might want to take a expect at the statements generated from the Import Sorcerer. The Import Wizard saved an Editor file, merely information technology did not open it or append it to an already open Editor file. Make sure the Editor window is active, and and then click File > Open up Plan or click in the toolbar. Locate the directory that yous told the Import Sorcerer to save your Editor file to, highlight the file and click Open up. It should look like something similar to beneath.

          PROC IMPORT OUT=WORK.sample 		DATAFILE="C:/mydata/Sample Data.xlsx" 		DBMS=EXCEL Supersede; 	RANGE="Sheet1$"; 	GETNAMES=YES; 	MIXED=Yep; 	SCANTEXT=Yep; 	USEDATE=YES; 	SCANTIME=YES;        

It starts with a PROC IMPORT statement, which triggers the information import activeness. Annotation the first semicolon is not until the third line. This is considering the syntax includes quite a few options associated with the PROC IMPORT statement:

• The OUT option tells SAS where to put the new SAS dataset it is creating – in this case we told information technology to put the new SAS dataset "sample" in the Work library.
• The DATAFILE option points to the file directory of the dataset yous are importing.
• The DBMS option tells SAS the blazon of information it is importing. Specifically, it tells SAS what engine to use to read the data (in this case, the EXCEL engine).
  • The optional Supervene upon statement says that if there is an existing dataset in SAS's memory with this name, it should exist overwritten.

The rest of the lines are statements with farther data for SAS – you might recognize these from the list produced after clicking on the Options button in the Import Wizard.

• RANGE="Sheet1$" statement tells SAS what sheet to read; in this case, a canvass named "Sheet1". The dollar sign after the sail name tells SAS to read the entire canvas. This argument is optional; if omitted, SAS volition simply read the entirety of the first sheet in the workbook.
• GETNAMES=Aye instructs SAS to employ the kickoff row of the file every bit variable names.
• MIXED controls how SAS "guesses" the advisable informat for a variable. By default, SAS looks at the first 8 rows of a column, and makes an "educated guess" about what informat is appropriate for the data it encounters. This works well if the values are homogenous, just tin can fail if the values have been recorded inconsistently. MIXED=YES tells SAS that if multiple formats are detected in a column, that cavalcade should instead exist read in equally a string variable. (This ensures that the original information is not lost during the import process.) (Source: Usage Note 13526: Description of MIXED=Yeah in SAS 9.10 SAS/ACCESS Interface to PC Files)
• SCANTEXT applies to columns containing text. If SCANTEXT=YES, and then SAS will browse the column for the longest string, and uses its length every bit the column width.
• USEDATE=Aye tells SAS to honor whatsoever engagement format settings in the Excel file. That is, if yous've added a appointment format to a column or variable in Excel, SAS will read in that variable using a date format. (If using USEDATE=NO, SAS will read it in as a cord variable.)
• SCANTIME=YES tells SAS to browse the variables for time-specific formats.

It'south important to note that these options are all specific to the DBMS=EXCEL engine that is being used. PROC IMPORT tin can read in other file types, and the options may exist unlike for those file types.

If you are using a 32-bit version of SAS, use DBMS=EXCEL in the PROC IMPORT statement. If you lot are using a 64-chip version of SAS, use DBMS=xls or DBMS=xlsx (whichever is appropriate for the file yous're importing). You tin can determine if you have the 32-bit or 64-bit version of SAS by examining the contents of the Log window when you first open SAS. Notwithstanding, be sure to run PROC CONTENTS to verify that your variables were properly imported - particularly long string variables, engagement variables, and time variables. If whatsoever of your variables were misread, you may need to use an culling method to read the data.

weaveracloned.blogspot.com

Source: https://libguides.library.kent.edu/SAS/ImportData

Share this post