Icon

sas7bdatToDatabaseExample

List sas7bdatfiles in folderLoop over filesEstablish DBconnectionCreate tablestructureExtract file name touse as table nameWrite totableCollect loopiterationsvarious manipulationsgo hereSAS7BDAT Reader List Files Table Row ToVariable Loop Start H2 Connector DB Table Creator URL to FilePath (Variable) DB Writer Variable Loop End Data Cleanup List sas7bdatfiles in folderLoop over filesEstablish DBconnectionCreate tablestructureExtract file name touse as table nameWrite totableCollect loopiterationsvarious manipulationsgo hereSAS7BDAT Reader List Files Table Row ToVariable Loop Start H2 Connector DB Table Creator URL to FilePath (Variable) DB Writer Variable Loop End Data Cleanup

Nodes

Extensions

Links