Small query

[saitejaguduru97]

Hi All,

I have a data be like

Data Da1;
input Id Drug$ Dose;
datalines;
101 Da 200
101 Da 200
101 Da 200
102 Da 200
102 Da 200
102 Da 200
103 Da 200
103 Da 200
;run;

I am expecting the output be like:

Id        F1
------------
101     Y
102     N
103     Y

Please help me out in the program to get an output.

Thank you

[PaigeMiller]

Please explain how the column named F1 in the output is computed from the data you show.

[saitejaguduru97]

We have to create F1 row.

[PaigeMiller]

---

@saitejaguduru97 wrote:
We have to create F1 row.

---

I asked you to explain how the column F1 is calculated. You have not explained this.

[saitejaguduru97]

Expecting output be like:
Id Drug Dose F1
101 Da 200 Y
102 Da 200 N
103 Da 200 Y..

I need the program code F1 is the variable name or else you can take any name.

[PaigeMiller]

I am going to put emphasis on the key words in my question, since you don't seem to be grasping the question. The emphasized words are in capital letters.

HOW IS F1 CALCULATED?

[saitejaguduru97]

I think with the use of First.id and last.id

[PaigeMiller]

Tell us in words how you compute F1, do not use SAS code, just words.

[Patrick]

The sample data you provide is identical for Drug and Dose in all rows. 

What could possibly be the logic one would need to implement to derive a column F1 from this data that gets N for id 102 but Y for the other two id's.

Please explain the logic to be used. ...and likely provide better sample data that matches the desired result once logic applied.

[saitejaguduru97]

See for example:-
Here 3 patients are there they came to the visits and now I need 101 and 103 patients first visit only for first visit the value should be Y and For 102 subject I want only last visit and for that value should be N

[PaigeMiller]

Why is 101 and 103 a Y and 102 a N? What is the logic? what is the reason? How would we know which is Y and which is N?