|
Using a delimiter is a common form for converting tables between database management systems or spreadsheet programs; it separates the columns or fields within each record. Any character or sequence of characters that does not appear in the data can be used as the delimiter.
|
data _null_;
set myfile.data;
file report noprint notitle;
put @1 claimnum (memberid- -provnum)(+(-1)'"')
;
run;
data _null_;
set myfile.data;
file report noprint notitle;
put @1 '"' claimnum (memberid- -provnum)(+(-1)'"' ',' '"')
;
run;
|
|
The benefit of delimited-field files is that they can be more compact as compared to fixed-field files, because they take advantage of variations in the lengths of values.
The two hypens inside the parentheses are meant to pull out all the variables that are in between the starting and ending variables. Also, the purpose of a variable outside the ( ) is to keep SAS from putting a leading delimiter character.
|
|
