topic Re: Look-Ahead and Look-Back in New SAS User

Look-Ahead and Look-Back

Ragineejoshi — Fri, 12 Apr 2019 21:00:17 GMT

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...

Tracing back to raw data

Ragineejoshi — Fri, 12 Apr 2019 21:01:34 GMT

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...

Re: Look-Ahead and Look-Back

Reeza — Fri, 12 Apr 2019 21:51:08 GMT

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.

Re: Look-Ahead and Look-Back

ballardw — Fri, 12 Apr 2019 22:32:37 GMT

@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.

Re: Look-Ahead and Look-Back

Ragineejoshi — Mon, 15 Apr 2019 21:41:45 GMT

Thank you for your help..

Re: Look-Ahead and Look-Back

Ragineejoshi — Mon, 15 Apr 2019 21:47:50 GMT

@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

Re: Look-Ahead and Look-Back

Reeza — Mon, 15 Apr 2019 21:55:27 GMT

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&q=filter

Re: Look-Ahead and Look-Back

Ragineejoshi — Mon, 15 Apr 2019 22:38:49 GMT

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