Hello SAS 1--Install and run a small sample

1. Installation

• Software Environment Description

Win7 64-bit + SAS9.4

• Preparatory work

Review the SAS SID file validity period and modify the system time to 1 months before the validity period, as shown:

• modifying SIDs

• Problem 1:sas em Create Project report no_file error (the scenario when an error occurs is that the operating system is Chinese and the system time is not modified)

How to resolve:

1. The operating system language is changed to English version. (tried a few times the Chinese version of the failed, not sure this is the main cause, because the installation is also modified when the system time, the previous failure did not modify the system time)

2. Modify the system time

2. Create Libraries and table

• Create libraries (the Lib created after the software restart is lost in the window and needs to be created and associated with the original storage directory)

• CREATE table

3, Access data import (the imported SAS file will be large, 800M accdb into the 50G SAS table)

• Issue 1:sas importing Access Connect:class not registered (because SAS installs 64-bit, office is caused by 32-bit)

How to resolve:

1. Download the Accessdatabaseengine_x64.exe file

2. The registry removes 32-bit access installation information. Execute Cmd-->regedit, and then search for "Access Connectivity Engine" and delete.

3. Under Console cmd execute the following command (the computer will restart automatically after successful installation):
"C:\directory Path\accessdatabaseengine_x64.exe"/passive
If the above command is still not working, unzip the exe file and then execute the following command:
"D:\BigData\SAS\ installation file \accessdatabaseengine_x64\aceredist.msi"/passive

4. After the installation is complete, review the registry hkey_local_machine\software\microsoft\office\14.0\common\filespaths and delete the Mso.dll. Otherwise, the Office config problem will occur every time.

Attached: Check whether the office2010 is a 32-bit or 64-bit version

4. ODBC Data import

5, simple SQL script, and click Submit Execution (do not open the related table when executing, do not be used by EM, otherwise may error or invalid execution)

Proc SQL;
CREATE TABLE Hjhj.aa as SELECT * from HJHJ.BB where loan < 4000;
Delete from Hjhj.aa where loan > 2000;
Quit

6, EM use custom lib

7. Run a small example

• Create a data Source
• Create diagram
• Define the process (drag data source--> drag data Partition (under Sample tab)-Drag decision Tree (Under Model tab)-wired)
• Define the target of the data source and the datatype
• Define the dimensions decision tree participates in analysis
• Select decision tree and right-click Run to view the results

8. Custom Configuration

• The decision tree after run may be clipped, and you can try to view the results by interactive (you can modify the dimension fields below the root to show different tree structures)

• By default only run 10,000 data, click Decision Tree After you can modify the left property by default to user, and the sample size property.

• To modify the ratio of training and validation data, click on data partition and modify the property values.

9. There are five types of EM data

unary-- only unique value type 　　binary-- only two-value 　　nominal-- More than two unordered non-numeric value types 　　ordinal-- More than two cases of a numerical type less than ten 　　interval-- is greater than the numerical type 　　　　　　

Hello SAS 1--Install and run a small sample