topic Variable due to some of the rows in SAS Programming

Variable due to some of the rows

SAS-programmer — Fri, 28 Oct 2022 15:04:55 GMT

Hi! I create a dataset with a variable ID from 1 to 22. I want to give a new variable called "twins" the value 1 for just object 20 (all other objekts I do want to have the value 0 for that new variable) if both objects with ID 21 and 22 is on the file othervise 0. How do I do that?

Re: Variable due to some of the rows

PaigeMiller — Fri, 28 Oct 2022 15:26:41 GMT

I'm not understanding. I thought I understood this part: "I create a dataset with a variable ID from 1 to 22. I want to give a new variable called "twins" the value 1 for just object 20 (all other objekts I do want to have the value 0 for that new variable)" but then this part confused me totally: "...if both objects with ID 21 and 22 is on the file othervise 0."

Please show us the original data set, and the desired result.

Re: Variable due to some of the rows

SAS-programmer — Fri, 28 Oct 2022 15:53:52 GMT

Hi!
I randomly create this type of file by chosing 5 objects of 22.
[cid:image001.png@01D8EAF6.31F98480]
I want to add a new row with ID=20 and in the case I recieve both number 21 and 22 I want to give a new variable the value 1 for ID=20 otherwise 0.

Re: Variable due to some of the rows

PaigeMiller — Fri, 28 Oct 2022 16:10:03 GMT

I still don't understand.

Please show us the input data set and the desired output.

Re: Variable due to some of the rows

Kurt_Bremser — Fri, 28 Oct 2022 16:15:16 GMT

And do NOT post data in pictures. Post data as text, ideally as a DATA step with DATALINES which recreates your dataset successfully when submitted.

Re: Variable due to some of the rows

Reeza — Fri, 28 Oct 2022 16:51:52 GMT

I think you're mixing up two variables which is what is making this confusing.

Here's my interpretation of your problem:

*data of random objects you do have;
data have;
do object=1 to 25;
output;
end;
run;

*randomly select 22;
proc surveyselect data=have out=selected  method=srs sampsize=22 seed=245;
run;

*add in an id for each row;
data selected;
set selected;
id=_n_;
run;

*check if you have the 21 and 22 observations;
%let countobs=0;

proc sql;
create table temp as
select *
from selected where object in (21, 22);
quit;

%let countobs=&sqlobs;

*if observations are present add the flag;
data want;
set selected;
twins=0;
if id=20 and &countobs=2 then twins=1;
run;

If this is incorrect, please show sample input data and expected output, similar to what I have posted above.

Re: Variable due to some of the rows

SAS-programmer — Sat, 29 Oct 2022 10:54:52 GMT

My dataset Population looks like this:
[cid:image003.png@01D8EB95.9119C7F0]
And one example of my repeated samples drawn from Population looks like this and the dataset is called Sample:
[cid:image002.png@01D8EB94.BE8CB810]
Now I want in a third dataset Counter count two things. First how many times a certain object is drawn. And also how many times both ID 21 and 22 is both drawn.
In this case I want

Re: Variable due to some of the rows

PaigeMiller — Sat, 29 Oct 2022 11:20:15 GMT

Not only do your pictures not appear, you have ignored what you were told earlier by @Kurt_Bremser : "do NOT post data in pictures. Post data as text, ideally as a DATA step with DATALINES which recreates your dataset successfully when submitted." We'd like to help you, but you have to help us too.