forked from maquee-sas/SASStudioWorkshop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CalcGeoDist.flw
1 lines (1 loc) · 8.7 KB
/
CalcGeoDist.flw
1
{"creationTimeStamp":"2023-12-18T16:43:20.610Z","modifiedTimeStamp":"2023-12-18T16:43:20.610Z","createdBy":"Alex","modifiedBy":"Alex","version":2,"id":null,"name":"CalcGeoDist.flw","description":null,"properties":{"UI_PROP_DF_OPTIMIZE":"false","UI_PROP_DF_ID":"75c9f29a-0abb-4fc8-befc-5ec6426d1d86","UI_PROP_DF_EXECUTION_ORDERED":"false"},"links":[{"method":"GET","rel":"self","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","type":"application/vnd.sas.data.flow"},{"method":"GET","rel":"alternate","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","type":"application/vnd.sas.data.flow.summary"},{"method":"GET","rel":"up","href":"/dataFlows/dataFlows","uri":"/dataFlows/dataFlows","type":"application/vnd.sas.collection","itemType":"application/vnd.sas.data.flow.summary"},{"method":"PUT","rel":"update","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","type":"application/vnd.sas.data.flow","responseType":"application/vnd.sas.data.flow"},{"method":"DELETE","rel":"delete","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76"},{"method":"GET","rel":"transferExport","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","responseType":"application/vnd.sas.transfer.object"},{"method":"PUT","rel":"transferImportUpdate","href":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","uri":"/dataFlows/dataFlows/e7e7dea4-71e8-4f3e-8a77-ee86f3132a76","type":"application/vnd.sas.transfer.object","responseType":"application/vnd.sas.summary"}],"nodes":{"id-1702917532480-1458":{"nodeType":"file","version":1,"id":"id-1702917532480-1458","name":"Location_Data","note":{"version":1,"id":"id-1702917532483-1462","name":null,"description":null,"properties":{"UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_IS_STICKYNOTE":"false","UI_NOTE_PROP_WIDTH":"0"}},"priority":0,"properties":{"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_DESCRIPTION|outFile|0":"","UI_PROP_PORT_ID|outFile|0":"cad95e33-f2e9-4dfa-90df-ee5bbb19640d","UI_PROP_PORT_LABEL|outFile|0":"","UI_PROP_XPOS":"48","UI_PROP_YPOS":"46"},"fileReference":{"referenceType":"parameter","parameterId":"id-1702917532480-1458"}},"id-1702917583961-1611":{"nodeType":"step","version":1,"id":"id-1702917583961-1611","name":"Import","note":{"version":1,"id":"id-1702917583963-1615","name":null,"description":null,"properties":{"UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_IS_STICKYNOTE":"false","UI_NOTE_PROP_WIDTH":"0"}},"priority":1,"properties":{"UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"d38ccdec-66bc-43d0-84f0-faf8d5812bad","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702574465874","UI_PROP_PORT_DESCRIPTION|inFile|0":"Input file to import","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables","UI_PROP_PORT_ID|inFile|0":"76913527-f8a4-4dec-a86f-35f4c6703606","UI_PROP_PORT_ID|outTables|0":"a7734ae8-c88a-4e4c-850c-c554709369d5","UI_PROP_PORT_LABEL|inFile|0":"Input file","UI_PROP_PORT_LABEL|outTables|0":"Sheet1","UI_PROP_XPOS":"174","UI_PROP_YPOS":"46"},"stepReference":{"type":"uri","path":"/dataFlows/steps/d38ccdec-66bc-43d0-84f0-faf8d5812bad"},"arguments":{"delimitedFileImportOptions":{},"excelFileImportOptions":{"dbms":"XLSX","range":{},"replace":true,"sheets":[{"index":0,"name":"Sheet1","outColumns":[{"columnDefinition":{"format":{"decimals":0,"length":44,"name":"$"},"formattedLength":0,"informat":{"decimals":0,"length":44,"name":"$"},"label":"country","name":"country","rawLength":44,"type":"Char","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"},{"columnDefinition":{"format":{"decimals":0,"length":0,"name":"BEST"},"formattedLength":0,"informat":{"decimals":0,"length":0,"name":null},"label":"country_latitude","name":"country_latitude","rawLength":8,"type":"Numeric","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"},{"columnDefinition":{"format":{"decimals":0,"length":0,"name":"BEST"},"formattedLength":0,"informat":{"decimals":0,"length":0,"name":null},"label":"country_longitude","name":"country_longitude","rawLength":8,"type":"Numeric","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"},{"columnDefinition":{"format":{"decimals":0,"length":16,"name":"$"},"formattedLength":0,"informat":{"decimals":0,"length":16,"name":"$"},"label":"Location","name":"Location","rawLength":16,"type":"Char","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"},{"columnDefinition":{"format":{"decimals":0,"length":0,"name":"BEST"},"formattedLength":0,"informat":{"decimals":0,"length":0,"name":null},"label":"location_latitude","name":"location_latitude","rawLength":8,"type":"Numeric","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"},{"columnDefinition":{"format":{"decimals":0,"length":0,"name":"BEST"},"formattedLength":0,"informat":{"decimals":0,"length":0,"name":null},"label":"location_longitude","name":"location_longitude","rawLength":8,"type":"Numeric","version":2},"outputPort":"outTables","outputPortIndex":0,"referenceType":"columnDefinition"}],"outputTable":{"arguments":{},"portIndex":0,"portName":"outTables","referenceType":"outputPort"},"range":{"end":"0","start":"0"},"sheetIndex":0,"tableRef":"_flw_efi_438a2b9722214324abaff63"}]},"fileType":"Excel","fixedWidthFileImportOptions":{},"importOption":{},"inFile":{"portIndex":0,"portName":"inFile","referenceType":"inputPort"},"renameColumns":true}},"id-1702917614025-1791":{"nodeType":"step","version":1,"id":"id-1702917614025-1791","name":"GeoDist with Rounding","note":{"version":1,"id":"id-1702917614025-1795","name":null,"description":null,"properties":{"UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_IS_STICKYNOTE":"false","UI_NOTE_PROP_WIDTH":"0"}},"priority":2,"properties":{"UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"8c4a85e4-6cf9-45fd-ba71-c4eccd1c4c32","UI_PROP_NODE_DATA_MODIFIED_DATE":"1702917243968","UI_PROP_OUTPUT_PORT|outTable|0":"3873d9ec-07c3-4255-a5b5-1cdf2b2b22d5|outTable|","UI_PROP_PORT_DESCRIPTION|inTable|0":"","UI_PROP_PORT_ID|inTable|0":"749d8f5b-7e8b-46ff-a793-d87ddf353c72","UI_PROP_PORT_LABEL|inTable|0":"inTable","UI_PROP_XPOS":"300","UI_PROP_YPOS":"46"},"stepReference":{"type":"uri","path":"/dataFlows/steps/8c4a85e4-6cf9-45fd-ba71-c4eccd1c4c32"},"arguments":{"decimalPlaces":2,"disType":{"value":"Miles"},"inTable":{"portIndex":0,"portName":"inTable","referenceType":"inputPort"},"loc1":[{"columnName":"country_latitude","inputPort":"inTable","inputPortIndex":0,"port":"inTable","portIndex":0,"referenceType":"column","version":1},{"columnName":"country_longitude","inputPort":"inTable","inputPortIndex":0,"port":"inTable","portIndex":0,"referenceType":"column","version":1}],"loc2":[{"columnName":"location_latitude","inputPort":"inTable","inputPortIndex":0,"port":"inTable","portIndex":0,"referenceType":"column","version":1},{"columnName":"location_longitude","inputPort":"inTable","inputPortIndex":0,"port":"inTable","portIndex":0,"referenceType":"column","version":1}],"newColumn":{"columnDefinition":{"attributes":{"format":"BEST.","informat":""},"format":{"decimals":0,"length":12,"name":"BEST"},"formattedLength":0,"label":"distance between locations","links":[],"name":"distance","rawLength":8,"type":"Numeric","version":2},"outputPort":"outTable","outputPortIndex":0,"referenceType":"columnDefinition"},"outTable":{"arguments":{},"portIndex":0,"portName":"outTable","referenceType":"outputPort"},"round":false}}},"parameters":{"id-1702917532480-1458":{"parameterType":"file","version":1,"id":"id-1702917532480-1458","name":"inputFile","parameterUsage":"INPUT","defaultValue":{"arguments":{"dataType":"XLSX","delimiter":null,"encoding":"UTF-8","hasColumnHeaders":true},"value":"/Users/Alex/My Folder/Workshop/data/Location_Data.xlsx","sourceType":"filesServicePath","fileType":"EXCEL_XLSX"}}},"connections":[{"sourcePort":{"node":"id-1702917532480-1458","portName":"outFile","index":0},"targetPort":{"node":"id-1702917583961-1611","portName":"inFile","index":0}},{"sourcePort":{"node":"id-1702917583961-1611","portName":"outTables","index":0},"targetPort":{"node":"id-1702917614025-1791","portName":"inTable","index":0}}],"extendedProperties":{},"stickyNotes":[]}