Hi all, I need opinions on how to read number of observation based on different customer. For example, my data as per below Dataset A Customer| customer no | count A | 111 | 3 B | 222 | 2 Dataset B (Main) Customer | customer no | sales A | 111 | 12000 A | 111 | 2000 A | 111 | 10000 A | 111 | 7000 B | 222 | 1000 B | 222 | 5000 B | 222 | 6500 In dataset A, the count indicates how many observation i need to extract from dataset B (Main dataset). So i dont know how to randomly select the no of observation by each customer as shown above. Thanks. ... View more

Hi All,   I have 2 questions from the code below. I am trying to produce output into textfile with pipeline delimeter. The output does not match with my expectation.   My sample code is as per below: 　 data &try; set acc.&try nobs=j end=eod; file "C:\TRY\&out_rpt..txt" lrecl=300 dlm='|'; if _n_ = 1 then put @1 'VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|VAR1|system|VAR1'; put @1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 VAR1 ; if _n_=j then do; put @1 'TOTAL ACCOUNT : | ' j '|'; end; run;   I encounter 1 warning stating that WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.   1)After I already specify LRECL = 300, why does the warning appear?   2) The output from above code shows that, there is extra pipeline after total obs.   Total Account : | 10 ||   Thanks in advance to whoever that willing to help 🙂 ... View more