How derive values for BASE in ADLB ?

[Reeza]

???

[SAMARTH]

I want to get values for BASE in ADLB

[Kurt_Bremser]

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?

[SAMARTH]

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

[PGStats]

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

[Reeza]

---

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

[Rick_SAS · Accepted solution]

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.

[Kurt_Bremser]

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

Asynchronous Dynamic Load Balancer

Active Directory Load Balancing

!

[SAMARTH]

Thanks for your reply

[KevinViel]

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 ;

  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