topic How to add a flag on multiple records? in SAS Programming

How to add a flag on multiple records?

SASInd — Wed, 08 Aug 2018 07:41:11 GMT

Hi, I have 1000 records in my file and i need to print a flag or variable or word 'Ind' (basically an indicator for me) on 100th position in every record.How i can achieve this?

Thank you in advance!

Re: How to add a flag on multiple records?

RW9 — Wed, 08 Aug 2018 08:05:41 GMT

Post test data in the form of a datastep, we cannot see your computer!

data want;
  set have;
  if mod(_n_,100)=0 then flag=1;
run;

Not tested.

Re: How to add a flag on multiple records?

SASInd — Wed, 08 Aug 2018 09:04:54 GMT

Let me clear it out... I have an existing file like below

column--> Name Age Gender
rows-->. Nesco 43 M
Greg 36 M

I want to add an extra column named indicator so that my file should look like below
(Desired dataset)

Nesco 43 M IND
Greg 36 M IND

I want IND on fixed position for all the records.

I hope now you are aware of my requirements

Re: How to add a flag on multiple records?

RW9 — Wed, 08 Aug 2018 09:09:18 GMT

Please review the how to post a question guide below the Post button. Provide test data in the form of a datastep and show what the output should look like.

Hence the response remains the same:

data want;
  set have;
  if mod(_n_,100)=0 then indicator="IND";
run;

Re: How to add a flag on multiple records?

SASInd — Wed, 08 Aug 2018 09:16:33 GMT

Existing dataset:
Nesco 43 M
Greg 36 M

Desired: (to add IND for all records in last column)

Nesco 43 M IND
Greg 36 M IND

Re: How to add a flag on multiple records?

RW9 — Wed, 08 Aug 2018 09:25:52 GMT

I will try once more. Please provide test data in the form of a datastep which accurately shows your problem. What you have posted neither shows the data in a form that we can run, nor does it illustrate what to do or match the thread title. Let me take my time to type some test data in for you and show you how to do it:

Here is some test data which we can run and have something to work with:

data have;
  input name $ age sex $;
datalines;
Nesco 43 M
Greg 36 M
Nesco 43 M
Greg 36 M
Nesco 43 M
Greg 36 M
Nesco 43 M
Greg 36 M
Nesco 43 M
Greg 36 M
;
run;

Your thread title was how to flag X number of rows each time, to which I presented the code:

data want;
  set have;
  if mod(_n_,3)=0 then indicator="IND";
run;

If you put these two together you will fin that every 3rd row is flagged. If this is not what you want, please describe thoroughly, providing test data in the form of a datastep and showing what you want out at the end.

Re: How to add a flag on multiple records?

gamotte — Wed, 08 Aug 2018 09:57:00 GMT

Hello,

I will take a wild guess and assume that you want to create a new column at a predefined position in the dataset.

Here is a program that adds a column in sashelp.class in third position :

%let pos=3;

proc sql;
	SELECT name
	INTO :before_pos separated by ','
	FROM dictionary.columns
	WHERE libname="SASHELP" AND memname="CLASS" AND varnum<&pos.;

	SELECT name
	INTO :after_pos separated by ','
	FROM dictionary.columns
	WHERE libname="SASHELP" AND memname="CLASS" AND varnum>=&pos.;

	CREATE TABLE WANT AS
	SELECT &before_pos., "IND" AS newvar, &after_pos.
	FROM sashelp.class;
quit;

Re: How to add a flag on multiple records?

SASInd — Fri, 10 Aug 2018 10:03:10 GMT

Achieved this by using FORMAT statement, able to print 'IND' on all records.