Look-Ahead and Look-Back

[Ragineejoshi]

Hi all,

I have problem to be solved.

In sdtm.sv

where usubjid = "UNI301" and visitnum= 2,

which raw dataset or datasets is contributing that date information?

How do I solve this question?

Please help...

[Ragineejoshi]

Hi all,

I have problem to be solved.

In sdtm.sv

where usubjid = "UNI301" and visitnum= 2,

which raw dataset or datasets is contributing that date information?

How do I solve this question?

Please help...

[Reeza]

These appear to be the same question, so I've merged them into one. Unfortunately I don't think we have enough information to help you out. That code looks like a filter to subset a data set.

[Ragineejoshi]

Thank you for your help..

[ballardw]

---

@Ragineejoshi wrote:

Hi all,

I have problem to be solved.

In sdtm.sv

where usubjid = "UNI301" and visitnum= 2,

which raw dataset or datasets is contributing that date information?

How do I solve this question?

Please help...

---

You have apparently shown us one section of code:

where usubjid = "UNI301" and visitnum= 2,

if this is part of a PROC SQL or other procedure call please post the entire code for that procedure.

Since neither of the variables you indicate loot like they have anything to do with dates then another variable or possibly a function call to the TODAY() function or use of macro variable such as &sysdate might be providing date information.

You may need to post the results of running Proc Contents on your SDTM.SV data set, assuming that is the name of the data set that is used.

[Ragineejoshi]

@ballardw 

Hi Friend,

I am a student and this is the practice question asked by my teacher as a practice quary.

Here he is asking for searching back in all the SDTM domains to look for the observation which is related to usubjid = "UNI301" and visitnum= 2 and we have to check which date is associated with that observation...

Now if you can help me it will be really nice... Otherwise I will have to ask my teacher only..

Thanks for your help..

Raginee

[Reeza · Accepted solution]

You need to fiiter the data set and then find the date in that record.

https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true...

[Ragineejoshi]

Thank you so much for the help.. I will try that for sure..