You can also Sort data in a PivotTable or Filter data in a PivotTable. The PivotTable will work with your entire data set to summarize your data. Once loaded, Use the Field List to arrange fields in a PivotTable. In the preview dialog box, select Load To. * putlog just here to see in sample code what gets written to file "want" */Īnd in case your source text file doesn't have a delimiter and data is just written out positional with blanks then the following code version could deal with that. Go to the Data tab > From Text/CSV > find the file and select Import. * read source file "want" into input buffer and replace the source file delimiter (tab?) with comma */ * create source text file with delimiter '|' (tab or whatever in your real data) */įilesystem|GB blocks|Free|%Used|Iused|%Iused|Mounted on
There is no need to map the data to SAS variables and input source strings into SAS numeric variables. So in your case you could simply read the source text file into the input buffer, exchange the source delimiter with a comma and then write the result straight back to the output file.
0 kommentar(er)
