Hi,       I'm using SAS eg 4.2.....i'm running one query on oracle database.....database is connected to sas server.       To run my query everytime i have to assign library manually by clicking on that library and assign.       can i do this through libname facility.       I saw syntax like this              LIBNAME CLOAD_RT oracle '\Shared Data\Oracle\CLOAD_RT'       if i put path name like above is it works?......how can i get pathname for SASApp server? Thanks, rk ... View more

Hi,     I have two datasets dataset a and dataset b.     ex:dataset a     id        value     123      xyz      456     wxy   112345   abc dataset b id     product 123   def 456   tss 789   klm i want to map product for each id in dataset a from dataset b final dataset should look like this: id             value    product 123           xyz      def 456           wxy      tss 112345      abc I'm using left outer join on id....but not getting desired results. how can i do this. Thanks, rk. ... View more

Hi,   I have to create new coloums in dataset output (achieved rate and record volume) based on speciality pharmacy,   product and period in input dataset.   ex:we have dataset called input(input.csv)      from that we have to create 4 coloums in the dataset output.    if distinct Milestone_period for each product and pharmacy we have to create 5 new rows in    output dataset      Approval Rate     Days to Approval     Fulfillment Rate     Days to Ship     Compliance     for calculating achieved rate for each row these are the formulas:    Days to Approval Sum of Days Achieved on records where Metric Field = AR                     =  ...................................................................                         Count # of records where Metric Field = AR Approval Rate (%) Count # of records where Metric Field = AR                      = .........................................................................................................                         Count # of records where Milestone Date = Referral Days to Fulfillment Sum of Days Achieved on records where Metric Field = FR                       =....................................................................................................                         Count # of records where Metric Field = FR Fulfillment Rate (%) Count # of records where Metric Field = FR                       =........................................................                         Count # of records where Milestone Date = Approval Compliance  Sum of Days of Therapy on records where Metric Field = COMP                =...........................................................                  Sum of Days Achieved on records where Metric Field = COMP Record count we based on speciality pharmacy,product,and period.I'm able to do it till Milestone period..after that i got struct with these calculations... somebody pls guide me how to proceed with this one. Thanks, sasg. ... View more