forked from maquee-sas/SASStudioWorkshop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCalcGeoDist.flw
executable file
·1 lines (1 loc) · 8.65 KB
/
CalcGeoDist.flw
1
{"creationTimeStamp":"2024-04-01T16:29:23.902Z","modifiedTimeStamp":"2024-04-01T16:29:23.902Z","createdBy":"Alex","modifiedBy":"Alex","version":2,"id":null,"name":"CalcGeoDist.flw","description":null,"properties":{"UI_PROP_DF_OPTIMIZE":"false","UI_PROP_DF_ID":"4aac7a7a-982b-4a61-9394-cbf95b503b4c","UI_PROP_DF_EXECUTION_ORDERED":"false"},"links":[{"method":"GET","rel":"self","href":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","type":"application/vnd.sas.data.flow"},{"method":"GET","rel":"alternate","href":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","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/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","type":"application/vnd.sas.data.flow","responseType":"application/vnd.sas.data.flow"},{"method":"DELETE","rel":"delete","href":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b"},{"method":"GET","rel":"transferExport","href":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","responseType":"application/vnd.sas.transfer.object"},{"method":"PUT","rel":"transferImportUpdate","href":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","uri":"/dataFlows/dataFlows/60632bcd-1d95-4a9e-a380-0e9d5aa62f7b","type":"application/vnd.sas.transfer.object","responseType":"application/vnd.sas.summary"}],"nodes":{"id-1711988697666-1450":{"nodeType":"file","version":1,"id":"id-1711988697666-1450","name":"Location_Data","note":{"version":1,"id":"id-1711988697668-1454","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":"GENERIC_FILE_TRANSFORMATION","UI_PROP_PORT_DESCRIPTION|outFile|0":"","UI_PROP_PORT_ID|outFile|0":"5c389d11-6fcf-4e1b-b7dc-05c2f09c5b98","UI_PROP_PORT_LABEL|outFile|0":"","UI_PROP_XPOS":"32","UI_PROP_YPOS":"19"},"fileReference":{"referenceType":"parameter","parameterId":"id-1711988697666-1450"}},"id-1711988706328-1553":{"nodeType":"step","version":1,"id":"id-1711988706328-1553","name":"Import","note":{"version":1,"id":"id-1711988706330-1557","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":"d38ccdec-66bc-43d0-84f0-faf8d5812bad","UI_PROP_NODE_DATA_MODIFIED_DATE":"1711971510196","UI_PROP_PORT_DESCRIPTION|inFile|0":"Input file to import","UI_PROP_PORT_DESCRIPTION|outTables|0":"Output tables","UI_PROP_PORT_ID|inFile|0":"5fc03589-9cda-4038-bf44-e5ada2daa948","UI_PROP_PORT_ID|outTables|0":"28dde994-5046-4d16-9aff-35a62687567b","UI_PROP_PORT_LABEL|inFile|0":"Input file","UI_PROP_PORT_LABEL|outTables|0":"Sheet1","UI_PROP_XPOS":"171","UI_PROP_YPOS":"22"},"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_25dc6ae54a714e18a8ac5d6"}]},"fileType":"Excel","fixedWidthFileImportOptions":{},"importOption":{},"inFile":{"portIndex":0,"portName":"inFile","referenceType":"inputPort"},"renameColumns":true}},"id-1711988779098-2050":{"nodeType":"step","version":1,"id":"id-1711988779098-2050","name":"GeoDist with Rounding","note":{"version":1,"id":"id-1711988779099-2054","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":"880c37d0-31e7-40f4-a214-e8da4a426ff4","UI_PROP_NODE_DATA_MODIFIED_DATE":"1711988315428","UI_PROP_OUTPUT_PORT|outTable|0":"3ce452aa-05ea-47ad-9397-b6d741fbf4cb|outTable|","UI_PROP_PORT_DESCRIPTION|inTable|0":"","UI_PROP_PORT_ID|inTable|0":"2babfb18-6987-4489-9896-3795a747df8b","UI_PROP_PORT_LABEL|inTable|0":"inTable","UI_PROP_XPOS":"356","UI_PROP_YPOS":"8"},"stepReference":{"type":"uri","path":"/dataFlows/steps/880c37d0-31e7-40f4-a214-e8da4a426ff4"},"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":"","informat":""},"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-1711988697666-1450":{"parameterType":"file","version":1,"id":"id-1711988697666-1450","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-1711988697666-1450","portName":"outFile","index":0},"targetPort":{"node":"id-1711988706328-1553","portName":"inFile","index":0}},{"sourcePort":{"node":"id-1711988706328-1553","portName":"outTables","index":0},"targetPort":{"node":"id-1711988779098-2050","portName":"inTable","index":0}}],"extendedProperties":{},"stickyNotes":[]}