Class_Export.flw

{"creationTimeStamp":null,"modifiedTimeStamp":null,"createdBy":null,"modifiedBy":null,"version":2,"sourceVersion":1,"id":null,"name":"Class_Export.flw","description":null,"properties":{"UI_PROP_DF_OPTIMIZE":"false","UI_PROP_DF_ID":"5a81fd86-90fa-407c-8165-73f1f3ae8555","UI_PROP_DF_EXECUTION_ORDERED":"false"},"links":[],"nodes":{"id-1712779482195-1316":{"nodeType":"step","version":1,"id":"id-1712779482195-1316","name":"Remove Duplicates","note":{"version":1,"id":"id-1712779482196-1320","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":"-190","UI_PROP_YPOS":"-71","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"d4a8b30d-103c-4a2f-8a3f-05eb78babc39","UI_PROP_NODE_DATA_MODIFIED_DATE":"1724443859109","UI_PROP_PORT_ID|_dm_inTable|0":"ad20ad1f-8d3c-4b2c-b80b-35a3f722ba13","UI_PROP_PORT_LABEL|_dm_inTable|0":"Input Table","UI_PROP_PORT_DESCRIPTION|_dm_inTable|0":null,"UI_PROP_PORT_ID|_dm_outTable|0":"32cb0cb1-47d5-4e42-b553-73f091d46e46","UI_PROP_PORT_LABEL|_dm_outTable|0":"Output Table","UI_PROP_PORT_DESCRIPTION|_dm_outTable|0":null},"portMappings":[{"mappingType":"tableStructure","portName":"_dm_outTable","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepReference":{"type":"uri","path":"/dataFlows/steps/d4a8b30d-103c-4a2f-8a3f-05eb78babc39"},"arguments":{"_dm_removeAll":true,"_dm_groupBy":[{"referenceType":"column","version":1,"port":"_dm_inTable","portIndex":0,"columnName":"Name","inputPort":"_dm_inTable","inputPortIndex":0}],"_dm_Replace":true,"_dm_saveToCAS":true,"_dm_saveToDisk":true,"_dm_saveType":"","_dm_debugMacro":false,"_dm_inTable":{"referenceType":"inputPort","portName":"_dm_inTable","portIndex":0},"_dm_outTable":{"referenceType":"outputPort","portName":"_dm_outTable","portIndex":0,"arguments":{}}}},"id-1689792477126-806":{"nodeType":"step","version":1,"id":"id-1689792477126-806","name":"Export","note":{"version":1,"id":"id-1689792477129-810","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":"147","UI_PROP_YPOS":"-61","UI_PROP_COLORGRP":"0","UI_PROP_IS_INPUT_EXPANDED":"false","UI_PROP_IS_OUTPUT_EXPANDED":"false","UI_PROP_NODE_DATA_ID":"da1549ad-a598-4600-9459-97a9f26d07fc","UI_PROP_NODE_DATA_MODIFIED_DATE":"1724443167340","UI_PROP_PORT_ID|outFile|0":"f67efb28-3b0d-4d4e-a321-52903de8a065","UI_PROP_PORT_LABEL|outFile|0":"Output file","UI_PROP_PORT_DESCRIPTION|outFile|0":"Output file to export","UI_PROP_PORT_ID|inTable|0":"91051ae1-4d80-4c20-b8ea-0685f415cef7","UI_PROP_PORT_LABEL|inTable|0":"Input table","UI_PROP_PORT_DESCRIPTION|inTable|0":"Input table to export"},"portMappings":[{"mappingType":"tableStructure","portName":"outFile","portIndex":0,"tableStructure":{"columnDefinitions":[]}}],"stepReference":{"type":"uri","path":"/dataFlows/steps/da1549ad-a598-4600-9459-97a9f26d07fc"},"arguments":{"exportOption":{},"createColumnMetadataFile":false,"inTable":{"referenceType":"inputPort","portName":"inTable","portIndex":0},"outFile":{"referenceType":"outputPort","portName":"outFile","portIndex":0,"arguments":{}},"replaceFile":true}},"id-1689792466619-702":{"nodeType":"table","version":1,"id":"id-1689792466619-702","name":"CLASS","note":{"version":1,"id":"id-1689792466621-706","name":null,"description":null,"properties":{"UI_NOTE_PROP_IS_EXPANDED":"false","UI_NOTE_PROP_HEIGHT":"0","UI_NOTE_PROP_WIDTH":"0","UI_NOTE_PROP_IS_STICKYNOTE":"false"}},"priority":2,"properties":{"UI_PROP_TABLE_URI":"SASData://SASHELP?CLASS","UI_PROP_XPOS":"-497","UI_PROP_YPOS":"-54","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":"09499a2e-9e62-4c70-aced-858e47437093","UI_PROP_PORT_LABEL|outTable|0":null,"UI_PROP_PORT_DESCRIPTION|outTable|0":null},"tableReference":{"referenceType":"parameter","parameterId":"id-1689792466619-702"}},"id-1689792489502-994":{"nodeType":"outputFile","version":1,"id":"id-1689792489502-994","name":"class_export","note":{"version":1,"id":"id-1689792489504-998","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":"354","UI_PROP_YPOS":"50","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|inFile|0":"e3ee5ece-1cc6-4617-83a4-eb925a727723","UI_PROP_PORT_LABEL|inFile|0":null,"UI_PROP_PORT_DESCRIPTION|inFile|0":null},"fileReference":{"referenceType":"parameter","parameterId":"id-1689792489502-994"}}},"parameters":{"id-1689792466619-702":{"parameterType":"tableStructure","version":2,"id":"id-1689792466619-702","name":"CLASS","parameterUsage":"INPUT","defaultValue":{"table":{"name":"CLASS","providerId":"Compute","dataSourceId":"Compute~fs~1b4db437-cc12-4df2-a0c4-11e383f985d8~fs~SASHELP","type":"dataTable","label":"Student Data","creationTimeStamp":"2023-10-10T18:06:14.092Z","modifiedTimeStamp":"2023-10-10T18:06:14.092Z","attributes":{"bookmarkLength":12,"columnCount":5,"compressionRoutine":"NO","dataTableType":"table","encoding":"us-ascii  ASCII (ANSI)","engine":"V9","logicalRecordCount":19,"physicalRecordCount":19,"recordLength":40,"rowCount":19,"version":2},"version":2,"links":[]},"source":{"id":"SASHELP","name":"SASHELP","providerId":"Compute","parentId":"1b4db437-cc12-4df2-a0c4-11e383f985d8","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":"Name","index":0,"type":"CHAR","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Sex","index":1,"type":"CHAR","rawLength":1,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Age","index":2,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Height","index":3,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}},{"name":"Weight","index":4,"type":"Numeric","rawLength":8,"formattedLength":0,"version":2,"links":[],"attributes":{}}]},"id-1689792489502-994":{"parameterType":"file","version":1,"id":"id-1689792489502-994","name":"outputFile","parameterUsage":"OUTPUT","defaultValue":{"arguments":{"dataType":"DLM","delimiter":",","encoding":"UTF-8","hasColumnHeaders":true},"fileType":"TEXT","sourceType":"localFile","value":"Home/class_export.txt"}}},"connections":[{"sourcePort":{"node":"id-1689792477126-806","portName":"outFile","index":0},"targetPort":{"node":"id-1689792489502-994","portName":"inFile","index":0}},{"sourcePort":{"node":"id-1689792466619-702","portName":"outTable","index":0},"targetPort":{"node":"id-1712779482195-1316","portName":"_dm_inTable","index":0}},{"sourcePort":{"node":"id-1712779482195-1316","portName":"_dm_outTable","index":0},"targetPort":{"node":"id-1689792477126-806","portName":"inTable","index":0}}],"extendedProperties":{},"stickyNotes":[]}