Hi, I'm reading in a file using the code below. I'm new as using the scan function and would like to know how to output to the record after each iteration of through the code. Thank you data testdata2;
infile mysource lrecl = 6807 truncover scanover;
input
@'"UserEmail"|"metadata_value":"' user_email $100.
@'"ProductVersion"|"metadata_value":"' prod_version $20.
@'"SourceEvent"|"metadata_value":"' source_event $30.
@'"ProcessTotalWaitTime"|"metadata_value":"' PT_WaitTime $10.
;
user_email = scan(user_email,1,'"');
prod_version = scan(prod_version,1,'"');
source_event = scan(source_event,1,'"');
PT_WaitTime = scan(PT_WaitTime,1,'"');
run;
... View more