topic Re: Small query in SAS Programming

Small query

saitejaguduru97 — Wed, 28 Dec 2022 14:27:42 GMT

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

Re: Small query

PaigeMiller — Wed, 28 Dec 2022 14:34:57 GMT

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

Re: Small query

saitejaguduru97 — Wed, 28 Dec 2022 14:38:30 GMT

We have to create F1 row.

Re: Small query

PaigeMiller — Wed, 28 Dec 2022 15:01:14 GMT

@saitejaguduru97 wrote:
We have to create F1 row.

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

Re: Small query

saitejaguduru97 — Wed, 28 Dec 2022 15:05:10 GMT

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.

Re: Small query

Patrick — Wed, 28 Dec 2022 15:19:29 GMT

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.

Re: Small query

PaigeMiller — Wed, 28 Dec 2022 15:20:55 GMT

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?

Re: Small query

saitejaguduru97 — Wed, 28 Dec 2022 15:31:39 GMT

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

Re: Small query

PaigeMiller — Wed, 28 Dec 2022 15:33:09 GMT

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

Re: Small query

saitejaguduru97 — Wed, 28 Dec 2022 15:37:50 GMT

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

Re: Small query

PaigeMiller — Wed, 28 Dec 2022 15:54:09 GMT

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?