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) · 52.8 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":"e8fc86b5-4da5-4c7f-96c5-5b6d5d0c1188","UI_PROP_DF_EXECUTION_ORDERED":"true"},"links":[],"nodes":{"id-1711741948281-20271":{"nodeType":"dataFlow","version":1,"id":"id-1711741948281-20271","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-1711741924530-19906":{"nodeType":"step","version":1,"id":"id-1711741924530-19906","name":"Generate SAS librefs for caslibs","note":{"version":1,"id":"id-1711741924533-19910","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":"289","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"d728fefc-b791-41af-8035-794eb462d64f|Input table 1|Input tables","UI_PROP_OUTPUT_PORT|outTables|0":"cf6e773b-367a-4aff-8f2a-5ef4d2e785e0|Output table 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1711732678596"},"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":"b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","contextId":"3a0158ab-46f3-457d-bcd4-f906389b0569","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1711741948262-20266":{"nodeType":"dataFlow","version":1,"id":"id-1711741948262-20266","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-1711741495154-14479":{"nodeType":"step","version":1,"id":"id-1711741495154-14479","name":"Query","note":{"version":1,"id":"id-1711741495155-14483","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":"364","UI_PROP_YPOS":"46","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":"1711732680466","UI_PROP_PORT_ID|inTables|0":"0d9b7c9d-9022-4a84-920e-954f976794f1","UI_PROP_PORT_LABEL|inTables|0":"Input table 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Query input tables","UI_PROP_PORT_ID|outTable|0":"d3c63792-bb85-4aee-b7eb-01467cbf0a08","UI_PROP_PORT_LABEL|outTable|0":"Output table","UI_PROP_PORT_DESCRIPTION|outTable|0":"Query output table","UI_PROP_PORT_ID|inTables|1":"be296bd5-5858-4ca7-b121-8650aa3ccf17","UI_PROP_PORT_LABEL|inTables|1":"Input table 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-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Make","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Model","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Type","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Origin","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"DriveTrain","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"MSRP","inputPort":"inTables","inputPortIndex":1},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","tableAlias":"t2","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Invoice","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":"","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":"MSRP-Invoice"},{"aggregate":null,"member":"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"WEBSITE","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null}],"sessionId":"","selectDistinct":false,"whereFormattedFilter":"","whereQuickFilters":[],"havingFormattedFilter":"","havingQuickFilters":[],"orderByColumns":[{"tableAlias":"t1","member":"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":0},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t2","member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Make","inputPort":"inTables","inputPortIndex":1},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t2","member":"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"Model","inputPort":"inTables","inputPortIndex":1},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"}],"groupByColumns":[]}},"id-1711736801255-1852":{"nodeType":"file","version":1,"id":"id-1711736801255-1852","name":"Car_Make_Info","note":{"version":1,"id":"id-1711736801257-1856","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":"48","UI_PROP_YPOS":"48","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":"8d2fcc76-4daf-4fd3-930e-c5a3222afafa","UI_PROP_PORT_LABEL|outFile|0":null,"UI_PROP_PORT_DESCRIPTION|outFile|0":null},"fileReference":{"referenceType":"parameter","parameterId":"id-1711736801255-1852"}},"id-1711736816381-2015":{"nodeType":"step","version":1,"id":"id-1711736816381-2015","name":"Import","note":{"version":1,"id":"id-1711736816383-2019","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":"225","UI_PROP_YPOS":"48","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":"1711732679358","UI_PROP_PORT_ID|inFile|0":"d28f9c99-5196-48d9-9d47-9a635ef3b73c","UI_PROP_PORT_LABEL|inFile|0":"Input file","UI_PROP_PORT_DESCRIPTION|inFile|0":"Input file to import","UI_PROP_PORT_ID|outTables|0":"d3d10fac-29cd-4a3f-b340-f5b967315c75","UI_PROP_PORT_LABEL|outTables|0":"Output table 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables"},"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"}},"id-1711741677259-17229":{"nodeType":"outputTable","version":1,"id":"id-1711741677259-17229","name":"CARS_INFO","note":{"version":1,"id":"id-1711741677260-17233","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_TABLE_URI":"SASData://SASDM?CARS_INFO","UI_PROP_XPOS":"505","UI_PROP_YPOS":"49","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":"eb094b03-05a5-4377-950a-acea68420cc0||","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|inTable|0":"69a4e12d-b762-419d-a118-010a61872915","UI_PROP_PORT_LABEL|inTable|0":null,"UI_PROP_PORT_DESCRIPTION|inTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1711741677259-17229"},"outputTableArguments":{"advancedOptions":[],"arguments":{}}},"id-1711736733860-1623":{"nodeType":"table","version":1,"id":"id-1711736733860-1623","name":"CARS","description":"CARS Table from SASHELP library","note":{"version":1,"id":"id-1711736733863-1627","name":null,"description":"CARS Table from SASHELP library","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_TABLE_URI":"SASData://SASHELP?CARS","UI_PROP_XPOS":"227","UI_PROP_YPOS":"134","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":"7d913b44-6ebb-4deb-964b-71183da97dd0","UI_PROP_PORT_LABEL|outTable|0":null,"UI_PROP_PORT_DESCRIPTION|outTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1711736733860-1623"}}},"parameters":{"id-1711736801255-1852":{"parameterType":"file","version":1,"id":"id-1711736801255-1852","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"}},"id-1711741677259-17229":{"parameterType":"table","version":1,"id":"id-1711741677259-17229","name":"CARS_INFO","parameterUsage":"OUTPUT","defaultValue":{"table":{"name":"CARS_INFO","providerId":"Compute","dataSourceId":"Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM","type":"dataTable","creationTimeStamp":"2024-03-29T19:58:40.914Z","modifiedTimeStamp":"2024-03-29T19:58:40.914Z","attributes":{"bookmarkLength":12,"columnCount":10,"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~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~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~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/sessions/b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/sessions/b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO/columns?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables/CARS_INFO/columns?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM~fs~CARS_INFO/rows?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/rowSets/tables/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM~fs~CARS_INFO/rows?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASDM","name":"SASDM","providerId":"Compute","parentId":"3a0158ab-46f3-457d-bcd4-f906389b0569","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/3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569~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/3a0158ab-46f3-457d-bcd4-f906389b0569","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables","uri":"/dataTables/dataSources/Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASDM/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569/children?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569/children?sessionId=b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569/sessions/b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","uri":"/dataSources/providers/Compute/sources/3a0158ab-46f3-457d-bcd4-f906389b0569/sessions/b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","type":"application/vnd.sas.data.session"}]}}},"id-1711736733860-1623":{"parameterType":"tableStructure","version":2,"id":"id-1711736733860-1623","name":"CARS","parameterUsage":"INPUT","defaultValue":{"table":{"name":"CARS","providerId":"Compute","dataSourceId":"Compute~fs~3a0158ab-46f3-457d-bcd4-f906389b0569~fs~SASHELP","type":"dataTable","label":"2004 Car Data","creationTimeStamp":"2023-10-10T18:16:58.994Z","modifiedTimeStamp":"2023-10-10T18:16:58.994Z","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":"3a0158ab-46f3-457d-bcd4-f906389b0569","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":{}}]}},"connections":[{"sourcePort":{"node":"id-1711736801255-1852","portName":"outFile","index":0},"targetPort":{"node":"id-1711736816381-2015","portName":"inFile","index":0}},{"sourcePort":{"node":"id-1711736816381-2015","portName":"outTables","index":0},"targetPort":{"node":"id-1711741495154-14479","portName":"inTables","index":0}},{"sourcePort":{"node":"id-1711741495154-14479","portName":"outTable","index":0},"targetPort":{"node":"id-1711741677259-17229","portName":"inTable","index":0}},{"sourcePort":{"node":"id-1711736733860-1623","portName":"outTable","index":0},"targetPort":{"node":"id-1711741495154-14479","portName":"inTables","index":1}}],"extendedProperties":{"UI_MODEL|id-1711741495154-14479":"{\"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\":\"Import\",\"member\":\"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"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\":\"t1\",\"selectTableStar\":false,\"tableSourceLibrary\":\"\",\"workTableName\":\"_flw001171173681638120150000\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"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\":\"t2\",\"selectTableStar\":false,\"engine\":\"V9\",\"tableSourceLibrary\":\"SASHELP\",\"workTableName\":\"\"}],\"queryJoins\":[{\"id\":\"8d5e4ae0-4b4e-4f40-92dd-d051144908e6\",\"leftTable\":{\"libname\":\"Import\",\"member\":\"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"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\":\"t1\",\"selectTableStar\":false,\"tableSourceLibrary\":\"\",\"workTableName\":\"_flw001171173681638120150000\"},\"joinType\":\"INNER JOIN\",\"rightTable\":{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"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\":\"t2\",\"selectTableStar\":false,\"engine\":\"V9\",\"tableSourceLibrary\":\"SASHELP\",\"workTableName\":\"\"},\"conditions\":[{\"id\":\"86c88a12-fec7-42de-bed9-cfcf39755e10\",\"leftTableAlias\":\"t1\",\"leftColumn\":\"MAKE\",\"operator\":\"=\",\"rightTableAlias\":\"t2\",\"rightColumn\":\"Make\"}]}],\"selectedColumns\":[{\"libname\":\"Import\",\"member\":\"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3342\",\"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-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\"},\"name\":\"PARENT_COMPANY\",\"alias\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"length\":34,\"type\":\"Char\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3344\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Make\",\"alias\":\"Make\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":13,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3345\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Model\",\"alias\":\"Model\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":40,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3346\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Type\",\"alias\":\"Type\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3347\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Origin\",\"alias\":\"Origin\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":6,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3348\",\"mProperties\":{\"name\":\"DriveTrain\",\"columnType\":\"CHAR\",\"length\":5,\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"DriveTrain\",\"alias\":\"DriveTrain\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":5,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3349\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"MSRP\",\"alias\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3350\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Invoice\",\"alias\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CALCULATED\",\"member\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object4857\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"MSRP-Invoice\",\"expressionText\":\"MSRP-Invoice\",\"name\":\"Diff\",\"label\":\"\",\"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\"},\"name\":\"Diff\",\"alias\":\"Diff\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"Import\",\"member\":\"id-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3341\",\"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-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\"},\"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-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3342\",\"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-1711741495154-14479.inTables.1(0d9b7c9d-9022-4a84-920e-954f976794f1)\",\"tableAlias\":\"t1\"},\"name\":\"PARENT_COMPANY\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3344\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Make\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3345\",\"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-1711741495154-14479.inTables.2(be296bd5-5858-4ca7-b121-8650aa3ccf17)\",\"tableAlias\":\"t2\"},\"name\":\"Model\",\"sortDirection\":\"ASC\"}],\"calculatedColumns\":[{\"mEventRegistry\":{},\"sId\":\"__object4857\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"MSRP-Invoice\",\"expressionText\":\"MSRP-Invoice\",\"name\":\"Diff\",\"label\":\"\",\"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\"}],\"flowmode\":true,\"codeGenerationOption\":\"\",\"applyFormatsFedSQL\":false}}"},"stickyNotes":[]},"executionBindings":{"sessionId":"b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","contextId":"3a0158ab-46f3-457d-bcd4-f906389b0569","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1711742035254-21178":{"nodeType":"dataFlow","version":1,"id":"id-1711742035254-21178","name":"Load Table to CAS","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-1711742070136-21517":{"nodeType":"step","version":1,"id":"id-1711742070136-21517","name":"Terminate CAS Session","note":{"version":1,"id":"id-1711742070137-21521","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":"182","UI_PROP_YPOS":"414","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_OUTPUT_PORT|outTables|0":"afe2cd64-7841-4b33-aeeb-28685435c246|Output table 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1711732678596","UI_PROP_PORT_ID|inTables|0":"0cdfedf1-5e36-488f-92e3-ee4657211ec7","UI_PROP_PORT_LABEL|inTables|0":"Input table 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 &sysuserid._session 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"}}},"id-1711742177902-22231":{"nodeType":"step","version":1,"id":"id-1711742177902-22231","name":"SAS Program","note":{"version":1,"id":"id-1711742177902-22235","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":"48","UI_PROP_YPOS":"418","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"18267547-e67d-40ed-945a-d874d4bfa043|Input table 1|Input tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1711732678596","UI_PROP_PORT_ID|outTables|0":"95aa86de-31eb-4f84-b461-b3e5859f3bc8","UI_PROP_PORT_LABEL|outTables|0":"Output table 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=&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 */\nrun;","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":[{"sourcePort":{"node":"id-1711742177902-22231","portName":"outTables","index":0},"targetPort":{"node":"id-1711742070136-21517","portName":"inTables","index":0}}],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"b392c84f-28b5-4fad-99bd-470f142fc71e-ses0000","contextId":"3a0158ab-46f3-457d-bcd4-f906389b0569","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]}