Problem Note 46270: The Transform Variables node Formulas property does not use random selection
The Transform Variables node in SAS® Enterprise Miner™ has a Formulas property that enables you to build a transformation. The formula builder that the property launches uses a sample of the data. The formula builder should create the type of sample (First N, or Random) based on the value of the Method Sample Property. However, the formula builder uses First N sampling even if you specify Random.
There are no errors or warnings to indicate that Random sampling was not used.
To work around the problem and obtain a random sample, sort the data in random order before using the Transform Variables node. One way to sort the data in random order is to add a SAS Code node before your Transform Variables node. In the SAS Code node Code Editor, use the code below. The code sorts the data in random order.
/* create a random variable for sorting */
data &EM_EXPORT_TRAIN;
set &EM_IMPORT_DATA;
my_sort_variable=ranuni(12345);
run;
/* sort the data randomly */
proc sort data=&EM_EXPORT_TRAIN
out=&EM_EXPORT_TRAIN(drop=my_sort_variable);
by my_sort_variable;
run;
Run the SAS Code node. Attach a Transform Variables node to the SAS Code node. The formula builder still uses First N sampling. However, since the data is in random order, the sample is random.
Operating System and Release Information
SAS System | SAS Enterprise Miner | Microsoft Windows 95/98 | 5.1 | | | |
Microsoft Windows 2000 Advanced Server | 5.1 | | | |
Microsoft Windows 2000 Datacenter Server | 5.1 | | | |
Microsoft Windows 2000 Server | 5.1 | | | |
Microsoft Windows 2000 Professional | 5.1 | | | |
Microsoft Windows NT Workstation | 5.1 | | | |
Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows Server 2008 | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows Server 2008 for x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Microsoft Windows XP Professional | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Enterprise 32 bit | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Enterprise x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Home Premium 32 bit | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Home Premium x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Professional 32 bit | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Professional x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Ultimate 32 bit | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows 7 Ultimate x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows Millennium Edition (Me) | 5.1 | | | |
Windows Vista | 5.1 | 12.1 | | 9.3 TS1M2 |
Windows Vista for x64 | 5.1 | 12.1 | | 9.3 TS1M2 |
64-bit Enabled AIX | 5.1 | 12.1 | | 9.3 TS1M2 |
64-bit Enabled Solaris | 5.1 | 12.1 | | 9.3 TS1M2 |
HP-UX IPF | 5.1 | 12.1 | | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2012-04-10 16:26:22 |
Date Created: | 2012-04-10 16:02:42 |