The SAS Output Delivery System and reporting techniques

Flag a column where single record exists in a group

Reply
Frequent Contributor
Posts: 97

Flag a column where single record exists in a group

I have a dataset with columns code amount single_record_flag

There can be multiple amounts for the same code.

I want to set the value of single_record_flag column to 1 where only one record exists in a group

Please help
SAS Super FREQ
Posts: 8,742

Re: Flag a column where single record exists in a group

Hi,
It is not clear what kind of output you want?? A report?? A dataset?? What kind of data is this?

You say the dataset has the following variables or columns:
CODE AMOUNT SINGLE_RECORD_FLAG

Then you say you want to set the value of SINGLE_RECORD_FLAG -- what is the current value of that variable? How did it get into the dataset in the first place?? If all you want to do is create or change a variable value that sounds like a job for FIRST.byvar, or LAST.byvar processing or if you want a report for PROC FREQ or PROC MEANS.

What have you tried??

Cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation