topic Re: How derive values for BASE in ADLB ? in SAS Health and Life Sciences

How derive values for BASE in ADLB ?

SAMARTH — Sun, 19 Mar 2017 20:46:44 GMT

Re: How derive values for BASE in ADLB ?

Reeza — Sun, 19 Mar 2017 20:50:55 GMT

???

Re: How derive values for BASE in ADLB ?

SAMARTH — Sun, 19 Mar 2017 20:52:32 GMT

I want to get values for BASE in ADLB

Re: How derive values for BASE in ADLB ?

SAMARTH — Sun, 19 Mar 2017 20:57:20 GMT

I gave the following code
If baselineflag ='y' then BASE=AVAL but I'm unable to populate the values...
I want BASE values as
4.9
4.9
4.9
But I'm getting as BASE
4.9
.
.

Re: How derive values for BASE in ADLB ?

Kurt_Bremser — Sun, 19 Mar 2017 21:01:30 GMT

BE.MORE.SPECIFIC.

A one-liner with an acronym that is not widely known is NOT the way to put a question. Actually, it's quite rude and not helpful in getting you a quick and/or good answer.

So:

What is ADLB?

What values "for Base" are you talking about?

Re: How derive values for BASE in ADLB ?

PGStats — Sun, 19 Mar 2017 21:17:37 GMT

This is a SAS Forum. Not a Mind Readers Forum. Please be more explicit.

Re: How derive values for BASE in ADLB ?

Reeza — Sun, 19 Mar 2017 22:52:07 GMT

@SAMARTH wrote:
I gave the following code
If baselineflag ='y' then BASE=AVAL but I'm unable to populate the values...
I want BASE values as
4.9
4.9
4.9
But I'm getting as BASE
4.9
.
.

@SAMARTH Post a sample of your input data, your expected output, the code that isn't 'working' and explain how it's not working.

Re: How derive values for BASE in ADLB ?

Rick_SAS — Sun, 19 Mar 2017 23:35:46 GMT

I assume this is a question about ADaM data sets. You can search the internet for PharmaSUG papers that discuss ADaM and CDSIC issues in SAS. There is also a dedicated Support Community for Pharma-related questions.

Re: How derive values for BASE in ADLB ?

SAMARTH — Sun, 19 Mar 2017 23:37:13 GMT

Thanks for your reply

Re: How derive values for BASE in ADLB ?

Kurt_Bremser — Mon, 20 Mar 2017 06:25:07 GMT

The only explanation for ADLB that google/wikipedia found for me were

Asynchronous Dynamic Load Balancer

Active Directory Load Balancing

Re: How derive values for BASE in ADLB ?

KevinViel — Fri, 28 Apr 2017 12:28:27 GMT

You need to merge or join the original data with its observations that are baseline.

data adlb ;

do usubjid = "1" , "2" ;

do visitnum = 1 to 10 ;

aval = ranuni( 1 ) ;

if visitnum = 1 then ablfl = "Y" ;

else ablfl = " " ;

output ;

end ;

run ;

proc sql ;

create table adlb_base as

select a.*

, case when ablfl = " " then b.aval

else .

end as base

from adlb as a

left join ( select usubjid

, aval

from adlb

where ablfl = "Y"

) as b

on a.usubjid = b.usubjid

order by a.usubjid

, a.visitnum

;

quit ;

HTH,

Kevin