forked from maquee-sas/SASStudioWorkshop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Car_Make .flw
executable file
·1 lines (1 loc) · 49.6 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":"6659a5b6-87af-45ad-abb2-da716ab3296c","UI_PROP_DF_EXECUTION_ORDERED":"true"},"links":[],"nodes":{"id-1695185333761-11162":{"nodeType":"dataFlow","version":1,"id":"id-1695185333761-11162","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-1695179306737-1071":{"nodeType":"table","version":1,"id":"id-1695179306737-1071","name":"CARS","description":"CARS table from SASHELP library","note":{"version":1,"id":"id-1695179306742-1075","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_TABLE_URI":"SASData://SASHELP?CARS","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_USE_PERSISTED_TABLE_STRUCTURE":"false","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|outTable|0":"a704f90f-cf7f-46d4-8593-028829a2a585","UI_PROP_PORT_LABEL|outTable|0":null,"UI_PROP_PORT_DESCRIPTION|outTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1695179306737-1071"}},"id-1695181642343-2749":{"nodeType":"step","version":1,"id":"id-1695181642343-2749","name":"Query","note":{"version":1,"id":"id-1695181642349-2753","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_XPOS":"300","UI_PROP_YPOS":"56","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":"1695081542320","UI_PROP_PORT_ID|inTables|0":"5aa15113-fe5a-4a76-9126-b25353940d72","UI_PROP_PORT_LABEL|inTables|0":"Input tables 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Query input tables","UI_PROP_PORT_ID|outTable|0":"d9fbff0c-c806-4fa8-8790-82d25eaeace5","UI_PROP_PORT_LABEL|outTable|0":"Output table","UI_PROP_PORT_DESCRIPTION|outTable|0":"Query output table","UI_PROP_PORT_ID|inTables|1":"7bcbe4c9-6876-4d3f-bf07-0330caa69033","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":{"outputType":{"preferViewForNoTableNode":false}}},"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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":"id-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)","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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)","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},{"aggregate":null,"member":"CALCULATED","tableAlias":null,"isCalculated":true,"isModified":false,"inColumn":null,"calculatedColumn":{"referenceType":"columnDefinition","columnDefinition":{"name":"Diff","label":"Diff","type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"format":{"name":"DOLLAR","length":8,"decimals":0},"informat":{"name":null,"length":0,"decimals":0}},"outputPort":"outTable","outputPortIndex":0},"modifiedColumn":null,"expressionText":"t1.MSRP-t1.Invoice"}],"sessionId":"","selectDistinct":false,"whereFormattedFilter":"","whereQuickFilters":[],"havingFormattedFilter":"","havingQuickFilters":[],"orderByColumns":[{"tableAlias":"t1","member":"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Model","inputPort":"inTables","inputPortIndex":0},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t2","member":"id-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":1},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"}],"groupByColumns":[]}},"id-1695183992653-9148":{"nodeType":"outputTable","version":1,"id":"id-1695183992653-9148","name":"CARS_INFO","note":{"version":1,"id":"id-1695183992653-9152","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_TABLE_URI":"SASData://SASDM?CARS_INFO","UI_PROP_XPOS":"426","UI_PROP_YPOS":"56","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":"16ec750a-75be-437c-a578-a1192ee2f957||","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|inTable|0":"ece538f7-2516-42b2-9d88-3fba23638ca4","UI_PROP_PORT_LABEL|inTable|0":null,"UI_PROP_PORT_DESCRIPTION|inTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1695183992653-9148"},"outputTableArguments":{"advancedOptions":[],"arguments":{}}},"id-1695180659140-1367":{"nodeType":"file","version":1,"id":"id-1695180659140-1367","name":"Car_Make_Info","note":{"version":1,"id":"id-1695180659144-1371","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_XPOS":"48","UI_PROP_YPOS":"156","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":"7e52cb7d-4ca9-4796-8d1b-9f866010ba5f","UI_PROP_PORT_LABEL|outFile|0":null,"UI_PROP_PORT_DESCRIPTION|outFile|0":null},"fileReference":{"referenceType":"parameter","parameterId":"id-1695180659140-1367"}},"id-1695180889006-1740":{"nodeType":"step","version":1,"id":"id-1695180889006-1740","name":"Import","note":{"version":1,"id":"id-1695180889010-1744","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":"174","UI_PROP_YPOS":"156","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":"1695081540992","UI_PROP_PORT_ID|outTables|0":"88a5350e-8aba-41f0-8cd2-3d9185135360","UI_PROP_PORT_LABEL|outTables|0":"Output tables 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables","UI_PROP_PORT_ID|inFile|0":"1f3441e7-c248-409f-86f0-231f3b8852b0","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-1695179306737-1071":{"parameterType":"tableStructure","version":2,"id":"id-1695179306737-1071","name":"CARS","parameterUsage":"INPUT","defaultValue":{"table":{"name":"CARS","providerId":"Compute","dataSourceId":"Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~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":"c66286d1-ffba-4d0f-9257-34d09d941017","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-1695183992653-9148":{"parameterType":"table","version":1,"id":"id-1695183992653-9148","name":"CARS_INFO","parameterUsage":"OUTPUT","defaultValue":{"table":{"name":"CARS_INFO","providerId":"Compute","dataSourceId":"Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM","type":"dataTable","creationTimeStamp":"2023-09-20T05:03:51.066Z","modifiedTimeStamp":"2023-09-20T05:03:51.066Z","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~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~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~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/sessions/6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/sessions/6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO/columns?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables/CARS_INFO/columns?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM~fs~CARS_INFO/rows?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/rowSets/tables/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM~fs~CARS_INFO/rows?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASDM","name":"SASDM","providerId":"Compute","parentId":"c66286d1-ffba-4d0f-9257-34d09d941017","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/c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017~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/c66286d1-ffba-4d0f-9257-34d09d941017","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables","uri":"/dataTables/dataSources/Compute~fs~c66286d1-ffba-4d0f-9257-34d09d941017~fs~SASDM/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017/children?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017/children?sessionId=6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017/sessions/6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","uri":"/dataSources/providers/Compute/sources/c66286d1-ffba-4d0f-9257-34d09d941017/sessions/6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","type":"application/vnd.sas.data.session"}]}}},"id-1695180659140-1367":{"parameterType":"file","version":1,"id":"id-1695180659140-1367","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-1695179306737-1071","portName":"outTable","index":0},"targetPort":{"node":"id-1695181642343-2749","portName":"inTables","index":0}},{"sourcePort":{"node":"id-1695181642343-2749","portName":"outTable","index":0},"targetPort":{"node":"id-1695183992653-9148","portName":"inTable","index":0}},{"sourcePort":{"node":"id-1695180889006-1740","portName":"outTables","index":0},"targetPort":{"node":"id-1695181642343-2749","portName":"inTables","index":1}},{"sourcePort":{"node":"id-1695180659140-1367","portName":"outFile","index":0},"targetPort":{"node":"id-1695180889006-1740","portName":"inFile","index":0}}],"extendedProperties":{"UI_MODEL|id-1695181642343-2749":"{\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"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\":\"_flw001169518088900617400000\"}],\"queryJoins\":[{\"id\":\"82f7c369-22b1-f21c-6272-e0ac77f4ade1\",\"leftTable\":{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"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\":\"_flw001169518088900617400000\"},\"conditions\":[{\"id\":\"282bffff-13ee-3c85-2575-3ec2b6f95ad4\",\"leftTableAlias\":\"t1\",\"leftColumn\":\"Make\",\"operator\":\"=\",\"rightTableAlias\":\"t2\",\"rightColumn\":\"MAKE\"}]}],\"selectedColumns\":[{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object703\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"alias\":\"Make\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":13,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object704\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"alias\":\"Model\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":40,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object705\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Type\",\"alias\":\"Type\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object706\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Origin\",\"alias\":\"Origin\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":6,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object708\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"MSRP\",\"alias\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object709\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Invoice\",\"alias\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"Import\",\"member\":\"id-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object720\",\"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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"alias\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"length\":34,\"type\":\"Char\"},{\"libname\":\"Import\",\"member\":\"id-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object719\",\"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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\"},\"name\":\"WEBSITE\",\"alias\":\"WEBSITE\",\"format\":\"$52.\",\"informat\":\"$52.\",\"label\":\"\",\"length\":52,\"type\":\"Char\"},{\"libname\":\"CALCULATED\",\"member\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object750\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"t1.MSRP-t1.Invoice\",\"expressionText\":\"t1.MSRP-t1.Invoice\",\"name\":\"Diff\",\"label\":\"Diff\",\"length\":8,\"format\":\"DOLLAR8.\",\"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\",\"columnType\":\"Numeric\"},\"name\":\"Diff\",\"alias\":\"Diff\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"Diff\",\"length\":8,\"type\":\"Numeric\"}],\"whereFilter\":\"\",\"whereFormattedFilter\":\"\",\"useWhereAdvancedExpression\":false,\"whereQuickFilters\":[],\"groupByColumns\":[],\"havingFilter\":\"\",\"havingFormattedFilter\":\"\",\"useHavingAdvancedExpression\":false,\"havingQuickFilters\":[],\"joinFilter\":\"\",\"joinFormattedFilter\":\"\",\"useJoinAdvancedExpression\":false,\"orderByColumns\":[{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object703\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object704\",\"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-1695181642343-2749.inTables.1(5aa15113-fe5a-4a76-9126-b25353940d72)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"sortDirection\":\"ASC\"},{\"libname\":\"Import\",\"member\":\"id-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object720\",\"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-1695181642343-2749.inTables.2(7bcbe4c9-6876-4d3f-bf07-0330caa69033)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"sortDirection\":\"ASC\"}],\"calculatedColumns\":[{\"mEventRegistry\":{},\"sId\":\"__object750\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"t1.MSRP-t1.Invoice\",\"expressionText\":\"t1.MSRP-t1.Invoice\",\"name\":\"Diff\",\"label\":\"Diff\",\"length\":8,\"format\":\"DOLLAR8.\",\"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\",\"columnType\":\"Numeric\"}],\"flowmode\":true,\"codeGenerationOption\":\"\",\"applyFormatsFedSQL\":false}}"},"stickyNotes":[]},"executionBindings":{"sessionId":"6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","contextId":"c66286d1-ffba-4d0f-9257-34d09d941017","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1695185333796-11167":{"nodeType":"dataFlow","version":1,"id":"id-1695185333796-11167","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-1695185191593-10521":{"nodeType":"step","version":1,"id":"id-1695185191593-10521","name":"Generate SAS librefs for caslibs","note":{"version":1,"id":"id-1695185191597-10525","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":"48","UI_PROP_YPOS":"280","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"9b4576c2-41c5-4166-8607-cd1fe8d252da|Input tables 1|Input tables","UI_PROP_OUTPUT_PORT|outTables|0":"d192b343-fe45-4508-9993-2e553cfe4e08|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1695081539076"},"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 &sysuserid._session;\ncaslib _all_ assign;\n\n\n\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"}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","contextId":"c66286d1-ffba-4d0f-9257-34d09d941017","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1695185721950-12610":{"nodeType":"dataFlow","version":1,"id":"id-1695185721950-12610","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-1695185918564-13451":{"nodeType":"step","version":1,"id":"id-1695185918564-13451","name":"SAS Program","note":{"version":1,"id":"id-1695185918565-13455","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":"0ffcb3b0-4793-4d32-ad97-b749b8f6233d|Input tables 1|Input tables","UI_PROP_OUTPUT_PORT|outTables|0":"1a91251d-c28d-48c1-a184-4fbbb12d4dce|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1695081539076"},"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=&sysuserid._session;\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 */\nquit;\ncas &sysuserid._session terminate;","logHTML":"","resultsHTML":"","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":"6d3eca54-adb8-4134-b57f-c7a6a2667dee-ses0000","contextId":"c66286d1-ffba-4d0f-9257-34d09d941017","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]}