Hi,   Identify the subjects with skipped dose   ID         Date            Dose     001     01Jan2014      10       001     02jan2014       10       001     03jan2014       10       001     05jan2014       10       002     01jan2014       20       002     02jan2014       20       002     03jan2014       20       002     04jan2014       20       003     02jan2014       10       003     03jan2014       10       003     04jan2014       10       003     06jan2014       10         help me in solving this problem. ... View more

Hi,   The below  data contains a flag variable whose values are depends on score , if the score value is less than the above score value then flag =0 otherwise if score greater  than above score then flag=1. Write a code to get output as above.   Obs        subject                 score     flag         YEAR 1              A                             23           0              92 2              A                             40           1              93 3              A                             26           0              94 4              B                             35           1              94 5              B                             46           1              95 6              B                             45           0              96 7              C                             50           1              94 8              C                             42           0              95 9              C                            37           0              95 I have done upto  the follwing am unable to  get  A     23   0 on the top,pls help me . data test1; set test(firstobs=2); run; data test2; set test(rename=(sub=_sub score=_score)firstobs=1 obs=8); run; data test3; merge test1 test2; if score le _score then flag=0; else flag=1; drop _sub _score; run;           ... View more

Hi, Am trying to shift my domain to sas,Am trying to crack the interview below are few interview questions , pls help me out with answers along with explanation if required,Any suggestions for how to prepare and on which topic will be of greate help for me. Notes: are they acccepted ISO 8601 format and its assumptions Have u handled partial dates Where do u find information about screen failures types of qualifiers with examples how do u handle missing functions note in log(by missing) Sum operators when would you use a modifier Why would you need a SAS date constant? How can you clean invalid data? What symbol is required in an assignment statement? Why would you use IF-THEN/ELSE statements instead of IF-THEN statements? What procedures can be used to detect invalid data? What is an instruction that SAS uses to read data values into a variable? When would you use a : modifier? What statement is used to point to a physical filename including the path, filename, and extension of an Excel workbook ? What character appears at the end of an Excel worksheet name in the SAS Explorer? What is an example of a SAS name literal? What is the name of the permanent SAS data library that SAS creates for you?         Thanks ... View more

Hii I have following input   Input dataset :     id      max   score    101     20        45      101     32        65        101     28        50    output :     id      max   score  change    101     20        45          5    101     28        50         15    101     32        65          .   pls  help me  out ... View more

How can I access only one value of a column in array or suppose X  Y 2   1 2   5 3   6  I need output as X Y  Z 2  1  2 2  5 10 3  6  12 Multiplying value 1 of x with all values of y  How it is done using array   ... View more