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.
???
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?
This is a SAS Forum. Not a Mind Readers Forum. Please be more explicit.
@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.
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.
The only explanation for ADLB that google/wikipedia found for me were
Active Directory Load Balancing
!
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
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.
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.