topic Re: Keep record but suppress field in SAS Programming

Keep record but suppress field

Q1983 — Mon, 17 Feb 2020 14:32:54 GMT

data have;

length ctr Status $25.;

input ctr cnt cnt2 Status;

return;

datalines;

4544 2 1 Paid

4544 3 1 Paid /*suppress the name paid but keep record*/

4544 4 1 Paid

4544 5 1 Paid

4465 10 1

4465 5 1

4475 1 0

4475 2 0 Paid

4475 3 1 Paid /*suppress the name paid but keep record*/

4476 5 2

4476 6 1 Paid

;

run;

Is there a way to keep all record however suppress the name "Paid" after it shows the first time? So in a series per ctr, if the status is "Paid", I want to see it displayed on the first instance only but keep all record.

Re: Keep record but suppress field

tomrvincent — Mon, 17 Feb 2020 14:49:31 GMT

See it displayed in what?

What have you tried so far?

Re: Keep record but suppress field

andreas_lds — Mon, 17 Feb 2020 16:58:10 GMT

Use SET and BY CTR, maybe add NOTSORTED if the data is grouped by CTR, but not sorted. The use
if not first.ctr then Status = " ";

Re: Keep record but suppress field

ChrisNZ — Mon, 17 Feb 2020 21:06:11 GMT

Like this?

by CTR;
if first.CTR then PAID_FOUND=0;
if STATUS='Paid' then 
  if PAID_FOUND then STATUS=' '; else PAID_FOUND+1;