How derive values for BASE in ADLB ?

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How derive values for BASE in ADLB ?

 

Accepted Solutions
Solution
‎03-19-2017 07:36 PM
SAS Super FREQ
Posts: 3,415

Re: How derive values for BASE in ADLB ?

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.

View solution in original post


All Replies
Grand Advisor
Posts: 17,389

Re: How derive values for BASE in ADLB ?

???

New Contributor
Posts: 4

Re: How derive values for BASE in ADLB ?

I want to get values for BASE in ADLB
Esteemed Advisor
Posts: 6,685

Re: How derive values for BASE in ADLB ?

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?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: How derive values for BASE in ADLB ?

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
.
.
Respected Advisor
Posts: 4,608

Re: How derive values for BASE in ADLB ?

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

PG
Grand Advisor
Posts: 17,389

Re: How derive values for BASE in ADLB ?


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. 

Solution
‎03-19-2017 07:36 PM
SAS Super FREQ
Posts: 3,415

Re: How derive values for BASE in ADLB ?

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.

Esteemed Advisor
Posts: 6,685

Re: How derive values for BASE in ADLB ?

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

Asynchronous Dynamic Load Balancer

Active Directory Load Balancing

!

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: How derive values for BASE in ADLB ?

Thanks for your reply
Frequent Contributor
Posts: 79

Re: How derive values for BASE in ADLB ?

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 10 replies
  • 344 views
  • 4 likes
  • 6 in conversation