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) · 70.7 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":"6b43c18b-56f9-46b7-970b-f4bd475df783","UI_PROP_DF_EXECUTION_ORDERED":"true"},"links":[],"nodes":{"id-1680624555239-10998":{"nodeType":"dataFlow","version":1,"id":"id-1680624555239-10998","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-1680624387461-9657":{"nodeType":"step","version":1,"id":"id-1680624387461-9657","name":"Generate SAS librefs for caslibs","note":{"version":1,"id":"id-1680624387464-9661","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":0,"properties":{"UI_PROP_XPOS":"48","UI_PROP_YPOS":"46","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"8259c669-0b9d-4c1c-aa3f-5a293cbf388b|Input tables 1|Input tables","UI_PROP_OUTPUT_PORT|outTables|0":"a40e5372-c849-42b6-8a11-0f819ab54eae|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1680613622743"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepUri":"/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}},{"name":"_input1","value":{"referenceType":"inputPort","portName":"inTables","portIndex":0}}],"contentType":"embedded"}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","contextId":"51a92382-094e-48eb-bde0-46f97fc74f14","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}},"id-1680624555253-11003":{"nodeType":"dataFlow","version":1,"id":"id-1680624555253-11003","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-1680622949412-1295":{"nodeType":"file","version":1,"id":"id-1680622949412-1295","name":"Car_Make_Info","note":{"version":1,"id":"id-1680622949413-1299","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":"56","UI_PROP_YPOS":"170","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":"e1efb2da-f6e0-4813-bd8c-af1c4b732a39","UI_PROP_PORT_LABEL|outFile|0":"undefined 1","UI_PROP_PORT_DESCRIPTION|outFile|0":null},"fileReference":{"referenceType":"parameter","parameterId":"id-1680622949412-1295"}},"id-1680623011224-1456":{"nodeType":"step","version":1,"id":"id-1680623011224-1456","name":"Import","note":{"version":1,"id":"id-1680623011225-1460","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":"182","UI_PROP_YPOS":"170","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":"1680613623613","UI_PROP_PORT_ID|inFile|0":"d748816a-dcf0-4748-8e39-79f2cef8ae75","UI_PROP_PORT_LABEL|inFile|0":"Input file 1","UI_PROP_PORT_DESCRIPTION|inFile|0":"Input file to import","UI_PROP_PORT_ID|outTables|0":"62691726-fad0-4fed-99fd-d3a3b6f32465","UI_PROP_PORT_LABEL|outTables|0":"Output tables 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables"},"stepUri":"/dataFlows/steps/d38ccdec-66bc-43d0-84f0-faf8d5812bad","arguments":{"importOption":{},"renameColumns":true,"excelFileImportOptions":{},"delimitedFileImportOptions":{"outputTable":{"referenceType":"outputPort","portName":"outTables","portIndex":0},"guessingRows":20,"firstObs":2,"delimiterSensitive":false,"missingRecordOption":"missover","outColumns":[{"referenceType":"columnDefinition","columnDefinition":{"name":"MAKE","label":"","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","label":"","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","label":"","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-1680623299015-3293":{"nodeType":"step","version":1,"id":"id-1680623299015-3293","name":"Query","note":{"version":1,"id":"id-1680623299015-3297","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":"415","UI_PROP_YPOS":"219","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":"1680613625213","UI_PROP_PORT_ID|inTables|1":"9b44b2f5-b046-468d-9b57-31af5cd19062","UI_PROP_PORT_LABEL|inTables|1":"Input tables 2","UI_PROP_PORT_DESCRIPTION|inTables|1":"Query input tables","UI_PROP_PORT_ID|outTable|0":"bda62a19-2c50-47d3-9a33-855b3bb0ee7d","UI_PROP_PORT_LABEL|outTable|0":"Output table 1","UI_PROP_PORT_DESCRIPTION|outTable|0":"Query output table","UI_PROP_PORT_ID|inTables|0":"144e12d4-5037-4ae7-a96e-1283522657f4","UI_PROP_PORT_LABEL|inTables|0":"Input tables 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Query input tables"},"stepUri":"/dataFlows/steps/c072ab75-0a02-4aa1-acf3-63fe9c17a711","arguments":{"fedSQL":false,"outputMode":"TABLE","useOutObs":false,"useInObs":false,"inObs":"","outObs":"","dataSetOptions":"","outputTable":{"referenceType":"outputPort","portName":"outTable","portIndex":0},"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-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","tableAlias":"t1","isCalculated":false,"isModified":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Invoice","inputPort":"inTables","inputPortIndex":0},"calculatedColumn":null,"modifiedColumn":null,"expressionText":null},{"aggregate":null,"member":"CALCULATED","tableAlias":"CALCULATED","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}},"outputPort":"outTable","outputPortIndex":0},"modifiedColumn":null,"expressionText":"t1.MSRP - t1.Invoice"}],"sessionId":"","selectDistinct":false,"whereFormattedFilter":"","whereQuickFilters":[],"havingFormattedFilter":"","havingQuickFilters":[],"orderByColumns":[{"tableAlias":"t2","member":"id-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":1,"columnName":"PARENT_COMPANY","inputPort":"inTables","inputPortIndex":1},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"},{"tableAlias":"t1","member":"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)","isCalculated":false,"inColumn":{"referenceType":"column","version":1,"port":"inTables","portIndex":0,"columnName":"Model","inputPort":"inTables","inputPortIndex":0},"expressionText":null,"calculatedColumnName":null,"sortDirection":"ASC"}],"groupByColumns":[]}},"id-1680624014062-7444":{"nodeType":"outputTable","version":1,"id":"id-1680624014062-7444","name":"CARS_INFO","note":{"version":1,"id":"id-1680624014062-7448","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":"554","UI_PROP_YPOS":"219","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":"7ce757ea-008c-4307-b36e-573fe3d5b01e|undefined 1|","UI_PROP_NODE_DATA_ID":"table","UI_PROP_PORT_ID|inTable|0":"0a231e26-6edd-4413-84b2-adb0773946a1","UI_PROP_PORT_LABEL|inTable|0":"undefined 1","UI_PROP_PORT_DESCRIPTION|inTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1680624014062-7444"},"outputTableArguments":{"advancedOptions":[],"arguments":{}}},"id-1680622170268-774":{"nodeType":"table","version":1,"id":"id-1680622170268-774","name":"CARS","description":"CARS Table from SASHELP library.","note":{"version":1,"id":"id-1680622170271-778","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_TABLE_URI":"SASData://SASHELP?CARS","UI_PROP_XPOS":"48","UI_PROP_YPOS":"265","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":"ddb769cf-dc2f-4c85-b59e-3907df1aed5b","UI_PROP_PORT_LABEL|outTable|0":"undefined 1","UI_PROP_PORT_DESCRIPTION|outTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1680622170268-774"}}},"parameters":{"id-1680622949412-1295":{"parameterType":"file","version":1,"id":"id-1680622949412-1295","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-1680624014062-7444":{"parameterType":"table","version":1,"id":"id-1680624014062-7444","name":"CARS_INFO","parameterUsage":"OUTPUT","defaultValue":{"table":{"name":"CARS_INFO","providerId":"Compute","dataSourceId":"Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","type":"dataTable","creationTimeStamp":"2023-04-04T16:16:01.673Z","modifiedTimeStamp":"2023-04-04T16:16:01.673Z","attributes":{"bookmarkLength":12,"columnCount":8,"compressionRoutine":"NO","encoding":"utf-8 Unicode (UTF-8)","engine":"V9","logicalRecordCount":394,"physicalRecordCount":394,"recordLength":128,"rowCount":394,"version":2},"version":2,"links":[{"method":"GET","rel":"self","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~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~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM~fs~CARS_INFO/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM~fs~CARS_INFO/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASDM","name":"SASDM","providerId":"Compute","parentId":"51a92382-094e-48eb-bde0-46f97fc74f14","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/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~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/51a92382-094e-48eb-bde0-46f97fc74f14","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"}]}}},"id-1680622170268-774":{"parameterType":"tableStructure","version":2,"id":"id-1680622170268-774","name":"CARS","parameterUsage":"INPUT","defaultValue":{"table":{"name":"CARS","providerId":"Compute","dataSourceId":"Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","type":"dataTable","label":"2004 Car Data","creationTimeStamp":"2022-09-09T15:55:58.476Z","modifiedTimeStamp":"2022-09-09T15:55:58.476Z","attributes":{"bookmarkLength":12,"columnCount":15,"compressionRoutine":"NO","encoding":"us-ascii ASCII (ANSI)","engine":"V9","logicalRecordCount":428,"physicalRecordCount":428,"recordLength":152,"rowCount":428,"version":2},"version":2,"links":[{"method":"GET","rel":"self","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","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~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP~fs~CARS/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP~fs~CARS/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASHELP","name":"SASHELP","providerId":"Compute","parentId":"51a92382-094e-48eb-bde0-46f97fc74f14","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":[{"method":"GET","rel":"self","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","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/51a92382-094e-48eb-bde0-46f97fc74f14","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"}]},"columns":[{"name":"Make","index":0,"type":"CHAR","rawLength":13,"formattedLength":0,"version":2,"attributes":{}},{"name":"Model","index":1,"type":"CHAR","rawLength":40,"formattedLength":0,"version":2,"attributes":{}},{"name":"Type","index":2,"type":"CHAR","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Origin","index":3,"type":"CHAR","rawLength":6,"formattedLength":0,"version":2,"attributes":{}},{"name":"DriveTrain","index":4,"type":"CHAR","rawLength":5,"formattedLength":0,"version":2,"attributes":{}},{"name":"MSRP","index":5,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"format":{"name":"DOLLAR","length":8,"decimals":0},"attributes":{"format":"DOLLAR8."}},{"name":"Invoice","index":6,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"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,"attributes":{}},{"name":"Cylinders","index":8,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Horsepower","index":9,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_City","label":"MPG (City)","index":10,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_Highway","label":"MPG (Highway)","index":11,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Weight","label":"Weight (LBS)","index":12,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Wheelbase","label":"Wheelbase (IN)","index":13,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Length","label":"Length (IN)","index":14,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}}]},"columns":[{"name":"Make","index":0,"type":"CHAR","rawLength":13,"formattedLength":0,"version":2,"attributes":{}},{"name":"Model","index":1,"type":"CHAR","rawLength":40,"formattedLength":0,"version":2,"attributes":{}},{"name":"Type","index":2,"type":"CHAR","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Origin","index":3,"type":"CHAR","rawLength":6,"formattedLength":0,"version":2,"attributes":{}},{"name":"DriveTrain","index":4,"type":"CHAR","rawLength":5,"formattedLength":0,"version":2,"attributes":{}},{"name":"MSRP","index":5,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"format":{"name":"DOLLAR","length":8,"decimals":0},"attributes":{"format":"DOLLAR8."}},{"name":"Invoice","index":6,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"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,"attributes":{}},{"name":"Cylinders","index":8,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Horsepower","index":9,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_City","label":"MPG (City)","index":10,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_Highway","label":"MPG (Highway)","index":11,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Weight","label":"Weight (LBS)","index":12,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Wheelbase","label":"Wheelbase (IN)","index":13,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Length","label":"Length (IN)","index":14,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}}]}},"connections":[{"sourcePort":{"node":"id-1680622949412-1295","portName":"outFile","index":0},"targetPort":{"node":"id-1680623011224-1456","portName":"inFile","index":0}},{"sourcePort":{"node":"id-1680623011224-1456","portName":"outTables","index":0},"targetPort":{"node":"id-1680623299015-3293","portName":"inTables","index":1}},{"sourcePort":{"node":"id-1680623299015-3293","portName":"outTable","index":0},"targetPort":{"node":"id-1680624014062-7444","portName":"inTable","index":0}},{"sourcePort":{"node":"id-1680622170268-774","portName":"outTable","index":0},"targetPort":{"node":"id-1680623299015-3293","portName":"inTables","index":0}}],"extendedProperties":{"UI_MODEL|id-1680623299015-3293":"{\"queryOption\":{\"autoSelectGroups\":true,\"selectDistinct\":false,\"selectStar\":false,\"initialized\":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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"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\":\"CARS\"},{\"libname\":\"Import\",\"member\":\"id-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"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\":\"_flw001168062301122414560000\"}],\"queryJoins\":[{\"id\":\"081ca722-d681-e762-3e61-0d99a32d174c\",\"leftTable\":{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"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\":\"CARS\"},\"joinType\":\"INNER JOIN\",\"rightTable\":{\"libname\":\"Import\",\"member\":\"id-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"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\":\"_flw001168062301122414560000\"},\"conditions\":[{\"id\":\"94bcff46-4e56-083d-24ab-c728caec4539\",\"leftTableAlias\":\"t1\",\"leftColumn\":\"Make\",\"operator\":\"=\",\"rightTableAlias\":\"t2\",\"rightColumn\":\"MAKE\"}]}],\"selectedColumns\":[{\"libname\":\"Import\",\"member\":\"id-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object971\",\"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-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"alias\":\"PARENT_COMPANY\",\"format\":\"$34.\",\"informat\":\"$34.\",\"label\":\"\",\"length\":34,\"type\":\"Char\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object954\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"alias\":\"Make\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":13,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object955\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"alias\":\"Model\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":40,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object956\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Type\",\"alias\":\"Type\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object957\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Origin\",\"alias\":\"Origin\",\"format\":\"\",\"informat\":\"\",\"label\":\"\",\"length\":6,\"type\":\"CHAR\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object959\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"MSRP\",\"alias\":\"MSRP\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object960\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Invoice\",\"alias\":\"Invoice\",\"format\":\"DOLLAR8.\",\"informat\":\"\",\"label\":\"\",\"length\":8,\"type\":\"Numeric\"},{\"libname\":\"CALCULATED\",\"member\":\"CALCULATED\",\"tableAlias\":\"CALCULATED\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object3177\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"t1.MSRP - t1.Invoice\",\"expressionText\":\"t1.MSRP - t1.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\"}],\"whereFilter\":\"\",\"whereFormattedFilter\":\"\",\"useWhereAdvancedExpression\":false,\"whereQuickFilters\":[],\"groupByColumns\":[],\"havingFilter\":\"\",\"havingFormattedFilter\":\"\",\"useHavingAdvancedExpression\":false,\"havingQuickFilters\":[],\"joinFilter\":\"\",\"joinFormattedFilter\":\"\",\"useJoinAdvancedExpression\":false,\"orderByColumns\":[{\"libname\":\"Import\",\"member\":\"id-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"tableAlias\":\"t2\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object971\",\"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-1680623299015-3293.inTables.2(9b44b2f5-b046-468d-9b57-31af5cd19062)\",\"tableAlias\":\"t2\"},\"name\":\"PARENT_COMPANY\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object954\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Make\",\"sortDirection\":\"ASC\"},{\"libname\":\"CARS\",\"member\":\"id-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\",\"sourceColumn\":{\"mEventRegistry\":{},\"sId\":\"__object955\",\"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-1680623299015-3293.inTables.1(144e12d4-5037-4ae7-a96e-1283522657f4)\",\"tableAlias\":\"t1\"},\"name\":\"Model\",\"sortDirection\":\"ASC\"}],\"calculatedColumns\":[{\"mEventRegistry\":{},\"sId\":\"__object3177\",\"mProperties\":{\"isExpression\":true,\"formattedExpressionText\":\"t1.MSRP - t1.Invoice\",\"expressionText\":\"t1.MSRP - t1.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":"bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","contextId":"51a92382-094e-48eb-bde0-46f97fc74f14","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"},"id-1680624014062-7444":{"argumentType":"table","version":1,"value":{"table":{"name":"CARS_INFO","providerId":"Compute","dataSourceId":"Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","type":"dataTable","creationTimeStamp":"2023-04-04T16:16:01.673Z","modifiedTimeStamp":"2023-04-04T16:16:01.673Z","attributes":{"bookmarkLength":12,"columnCount":8,"compressionRoutine":"NO","encoding":"utf-8 Unicode (UTF-8)","engine":"V9","logicalRecordCount":394,"physicalRecordCount":394,"recordLength":128,"rowCount":394,"version":2},"version":2,"links":[{"method":"GET","rel":"self","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~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~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables/CARS_INFO/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM~fs~CARS_INFO/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM~fs~CARS_INFO/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASDM","name":"SASDM","providerId":"Compute","parentId":"51a92382-094e-48eb-bde0-46f97fc74f14","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/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~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/51a92382-094e-48eb-bde0-46f97fc74f14","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASDM/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"}]}}},"id-1680622170268-774":{"argumentType":"tableStructure","version":1,"value":{"table":{"table":{"name":"CARS","providerId":"Compute","dataSourceId":"Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","type":"dataTable","label":"2004 Car Data","creationTimeStamp":"2022-09-09T15:55:58.476Z","modifiedTimeStamp":"2022-09-09T15:55:58.476Z","attributes":{"bookmarkLength":12,"columnCount":15,"compressionRoutine":"NO","encoding":"us-ascii ASCII (ANSI)","engine":"V9","logicalRecordCount":428,"physicalRecordCount":428,"recordLength":152,"rowCount":428,"version":2},"version":2,"links":[{"method":"GET","rel":"self","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","type":"application/vnd.sas.data.table"},{"method":"GET","rel":"alternate","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS","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~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"},{"method":"GET","rel":"sessionScoped","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"up","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"columns","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables/CARS/columns?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.column.summary"},{"method":"GET","rel":"rows","href":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP~fs~CARS/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/rowSets/tables/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP~fs~CARS/rows?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.row"},{"method":"GET","rel":"dataSource","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.source"}]},"source":{"id":"SASHELP","name":"SASHELP","providerId":"Compute","parentId":"51a92382-094e-48eb-bde0-46f97fc74f14","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":[{"method":"GET","rel":"self","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"alternate","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP","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/51a92382-094e-48eb-bde0-46f97fc74f14","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14","type":"application/vnd.sas.data.source"},{"method":"GET","rel":"tables","href":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables","uri":"/dataTables/dataSources/Compute~fs~51a92382-094e-48eb-bde0-46f97fc74f14~fs~SASHELP/tables","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.table"},{"method":"GET","rel":"sessionScoped","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/children?sessionId=bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.source"},{"method":"GET","rel":"session","href":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","uri":"/dataSources/providers/Compute/sources/51a92382-094e-48eb-bde0-46f97fc74f14/sessions/bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","type":"application/vnd.sas.data.session"}]},"columns":[{"name":"Make","index":0,"type":"CHAR","rawLength":13,"formattedLength":0,"version":2,"attributes":{}},{"name":"Model","index":1,"type":"CHAR","rawLength":40,"formattedLength":0,"version":2,"attributes":{}},{"name":"Type","index":2,"type":"CHAR","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Origin","index":3,"type":"CHAR","rawLength":6,"formattedLength":0,"version":2,"attributes":{}},{"name":"DriveTrain","index":4,"type":"CHAR","rawLength":5,"formattedLength":0,"version":2,"attributes":{}},{"name":"MSRP","index":5,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"format":{"name":"DOLLAR","length":8,"decimals":0},"attributes":{"format":"DOLLAR8."}},{"name":"Invoice","index":6,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"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,"attributes":{}},{"name":"Cylinders","index":8,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Horsepower","index":9,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_City","label":"MPG (City)","index":10,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"MPG_Highway","label":"MPG (Highway)","index":11,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Weight","label":"Weight (LBS)","index":12,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Wheelbase","label":"Wheelbase (IN)","index":13,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}},{"name":"Length","label":"Length (IN)","index":14,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"attributes":{}}]},"columnMappings":{}}}}}}},"id-1680624814649-13466":{"nodeType":"dataFlow","version":1,"id":"id-1680624814649-13466","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-1680624921459-14504":{"nodeType":"step","version":1,"id":"id-1680624921459-14504","name":"Terminate CAS Session","note":{"version":1,"id":"id-1680624921460-14508","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":"181","UI_PROP_YPOS":"389","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_OUTPUT_PORT|outTables|0":"e557ea0a-f6ee-4e8a-ad32-a726ed48e278|Output tables 1|Output tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1680613622743","UI_PROP_PORT_ID|inTables|0":"65257a19-2765-4fd6-9c5d-d6f2015f6a80","UI_PROP_PORT_LABEL|inTables|0":"Input tables 1","UI_PROP_PORT_DESCRIPTION|inTables|0":"Input tables"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepUri":"/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}}],"contentType":"embedded"}}},"id-1680624814834-13472":{"nodeType":"step","version":1,"id":"id-1680624814834-13472","name":"Load Table to CAS","note":{"version":1,"id":"id-1680624814834-13476","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":"391","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_INPUT_PORT|inTables|0":"69b72047-687c-47fb-96ac-94ed7b1e41cd|Input tables 1|Input tables","UI_PROP_NODE_DATA_ID":"a7190700-f59c-4a94-afe2-214ce639fcde","UI_PROP_NODE_DATA_MODIFIED_DATE":"1680613622743","UI_PROP_PORT_ID|outTables|0":"4bcaaa62-be33-46fc-aaa1-2e77c3b0c65c","UI_PROP_PORT_LABEL|outTables|0":"Output tables 1","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables"},"portMappings":[{"mappingType":"tableStructure","portName":"outTables","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepUri":"/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;\n","logHTML":"","resultsHTML":"","variables":[{"name":"_output1","value":{"referenceType":"outputPort","portName":"outTables","portIndex":0}},{"name":"_input1","value":{"referenceType":"inputPort","portName":"inTables","portIndex":0}}],"contentType":"embedded"}}}},"parameters":{},"connections":[{"sourcePort":{"node":"id-1680624814834-13472","portName":"outTables","index":0},"targetPort":{"node":"id-1680624921459-14504","portName":"inTables","index":0}}],"extendedProperties":{},"stickyNotes":[]},"executionBindings":{"sessionId":"bbad253b-3a85-4668-9887-5e9181e0ed7a-ses0000","contextId":"51a92382-094e-48eb-bde0-46f97fc74f14","environmentId":"Compute","tempTablePrefix":null,"arguments":{"__NO_OPTIMIZE":{"argumentType":"string","version":1,"value":"true"}}}}}},"parameters":{},"connections":[],"extendedProperties":{},"stickyNotes":[]}