As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Splitter transformation"

From sasCommunity
Jump to: navigation, search
m (Add categories and links to versions 4.3 - 4.9)
(gardening)
 
Line 1: Line 1:
[[Category:SAS Data Integration Studio]]
+
{{work in progress}}
 +
The '''Splitter transformation''' in [[SAS Data Integration Studio]] uses a [[DATA Step]] containing subsetting [[IF statements]] to create one or more tables that are subset of a source table. Columns can be dropped but rows cannot be aggregated.
  
: ''Note: This is a work in progress. If you know something about this topic please feel free to contribute to this article.'' [[Category:Work in Progress]]
+
In some situations a Splitter transformation will have better performance than an [[SQL]] [[Extract transformation]]. This is because the Splitter uses a DATA Step to perform a table scan while the Extract transformation uses indexes and may need to create internal indexes to [[query]] the table.
  
The '''Splitter transformation''' in [[SAS Data Integration Studio]] uses a [[DATA Step]] containing subsetting IF statements to create one or more tables that are subset of a source table. Columns can be dropped but rows cannot be aggregated.
+
== References ==
 +
* Create Two Tables That Are Subsets of a Source - (Version [http://support.sas.com/documentation/cdl/en/etlug/63360/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.3], [http://support.sas.com/documentation/cdl/en/etlug/65016/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.4], [http://support.sas.com/documentation/cdl/en/etlug/65158/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.5], [http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.6], [http://support.sas.com/documentation/cdl/en/etlug/65920/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.7], [http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.8], [http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.9])
  
In some situations a Splitter transformation will have better performance than an SQL [[Extract transformation]]. This is because the Splitter uses a DATA Step to perform a table scan while the Extract transformation uses indexes and may need to create internal indexes to query the table.
+
[[Category:SAS Data Integration Studio]]
 
+
== References ==
+
*Create Two Tables That Are Subsets of a Source - (Version [http://support.sas.com/documentation/cdl/en/etlug/63360/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.3], [http://support.sas.com/documentation/cdl/en/etlug/65016/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.4], [http://support.sas.com/documentation/cdl/en/etlug/65158/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.5], [http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.6], [http://support.sas.com/documentation/cdl/en/etlug/65920/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.7], [http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.8], [http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#p13z8u5ou5fm8rn17fqv7o5a7046.htm 4.9])
+

Latest revision as of 16:26, 28 June 2017

This is a work in progress. You can contribute to this article.

The Splitter transformation in SAS Data Integration Studio uses a DATA Step containing subsetting IF statements to create one or more tables that are subset of a source table. Columns can be dropped but rows cannot be aggregated.

In some situations a Splitter transformation will have better performance than an SQL Extract transformation. This is because the Splitter uses a DATA Step to perform a table scan while the Extract transformation uses indexes and may need to create internal indexes to query the table.

References