Hi,   Pls explain me the second point,   Duplicate BY Values Duplicates in the master and transaction data sets affect processing. If duplicates exist in the master data set, only the first occurrence is updated because the generated WHERE statement always finds the first occurrence in the master. If duplicates exist in the transaction data set, the duplicates are applied one on top of another unless you write an accumulation statement to add all of them to the master observation. Without the accumulation statement, the values in the duplicates overwrite each other so that only the value in the last transaction is the result in the master observation   Thanks ... View more

Hello All,      Am shifting my domain to SAS,I have coding knowledge on SAS,I have a interview on banking sas,pls suggest me or guide on which topics I need to focus.       Thanks in advance. ... View more

Hii ,I have two datasets,I need to compare those two datasets and get the variables list that are common, not common  and get that in a pdf format, for example I have a dataset1 with the follwing varaibles: id name manager dataset2 with the following variables: id manager managerid I need the output as  commonvaraibles      notcommonvariables    id                                  managerid    manager                       name I dont have much knowledge on ODS,Pls helpme regarding this.   ... View more

Hii I am trying to use proc report  for displaying report,am a beginner to use proc  report,pls  help ,e regarding the error which I got..   options nodate pageno=1 ps=60 ls=72; proc report data=final_test nowd; title "Summary of Adverse Events Related to Investigational Product"; columns systemorganclasspreferredterm active placebo; define systemorganclasspreferredterm / display ; define active / display ; define placebo / display ; run;     error:   ERROR: The width of active is not between 1 and 72. Adjust the column width or line size. NOTE: This affects LISTING output. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 22 observations read from the data set WORK.FINAL_TEST. NOTE: PROCEDURE REPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Hi, How can we sort a data set with out using proc sort ..   for example:   id   name 2     aaa 1     bbb 5     ccc 4     ddd 3     eee   output:   1   bbb 2   aaa 3   eee 4   ddd 5    ccc     ... View more