Flag a column where single record exists in a group

SanjayM — Thu, 18 Nov 2010 11:19:39 GMT

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

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

Cynthia_sas — Thu, 18 Nov 2010 13:01:29 GMT

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

topic Re: Flag a column where single record exists in a group in ODS and Base Reporting

Flag a column where single record exists in a group

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