forked from maquee-sas/SASStudioWorkshop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCar_Make.flw
executable file
·1 lines (1 loc) · 51.2 KB
/
Car_Make.flw
1
{"creationTimeStamp":null,"modifiedTimeStamp":null,"createdBy":null,"modifiedBy":null,"version":2,"id":null,"name":"Car_Make.flw","description":null,"properties":{"UI_PROP_DF_OPTIMIZE":"false","UI_PROP_DF_ID":"d495803c-b935-4d2d-8e02-69ee1c84f1ab","UI_PROP_DF_EXECUTION_ORDERED":"true"},"links":[],"nodes":{"id-1702600669829-1514":{"nodeType":"dataFlow","version":1,"id":"id-1702600669829-1514","name":"Create CAS Session","priority":1,"properties":{"UI_PROP_IS_EXPANDED":"true","UI_PROP_IS_SWIMLANE":"true"},"portMappings":[],"dataFlowAndBindings":{"dataFlow":{"creationTimeStamp":null,"modifiedTimeStamp":null,"createdBy":null,"modifiedBy":null,"version":2,"id":null,"name":null,"description":null,"properties":{},"links":[],"nodes":{"id-1702600636860-1137":{"nodeType":"step","version":1,"id":"id-1702600636860-1137","name":"Generate SAS librefs for caslibs","note":{"version":1,"id":"id-1702600636863-1141","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":0,"properties":{"UI_PROP_XPOS":"48","UI_PROP_YPOS":"46","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"3e7ccaf6-8b40-4fee-8c6c-b2f9adc8543f|Input tables 1|Input tables","UI_PROP_OUTPUT_PORT|outTables|0":"9e900cc8-236c-4486-8b85-9693b88ee553|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574464478"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepReference":{"type":"uri","path":"/dataFlows/steps/a7190700-f59c-4a94-afe2-214ce639fcde"},"arguments":{"codeOptions":{"code":"/*****************************************************************************/\n/* Create a default CAS session and create SAS librefs for existing caslibs */\n/* so that they are visible in the SAS Studio Libraries tree. */\n/*****************************************************************************/\n\ncas; \ncaslib _all_ assign;\n\n\n\n","variables":[{"name":"_output1","value":{"referenceType":"outputPort","portName":"outTables","portIndex":0,"arguments":{}}},{"name":"_input1","value":{"referenceType":"inputPort","portName":"inTables","portIndex":0}}],"contentType":"embedded"}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","contextId":"71c12010-b860-40a3-8320-acb5f5af7dd0","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1702600669802-1504":{"nodeType":"dataFlow","version":1,"id":"id-1702600669802-1504","name":"Cars Info","priority":2,"properties":{"UI_PROP_IS_EXPANDED":"true","UI_PROP_IS_SWIMLANE":"true"},"portMappings":[],"dataFlowAndBindings":{"dataFlow":{"creationTimeStamp":null,"modifiedTimeStamp":null,"createdBy":null,"modifiedBy":null,"version":2,"id":null,"name":null,"description":null,"properties":{},"links":[],"nodes":{"id-1702593963031-624":{"nodeType":"table","version":1,"id":"id-1702593963031-624","name":"CARS","description":"CARS Table from SASHELP library","note":{"version":1,"id":"id-1702593963034-628","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":1,"properties":{"UI_PROP_TABLE_URI":"SASData://SASHELP?CARS","UI_PROP_XPOS":"51","UI_PROP_YPOS":"170","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_USE_PERSISTED_TABLE_STRUCTURE":"false","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|outTable|0":"5d85c587-b2e2-46f7-80e9-dc5de06c4fcb","UI_PROP_PORT_LABEL|outTable|0":null,"UI_PROP_PORT_DESCRIPTION|outTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1702593963031-624"}},"id-1702594477133-2212":{"nodeType":"step","version":1,"id":"id-1702594477133-2212","name":"Query","note":{"version":1,"id":"id-1702594477135-2216","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":2,"properties":{"UI_PROP_XPOS":"303","UI_PROP_YPOS":"180","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"c072ab75-0a02-4aa1-acf3-63fe9c17a711","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574467092","UI_PROP_PORT_ID|inTables|0":"fbc811b3-dece-41c6-a473-d8236d28919f","UI_PROP_PORT_LABEL|inTables|0":"Input tables 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Query input tables","UI_PROP_PORT_ID|outTable|0":"3c7a402d-c4da-43c9-9364-28a147535fc1","UI_PROP_PORT_LABEL|outTable|0":"Output table","UI_PROP_PORT_DESCRIPTION|outTable|0":"Query output table","UI_PROP_PORT_ID|inTables|1":"7d45daac-440d-4c86-b93c-42615c308185","UI_PROP_PORT_LABEL|inTables|1":"Input tables 2","UI_PROP_PORT_DESCRIPTION|inTables|1":"Query input tables"},"stepReference":{"type":"uri","path":"/dataFlows/steps/c072ab75-0a02-4aa1-acf3-63fe9c17a711"},"arguments":{"fedSQL":false,"outputMode":"TABLE","useOutObs":false,"useInObs":false,"inObs":"","outObs":"","explicitSqlSource":false,"dataSetOptions":"","outputTable":{"referenceType":"outputPort","portName":"outTable","portIndex":0,"arguments":{}},"joinFormattedFilter":"","queryTables":[{"table":{"referenceType":"inputPort","portName":"inTables","portIndex":0},"alias":"t1"},{"table":{"referenceType":"inputPort","portName":"inTables","portIndex":1},"alias":"t2"}],"queryJoins":{"leftTable":{"table":{"referenceType":"inputPort","portName":"inTables","portIndex":0},"alias":"t1"},"joins":[{"joinType":"INNER JOIN","rightTable":{"table":{"referenceType":"inputPort","portName":"inTables","portIndex":1},"alias":"t2"},"conditions":[{"leftColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Make","inputPort":"inTables","inputPortIndex":0},"leftAlias":"t1","operator":"=","rightColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"MAKE","inputPort":"inTables","inputPortIndex":1}}]}]},"selectedColumns":[{"aggregate":null,"member":"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Make","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Model","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Type","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Origin","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"MSRP","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Invoice","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"CALCULATED","tableAlias":null,"isCalculated":true,"isModified":false,"inColumn":null,"calculatedColumn":{"referenceType":"columnDefinition","columnDefinition":{"name":"Diff","label":"MSRP - Invoice Diff","type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"format":{"name":"DOLLAR","length":8,"decimals":0}},"outputPort":"outTable","outputPortIndex":0},"modifiedColumn":null,"expressionText":"MSRP - Invoice"},{"aggregate":null,"member":"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"WEBSITE","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null}],"sessionId":"","selectDistinct":false,"whereFormattedFilter":"","whereQuickFilters":[],"havingFormattedFilter":"","havingQuickFilters":[],"orderByColumns":[{"tableAlias":"t2","member":"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":1},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t1","member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Make","inputPort":"inTables","inputPortIndex":0},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t1","member":"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Model","inputPort":"inTables","inputPortIndex":0},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"}],"groupByColumns":[]}},"id-1702594991674-6408":{"nodeType":"outputTable","version":1,"id":"id-1702594991674-6408","name":"CARS_INFO","note":{"version":1,"id":"id-1702594991675-6412","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":3,"properties":{"UI_PROP_TABLE_URI":"SASData://SASDM?CARS_INFO","UI_PROP_XPOS":"429","UI_PROP_YPOS":"180","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_USE_PERSISTED_TABLE_STRUCTURE":"false","UI_PROP_OUTPUT_PORT|outTable|0":"4bcdc4a2-aebc-49ee-90fe-a288c3f5e26c||","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|inTable|0":"bb978276-0c1d-4f66-9ac7-20369c13044c","UI_PROP_PORT_LABEL|inTable|0":null,"UI_PROP_PORT_DESCRIPTION|inTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1702594991674-6408"},"outputTableArguments":{"advancedOptions":[],"arguments":{}}},"id-1702594083585-912":{"nodeType":"file","version":1,"id":"id-1702594083585-912","name":"Car_Make_Info","note":{"version":1,"id":"id-1702594083588-916","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":4,"properties":{"UI_PROP_XPOS":"51","UI_PROP_YPOS":"280","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"GENERIC_FILE_TRANSFORMATION","UI_PROP_PORT_ID|outFile|0":"1c07225d-957c-4c88-b382-a6606981c666","UI_PROP_PORT_LABEL|outFile|0":null,"UI_PROP_PORT_DESCRIPTION|outFile|0":null},"fileReference":{"referenceType":"parameter","parameterId":"id-1702594083585-912"}},"id-1702594101697-1075":{"nodeType":"step","version":1,"id":"id-1702594101697-1075","name":"Import","note":{"version":1,"id":"id-1702594101699-1079","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":5,"properties":{"UI_PROP_XPOS":"177","UI_PROP_YPOS":"280","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"d38ccdec-66bc-43d0-84f0-faf8d5812bad","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574465874","UI_PROP_PORT_ID|outTables|0":"375e9137-41be-4b79-a1f6-5eb521d670a6","UI_PROP_PORT_LABEL|outTables|0":"Output tables 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables","UI_PROP_PORT_ID|inFile|0":"aef9686d-3679-4ee9-a954-a1fbeb496466","UI_PROP_PORT_LABEL|inFile|0":"Input file","UI_PROP_PORT_DESCRIPTION|inFile|0":"Input file to import"},"stepReference":{"type":"uri","path":"/dataFlows/steps/d38ccdec-66bc-43d0-84f0-faf8d5812bad"},"arguments":{"importOption":{},"renameColumns":true,"excelFileImportOptions":{},"delimitedFileImportOptions":{"outputTable":{"referenceType":"outputPort","portName":"outTables","portIndex":0,"arguments":{}},"guessingRows":20,"firstObs":2,"delimiterSensitive":false,"missingRecordOption":"missover","outColumns":[{"referenceType":"columnDefinition","columnDefinition":{"name":"MAKE","type":"Char","rawLength":10,"formattedLength":0,"version":2,"format":{"name":"$","length":10,"decimals":0},"informat":{"name":"$","length":10,"decimals":0}},"outputPort":"outTables","outputPortIndex":0},{"referenceType":"columnDefinition","columnDefinition":{"name":"WEBSITE","type":"Char","rawLength":52,"formattedLength":0,"version":2,"format":{"name":"$","length":52,"decimals":0},"informat":{"name":"$","length":52,"decimals":0}},"outputPort":"outTables","outputPortIndex":0},{"referenceType":"columnDefinition","columnDefinition":{"name":"PARENT_COMPANY","type":"Char","rawLength":34,"formattedLength":0,"version":2,"format":{"name":"$","length":34,"decimals":0},"informat":{"name":"$","length":34,"decimals":0}},"outputPort":"outTables","outputPortIndex":0}]},"fixedWidthFileImportOptions":{},"inFile":{"referenceType":"inputPort","portName":"inFile","portIndex":0},"fileType":"Delimited"}}},"parameters":{"id-1702593963031-624":{"parameterType":"tableStructure","version":2,"id":"id-1702593963031-624","name":"CARS","parameterUsage":"INPUT","defaultValue":{"table":{"name":"CARS","providerId":"Compute","dataSourceId":"Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASHELP","type":"dataTable","label":"2004 Car Data","creationTimeStamp":"2023-03-03T14:51:35.182Z","modifiedTimeStamp":"2023-03-03T14:51:35.182Z","attributes":{"bookmarkLength":12,"columnCount":15,"compressionRoutine":"NO","dataTableType":"table","encoding":"us-ascii ASCII (ANSI)","engine":"V9","logicalRecordCount":428,"physicalRecordCount":428,"recordLength":152,"rowCount":428,"version":2},"version":2,"links":[]},"source":{"id":"SASHELP","name":"SASHELP","providerId":"Compute","parentId":"71c12010-b860-40a3-8320-acb5f5af7dd0","hasTables":true,"hasEngines":false,"creationTimeStamp":"0001-01-01T00:00:00.000Z","modifiedTimeStamp":"0001-01-01T00:00:00.000Z","attributes":{"concatenationCount":4,"engineName":"V9","fileFormat":"7","flags":1057,"options":"","physicalName":"","readOnly":true,"version":2},"version":1,"links":[]},"columns":[]},"columns":[{"name":"Make","index":0,"type":"CHAR","rawLength":13,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Model","index":1,"type":"CHAR","rawLength":40,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Type","index":2,"type":"CHAR","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Origin","index":3,"type":"CHAR","rawLength":6,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"DriveTrain","index":4,"type":"CHAR","rawLength":5,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"MSRP","index":5,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"format":{"name":"DOLLAR","length":8,"decimals":0},"attributes":{"format":"DOLLAR8."}},{"name":"Invoice","index":6,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"format":{"name":"DOLLAR","length":8,"decimals":0},"attributes":{"format":"DOLLAR8."}},{"name":"EngineSize","label":"Engine Size (L)","index":7,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Cylinders","index":8,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Horsepower","index":9,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"MPG_City","label":"MPG (City)","index":10,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"MPG_Highway","label":"MPG (Highway)","index":11,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Weight","label":"Weight (LBS)","index":12,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Wheelbase","label":"Wheelbase (IN)","index":13,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Length","label":"Length (IN)","index":14,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}}]},"id-1702594991674-6408":{"parameterType":"table","version":1,"id":"id-1702594991674-6408","name":"CARS_INFO","parameterUsage":"OUTPUT","defaultValue":{"table":{"name":"CARS_INFO","providerId":"Compute","dataSourceId":"Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM","type":"dataTable","creationTimeStamp":"2023-12-15T00:55:16.809Z","modifiedTimeStamp":"2023-12-15T00:55:16.809Z","attributes":{"bookmarkLength":12,"columnCount":9,"compressionRoutine":"NO","dataTableType":"table","encoding":"utf-8 Unicode (UTF-8)","engine":"V9","logicalRecordCount":394,"physicalRecordCount":394,"recordLength":184,"rowCount":394,"version":2},"version":2,"links":[{"method":"GET","rel":"self","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table.summary"},{"method":"GET","rel":"provider","href":"/dataSources/providers/Compute","uri":"/dataSources/providers/Compute","type":"application/vnd.sas.data.provider"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/sessions/1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/sessions/1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO/columns?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables/CARS_INFO/columns?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM~fs~CARS_INFO/rows?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/rowSets/tables/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM~fs~CARS_INFO/rows?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASDM","name":"SASDM","providerId":"Compute","parentId":"71c12010-b860-40a3-8320-acb5f5af7dd0","hasTables":true,"hasEngines":false,"creationTimeStamp":"0001-01-01T00:00:00.000Z","modifiedTimeStamp":"0001-01-01T00:00:00.000Z","attributes":{"concatenationCount":0,"engineName":"V9","fileFormat":"7","flags":32,"options":"","physicalName":"/gelcontent/data","readOnly":false,"version":2},"version":1,"links":[{"method":"GET","rel":"self","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM","type":"application/vnd.sas.data.source.summary"},{"method":"GET","rel":"up","href":"/dataSources/providers/Compute/sources","uri":"/dataSources/providers/Compute/sources","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"parent","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables","uri":"/dataTables/dataSources/Compute~fs~71c12010-b860-40a3-8320-acb5f5af7dd0~fs~SASDM/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0/children?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0/children?sessionId=1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0/sessions/1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","uri":"/dataSources/providers/Compute/sources/71c12010-b860-40a3-8320-acb5f5af7dd0/sessions/1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","type":"application/vnd.sas.data.session"}]}}},"id-1702594083585-912":{"parameterType":"file","version":1,"id":"id-1702594083585-912","name":"inputFile","parameterUsage":"INPUT","defaultValue":{"arguments":{"dataType":"DLM","delimiter":",","encoding":"UTF-8","hasColumnHeaders":true},"fileType":"COMMA_DELIMITED","sourceType":"filesServicePath","value":"/Users/Alex/My Folder/Workshop/data/Car_Make_Info.csv"}}},"connections":[{"sourcePort":{"node":"id-1702593963031-624","portName":"outTable","index":0},"targetPort":{"node":"id-1702594477133-2212","portName":"inTables","index":0}},{"sourcePort":{"node":"id-1702594477133-2212","portName":"outTable","index":0},"targetPort":{"node":"id-1702594991674-6408","portName":"inTable","index":0}},{"sourcePort":{"node":"id-1702594101697-1075","portName":"outTables","index":0},"targetPort":{"node":"id-1702594477133-2212","portName":"inTables","index":1}},{"sourcePort":{"node":"id-1702594083585-912","portName":"outFile","index":0},"targetPort":{"node":"id-1702594101697-1075","portName":"inFile","index":0}}],"extendedProperties":{"UI_MODEL|id-1702594477133-2212":"{\"queryOption\":{\"autoSelectGroups\":true,\"selectDistinct\":false,\"selectStar\":false,\"initialized\":false,\"explicitSqlSource\":false,\"useExplicitPassthrough\":false,\"fedSQL\":false,\"sessionId\":\"\",\"notes\":\"\",\"fromLibraries\":false,\"dataSetOptions\":\"\",\"useInObs\":false,\"useOutObs\":false,\"inObs\":\"\",\"outObs\":\"\",\"migrating\":false,\"outputMode\":\"TABLE\",\"outputLibname\":\"WORK\",\"outputMember\":\"QUERY\",\"queryTables\":[{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"sortOrder\":\"NONE\",\"data\":{\"columns\":[{\"name\":\"Make\",\"format\":null,\"informat\":null,\"label\":null,\"length\":13,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=0\",\"type\":\"CHAR\"},{\"name\":\"Model\",\"format\":null,\"informat\":null,\"label\":null,\"length\":40,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=1\",\"type\":\"CHAR\"},{\"name\":\"Type\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=2\",\"type\":\"CHAR\"},{\"name\":\"Origin\",\"format\":null,\"informat\":null,\"label\":null,\"length\":6,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=3\",\"type\":\"CHAR\"},{\"name\":\"DriveTrain\",\"format\":null,\"informat\":null,\"label\":null,\"length\":5,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=4\",\"type\":\"CHAR\"},{\"name\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/currency\",\"dataOrder\":\"order=5\",\"type\":\"Numeric\"},{\"name\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/currency\",\"dataOrder\":\"order=6\",\"type\":\"Numeric\"},{\"name\":\"EngineSize\",\"format\":null,\"informat\":null,\"label\":\"Engine Size (L)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=7\",\"type\":\"Numeric\"},{\"name\":\"Cylinders\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=8\",\"type\":\"Numeric\"},{\"name\":\"Horsepower\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=9\",\"type\":\"Numeric\"},{\"name\":\"MPG_City\",\"format\":null,\"informat\":null,\"label\":\"MPG (City)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=10\",\"type\":\"Numeric\"},{\"name\":\"MPG_Highway\",\"format\":null,\"informat\":null,\"label\":\"MPG (Highway)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=11\",\"type\":\"Numeric\"},{\"name\":\"Weight\",\"format\":null,\"informat\":null,\"label\":\"Weight (LBS)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=12\",\"type\":\"Numeric\"},{\"name\":\"Wheelbase\",\"format\":null,\"informat\":null,\"label\":\"Wheelbase (IN)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=13\",\"type\":\"Numeric\"},{\"name\":\"Length\",\"format\":null,\"informat\":null,\"label\":\"Length (IN)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=14\",\"type\":\"Numeric\"}],\"dataType\":\"DATA\"},\"alias\":\"t1\",\"selectTableStar\":false,\"engine\":\"V9\",\"tableSourceLibrary\":\"SASHELP\",\"workTableName\":\"\"},{\"libname\":\"Import\",\"member\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"sortOrder\":\"NONE\",\"data\":{\"columns\":[{\"name\":\"MAKE\",\"format\":\"$10.\",\"informat\":\"$10.\",\"length\":10,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=0\",\"type\":\"Char\"},{\"name\":\"WEBSITE\",\"format\":\"$52.\",\"informat\":\"$52.\",\"length\":52,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=1\",\"type\":\"Char\"},{\"name\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"length\":34,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=2\",\"type\":\"Char\"}],\"dataType\":\"DATA\"},\"alias\":\"t2\",\"selectTableStar\":false,\"tableSourceLibrary\":\"\",\"workTableName\":\"_flw001170259410169710750000\"}],\"queryJoins\":[{\"id\":\"59387a0a-e800-178a-75ab-8708baf4672c\",\"leftTable\":{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"sortOrder\":\"NONE\",\"data\":{\"columns\":[{\"name\":\"Make\",\"format\":null,\"informat\":null,\"label\":null,\"length\":13,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=0\",\"type\":\"CHAR\"},{\"name\":\"Model\",\"format\":null,\"informat\":null,\"label\":null,\"length\":40,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=1\",\"type\":\"CHAR\"},{\"name\":\"Type\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=2\",\"type\":\"CHAR\"},{\"name\":\"Origin\",\"format\":null,\"informat\":null,\"label\":null,\"length\":6,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=3\",\"type\":\"CHAR\"},{\"name\":\"DriveTrain\",\"format\":null,\"informat\":null,\"label\":null,\"length\":5,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=4\",\"type\":\"CHAR\"},{\"name\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/currency\",\"dataOrder\":\"order=5\",\"type\":\"Numeric\"},{\"name\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/currency\",\"dataOrder\":\"order=6\",\"type\":\"Numeric\"},{\"name\":\"EngineSize\",\"format\":null,\"informat\":null,\"label\":\"Engine Size (L)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=7\",\"type\":\"Numeric\"},{\"name\":\"Cylinders\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=8\",\"type\":\"Numeric\"},{\"name\":\"Horsepower\",\"format\":null,\"informat\":null,\"label\":null,\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=9\",\"type\":\"Numeric\"},{\"name\":\"MPG_City\",\"format\":null,\"informat\":null,\"label\":\"MPG (City)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=10\",\"type\":\"Numeric\"},{\"name\":\"MPG_Highway\",\"format\":null,\"informat\":null,\"label\":\"MPG (Highway)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=11\",\"type\":\"Numeric\"},{\"name\":\"Weight\",\"format\":null,\"informat\":null,\"label\":\"Weight (LBS)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=12\",\"type\":\"Numeric\"},{\"name\":\"Wheelbase\",\"format\":null,\"informat\":null,\"label\":\"Wheelbase (IN)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=13\",\"type\":\"Numeric\"},{\"name\":\"Length\",\"format\":null,\"informat\":null,\"label\":\"Length (IN)\",\"length\":8,\"icon\":\"sap-icon://hc/numericType\",\"dataOrder\":\"order=14\",\"type\":\"Numeric\"}],\"dataType\":\"DATA\"},\"alias\":\"t1\",\"selectTableStar\":false,\"engine\":\"V9\",\"tableSourceLibrary\":\"SASHELP\",\"workTableName\":\"\"},\"joinType\":\"INNER JOIN\",\"rightTable\":{\"libname\":\"Import\",\"member\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"sortOrder\":\"NONE\",\"data\":{\"columns\":[{\"name\":\"MAKE\",\"format\":\"$10.\",\"informat\":\"$10.\",\"length\":10,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=0\",\"type\":\"Char\"},{\"name\":\"WEBSITE\",\"format\":\"$52.\",\"informat\":\"$52.\",\"length\":52,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=1\",\"type\":\"Char\"},{\"name\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"length\":34,\"icon\":\"sap-icon://hc/characterType\",\"dataOrder\":\"order=2\",\"type\":\"Char\"}],\"dataType\":\"DATA\"},\"alias\":\"t2\",\"selectTableStar\":false,\"tableSourceLibrary\":\"\",\"workTableName\":\"_flw001170259410169710750000\"},\"conditions\":[{\"id\":\"b3ee215f-eb48-d1b8-43a6-5502d21f7d39\",\"leftTableAlias\":\"t1\",\"leftColumn\":\"Make\",\"operator\":\"=\",\"rightTableAlias\":\"t2\",\"rightColumn\":\"MAKE\"}]}],\"selectedColumns\":[{\"libname\":\"Import\",\"member\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object701\",\"mProperties\":{\"name\":\"PARENT_COMPANY\",\"columnType\":\"Char\",\"length\":34,\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"Import\",\"tableName\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"alias\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"length\":34,\"type\":\"Char\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object684\",\"mProperties\":{\"name\":\"Make\",\"columnType\":\"CHAR\",\"length\":13,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"alias\":\"Make\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":13,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object685\",\"mProperties\":{\"name\":\"Model\",\"columnType\":\"CHAR\",\"length\":40,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"alias\":\"Model\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":40,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object686\",\"mProperties\":{\"name\":\"Type\",\"columnType\":\"CHAR\",\"length\":8,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Type\",\"alias\":\"Type\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object687\",\"mProperties\":{\"name\":\"Origin\",\"columnType\":\"CHAR\",\"length\":6,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Origin\",\"alias\":\"Origin\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":6,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object689\",\"mProperties\":{\"name\":\"MSRP\",\"columnType\":\"Numeric\",\"length\":8,\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"MSRP\",\"alias\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object690\",\"mProperties\":{\"name\":\"Invoice\",\"columnType\":\"Numeric\",\"length\":8,\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Invoice\",\"alias\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CALCULATED\",\"member\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object730\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"MSRP - Invoice\",\"expressionText\":\"MSRP - Invoice\",\"name\":\"Diff\",\"label\":\"MSRP - Invoice Diff\",\"length\":8,\"format\":\"\",\"informat\":\"\",\"columnType\":\"Numeric\"},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CALCULATED\",\"tableName\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\"},\"name\":\"Diff\",\"alias\":\"Diff\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"MSRP - Invoice Diff\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"Import\",\"member\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object700\",\"mProperties\":{\"name\":\"WEBSITE\",\"columnType\":\"Char\",\"length\":52,\"format\":\"$52.\",\"informat\":\"$52.\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"Import\",\"tableName\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\"},\"name\":\"WEBSITE\",\"alias\":\"WEBSITE\",\"format\":\"$52.\",\"informat\":\"$52.\",\"label\":\"\",\"length\":52,\"type\":\"Char\"}],\"whereFilter\":\"\",\"whereFormattedFilter\":\"\",\"useWhereAdvancedExpression\":false,\"whereQuickFilters\":[],\"groupByColumns\":[],\"havingFilter\":\"\",\"havingFormattedFilter\":\"\",\"useHavingAdvancedExpression\":false,\"havingQuickFilters\":[],\"joinFilter\":\"\",\"joinFormattedFilter\":\"\",\"useJoinAdvancedExpression\":false,\"orderByColumns\":[{\"libname\":\"Import\",\"member\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object701\",\"mProperties\":{\"name\":\"PARENT_COMPANY\",\"columnType\":\"Char\",\"length\":34,\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"Import\",\"tableName\":\"id-1702594477133-2212.inTables.2(7d45daac-440d-4c86-b93c-42615c308185)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object684\",\"mProperties\":{\"name\":\"Make\",\"columnType\":\"CHAR\",\"length\":13,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object685\",\"mProperties\":{\"name\":\"Model\",\"columnType\":\"CHAR\",\"length\":40,\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"extendedColumnAttr\":[],\"extendedAttrInfo\":null},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CARS\",\"tableName\":\"id-1702594477133-2212.inTables.1(fbc811b3-dece-41c6-a473-d8236d28919f)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"sortDirection\":\"ASC\"}],\"calculatedColumns\":[{\"mEventRegistry\":{},\"sId\":\"__object730\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"MSRP - Invoice\",\"expressionText\":\"MSRP - Invoice\",\"name\":\"Diff\",\"label\":\"MSRP - Invoice Diff\",\"length\":8,\"format\":\"\",\"informat\":\"\",\"columnType\":\"Numeric\"},\"mAggregations\":{},\"mAssociations\":{},\"oParent\":null,\"aDelegates\":[],\"aBeforeDelegates\":[],\"iSuppressInvalidate\":0,\"oPropagatedProperties\":{\"oModels\":{},\"oBindingContexts\":{},\"aPropagationListeners\":[]},\"mSkipPropagation\":{},\"oModels\":{},\"aPropagationListeners\":[],\"oBindingContexts\":{},\"mElementBindingContexts\":{},\"mBindingInfos\":{},\"mObjectBindingInfos\":{},\"_oContextualSettings\":{},\"library\":\"CALCULATED\",\"tableName\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\"}],\"flowmode\":true,\"codeGenerationOption\":\"\",\"applyFormatsFedSQL\":false}}"},"stickyNotes":[]},"executionBindings":{"sessionId":"1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","contextId":"71c12010-b860-40a3-8320-acb5f5af7dd0","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1702600774428-2443":{"nodeType":"dataFlow","version":1,"id":"id-1702600774428-2443","name":"CAS Table","priority":3,"properties":{"UI_PROP_IS_EXPANDED":"true","UI_PROP_IS_SWIMLANE":"true"},"portMappings":[],"dataFlowAndBindings":{"dataFlow":{"creationTimeStamp":null,"modifiedTimeStamp":null,"createdBy":null,"modifiedBy":null,"version":2,"id":null,"name":null,"description":null,"properties":{},"links":[],"nodes":{"id-1702600816542-3032":{"nodeType":"step","version":1,"id":"id-1702600816542-3032","name":"SAS Program","note":{"version":1,"id":"id-1702600816543-3036","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":6,"properties":{"UI_PROP_XPOS":"48","UI_PROP_YPOS":"404","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"30011532-8219-401e-93bd-b3224bddf672|Input tables 1|Input tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574464478","UI_PROP_PORT_ID|outTables|0":"67cec4c6-0038-40d0-acf8-7849d5c559be","UI_PROP_PORT_LABEL|outTables|0":"Output tables 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepReference":{"type":"uri","path":"/dataFlows/steps/a7190700-f59c-4a94-afe2-214ce639fcde"},"arguments":{"codeOptions":{"code":"proc casutil sessref=CASAUTO;\n droptable casdata=\"CARS_INFO\" incaslib=\"DM\" quiet; /* added this statement in case job is run again */\n load data=SASDM.CARS_INFO outcaslib=\"DM\"\n casout=\"CARS_INFO\" promote; /* loads SAS table to CAS and promotes table to global scope */\nrun;\n","logHTML":"","resultsHTML":"","variables":[{"name":"_output1","value":{"referenceType":"outputPort","portName":"outTables","portIndex":0,"arguments":{}}},{"name":"_input1","value":{"referenceType":"inputPort","portName":"inTables","portIndex":0}}],"contentType":"embedded"}}},"id-1702600877667-3781":{"nodeType":"step","version":1,"id":"id-1702600877667-3781","name":"Terminate CAS Session","note":{"version":1,"id":"id-1702600877667-3785","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":7,"properties":{"UI_PROP_XPOS":"174","UI_PROP_YPOS":"404","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_OUTPUT_PORT|outTables|0":"5cdf1e76-6cd7-4a10-bf52-ecf114a47ae0|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574464478","UI_PROP_PORT_ID|inTables|0":"0c6c5059-f22b-4946-80d9-ad7759f386bd","UI_PROP_PORT_LABEL|inTables|0":"Input tables 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Input tables"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepReference":{"type":"uri","path":"/dataFlows/steps/a7190700-f59c-4a94-afe2-214ce639fcde"},"arguments":{"codeOptions":{"code":"/*****************************************************************************/\n/* Terminate the specified CAS session (mySession). No reconnect is possible*/\n/*****************************************************************************/\n\ncas CASAUTO terminate;\n\n\n","logHTML":"","resultsHTML":"","variables":[{"name":"_input1","value":{"referenceType":"inputPort","portName":"inTables","portIndex":0}},{"name":"_output1","value":{"referenceType":"outputPort","portName":"outTables","portIndex":0,"arguments":{}}}],"contentType":"embedded"}}}},"parameters":{},"connections":[{"sourcePort":{"node":"id-1702600816542-3032","portName":"outTables","index":0},"targetPort":{"node":"id-1702600877667-3781","portName":"inTables","index":0}}],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"1a3d0f8e-cb75-4358-a032-60591148ed38-ses0000","contextId":"71c12010-b860-40a3-8320-acb5f5af7dd0","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]}