BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

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

10 REPLIES 10
SAMARTH
Fluorite | Level 6
I want to get values for BASE in ADLB
Kurt_Bremser
Super User

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
Fluorite | Level 6
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
Opal | Level 21

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

PG
Reeza
Super User

@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
SAS Super FREQ

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.

SAMARTH
Fluorite | Level 6
Thanks for your reply
KevinViel
Pyrite | Level 9

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

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