data have  101 1-Burning 102 1-Burning2-Itching 103 1-Burning2-Itching3- swelling   I want data  101   Burning 102   Burning 102   Itching 103   Burning 103   Itching 103   swelling   ... View more

data set in raw.have data have; infile datalines dsd truncover; input subjid $ THER NEWTR CHTR SHOS OTHER ; datalines; 101,1,1,1,1,1,., 102,1,1,1,1,. 103,1,1,1,, 104,1.,1,,,,. 105,1,,.,,., 106,1,.,1,.,.,., 107,.,1.,,1,1,.,. 108,.,1.,1,,. 109,.,1,.,1,. 110,.,1,.,.,. 111,1,.,.,.,., 112,.,.,1,1,. 113,.,.,1,. 114,.,.,.,1,. ; run;   I want this output data want ; length subjid $20 acnoth $200; infile datalines dsd truncover; input subjid $ acnoth $; datalines; 101,"NON-DRUG THERAPY, NEW OTC OR RX DRUG ADDED, CHANGE IN CONCOMITANT MEDICATION, HOSPITALIZATION (INCLUDES ER VISITS),OTER" 102,"NON-DRUG THERAPY, NEW OTC OR RX DRUG ADDED, CHANGE IN CONCOMITANT MEDICATION, HOSPITALIZATION (INCLUDES ER VISITS)" 103,"NON-DRUG THERAPY, NEW OTC OR RX DRUG ADDED, CHANGE IN CONCOMITANT MEDICATION" 104,"NON-DRUG THERAPY, NEW OTC OR RX DRUG ADDED" 105,"NON-DRUG THERAPY" 106,"NON-DRUG THERAPY, CHANGE IN CONCOMITANT MEDICATION" 107,"NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS),OTER" 108,"NEW OTC OR RX DRUG ADDED, CHANGE IN CONCOMITANT MEDICATION" 109,"NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS)" 110,"NEW OTC OR RX DRUG ADDED" 111,"NON-DRUG THERAPY" 112,"CHANGE IN CONCOMITANT MEDICATION, HOSPITALIZATION (INCLUDES ER VISITS)" 113,"CHANGE IN CONCOMITANT MEDICATION" 114,"HOSPITALIZATION (INCLUDES ER VISITS)" ; run; I want final output data fin; merge have want ; by subjid ; run; ... View more

data have; infile datalines dsd truncover; input subjid $ visitnum $ armcd $; datalines; 101,1,height 101,1,weight 101,1,bmi 101,1,temp 101,2,temp 101,3,temp 101,4,temp 101,5,temp 101,1,hr 101,2,hr 101,3,hr 101,4,hr 101,5,hr 102,1,height 102,1,weight 102,1,bmi 102,1,temp 102,3,temp 102,4,temp 102,5,temp 103,1,height 103,1,weight 103,1,bmi 103,3,temp 103,4,temp 103,6,temp 104,1,hr 104,3,hr 104,4,hr 104,5,hr 105,1,temp 105,3,temp 105,5,temp 106,1,height 106,1,weight 106,1,bmi 106,1,temp ; run; how to get this data using above data set  data want; infile datalines dsd truncover; input subjid $ visitnum $ armcd $ AVISITN; datalines; 101,1,height,1 101,1,weight,1 101,1,bmi,1 101,1,temp,, 101,2,temp,1 101,3,temp,3 101,4,temp,4 101,5,temp,5 101,1,hr,, 101,2,hr,1 101,3,hr,3 101,4,hr,4 101,5,hr,5 102,1,height,1 102,1,weight,1 102,1,bmi,1 102,1,temp,1 102,3,temp,3 102,4,temp,4 102,5,temp,5 103,1,height,1 103,1,weight,1 103,1,bmi,1 103,3,temp,3 103,4,temp,4 103,6,temp,6 104,1,hr,, 104,3,hr,3 104,4,hr,4 104,5,hr,5 105,1,temp,1 105,3,temp,3 105,5,temp,5 106,1,height,, 106,1,weight,, 106,1,bmi,, 106,1,temp,, ; run; ... View more

Data Have ; sub           no          stdt                           dtc                          epoch                                            101           1          2021-06-22              2021-06-17         SCREENING                                      101           2          2021-06-22              2021-06-22         SCREENING 101           3          2021-06-22             2021-07-06          BLINDED TREATMENT   102           1        2021-07-12               2021-06-14          SCREENING 102           2        2021-07-12               2021-07-26          BLINDED TREATMENT 102           3       2021-07-12                2021-07-26          BLINDED TREATMENT   I want data  sub           no          stdt                           dtc                          epoch                                  flg 101           1          2021-06-22              2021-06-17         SCREENING                             "" 101           2          2021-06-22              2021-06-22         SCREENING                             Y 101           3          2021-06-22             2021-07-06          BLINDED TREATMENT            ""   102           1        2021-07-12               2021-06-14          SCREENING                             Y 102           2        2021-07-12               2021-07-26          BLINDED TREATMENT            "" 102           3       2021-07-12                2021-07-26          BLINDED TREATMENT            ""   ... View more

data set has data : id            var 001     1.6764 002     1.6256 003     1.7399 004     1.6129 005     1.7145   I want data this data how to get    id             var  001           1.68 002           1.63 003           1.74 004           1.61 005           1.71   ... View more

if subject had VISITNUM=4 as early termination (ET) visit and no Visit 3 record then re-assign ET visit to the closest post baseline planned visit and keep the reported data as for analysis as well. If ET visit was close to Visit 3 then assign "Visit 3/End of Treatment" to AVISIT and create LOCF record for Visit 4/Follow-up If Visit 3 was missing and ET visit was close to Visit 2 then assign "Visit 2/Day 3/During Treatment" to AVISIT and create LOCF record for both Visit 3 and Visit 4. ... View more

i hava v_have data set   i want data as v_want data set wise how to do  VISITNUM VISIT AVISIT AVISITN using data set v_have ... View more

have data  data a; input id white$  black$ Native$  American$  Asian $; datalines; 101 1 . . . . 102 1 1 . . . 103 1 1 1 1 . 104 1 . . . . 105 . . . . 1 106 . . 1 1 . 107 . 1 . . . 108 . . 1 . . 109 . . . 1 . run;   i want data this type of data how to do program ?   data aa; length race $20; input id white$  black$ Native$  American$  Asian $ race $; datalines; 101 1 . . . . WHITE 102 1 1 . . . MULTIPUL 103 1 1 1 1 . MULTIPUL 104 1 . . . . WHITE 105 . . . . 1 ASIAN 106 . . 1 1 . MULTIPUL 107 . 1 . . . BLACK 108 . . 1 . . NATIVE 109 . . . 1 . AMERICAN ; run; ... View more

don't want UNSCHEDULED  but some time sufficient res is available in UNSCHEDULED  have been assigned.eg .. look at on want data set    i have data in this type  data have; length id no res visit $200; infile datalines dsd truncover; input id no res visit $; datalines; 003,1,sufficient,visit1 003,1.1,5.6,UNSCHEDULED 1.1 003,2,5.5,visit2 003,3,5.8,visit2 004,1,6.0,visit1 004,1.1,6.5,visit1 004,2,7.0,visit2 004,3,7.2,visit3 004,1,interact,visit1 004,1.1,9.3,UNSCHEDULED 1.1 004,2,8.4,visit2 004,3,7.2,visit3 005,0.1,6.9,UNSCHEDULED 0.1 005,0.1,7.4,UNSCHEDULED 0.1 005,0.1,5.9,UNSCHEDULED 0.1 ; run;     i want as data this type    data want; length id no res visit $200; infile datalines dsd truncover; input id no res visit $; datalines; 003,1.1,5.6,UNSCHEDULED 1.1 003,2,5.5,visit2 003,3,5.8,visit2 004,1,interact,visit1 004,2,7.0,visit2 004,3,7.2,visit3 ; run; ... View more

i have data in this type  data have; length id visitno visitdt visit $200; infile datalines dsd truncover; input id visitno visitdt visit $; datalines; 1006,01,2019-11-06,v1 1006,02,2019-11-08,v2 1006,03,2019-11-22,v3 1006,04,2019-12-19,v4 1006,9.01,2019-11-21,Unscheduled-21-NOV-2019 1006,9.01,2019-11-21,Unscheduled-21-NOV-2019 1006,9.01,2019-11-21,Unscheduled-21-NOV-2019 1006,9.01,2019-11-21,Unscheduled-21-NOV-2019 1007,01,2019-10-06,v1 1007,02,2019-10-08,v2 1007,03,2019-11-22,v3 1007,04,2019-12-19,v4 1007 ,9.01 ,2019-11-23,Unscheduled-23-NOV-2019 1007,9.01,2019-11-23,Unscheduled-23-NOV-2019 1007,9.01,2019-11-23,Unscheduled-23-NOV-2019 1007,9.01,2019-12-21,Unscheduled-21-DEC-2019 1008,01,2019-09-06,v1 1008,02,2019-10-08,v2 1008,03,2019-11-22,v3 1008,04,2019-12-19,v4 1008,9.01,2019-09-07,Unscheduled-07-SEP-2019 1008,9.01,2019-09-07,Unscheduled-07-SEP-2019 1008,9.01,2019-12-20,Unscheduled-20-DEC-2019 1008,9.01,2019-12-20,Unscheduled-20-DEC-2019 ; run;   i want this  data want; length id visitno visit $200 visitdt 8; infile datalines dsd truncover; input id visitdt visit $ visitno; datalines; 1006,1,2019-11-06,v1 1006,2,2019-11-08,v2 1006,2.1,2019-11-21,Unscheduled 2.1 1006,2.1,2019-11-21,Unscheduled 2.1 1006,2.1,2019-11-21,Unscheduled 2.1 1006,2.1,2019-11-21,Unscheduled 2.1 1006,3,2019-11-22,v3 1006,4, 2019-12-19,v4 1007,1,2019-10-06,v1 1007,2,2019-10-08,v2 1007,3,2019-11-22,v3 1007,3.1,2019-11-23,Unscheduled 3.1 1007,3.1,2019-11-23,Unscheduled 3.1 1007,3.1,2019-11-23,Unscheduled 3.1 1007,4,2019-12-19,v4 1007,4.1,2019-12-21,Unscheduled 4.1 1008,1,2019-09-06,v1 1008,1.1,2019-09-07,Unscheduled 1.1 1008,1.1,2019-09-07,Unscheduled 1.1 1008,2,2019-10-08,v2 1008,3,2019-11-22,v3 1008,4, 2019-12-19,v4 1008,4.1,2019-12-20,Unscheduled 4.1 1008,4.1,2019-12-20,Unscheduled 4.1 ; run; ... View more

data have ; a                        b 001                NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS) 001               NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS) 001               NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS) 001               NEW OTC OR RX DRUG ADDED, HOSPITALIZATION (INCLUDES ER VISITS) 002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 002               NEW OTC OR RX DRUG ADDED, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 003              STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 003              STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 003              STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS) 003              STUDY TREATMENT DISCONTINUED PERMANENTLY, Non-drug therapy, HOSPITALIZATION (INCLUDES ER VISITS)   i want  001               NEW OTC OR RX DRUG ADDED 001               NEW OTC OR RX DRUG ADDED 001               NEW OTC OR RX DRUG ADDED 002               NEW OTC OR RX DRUG ADDED 002               NEW OTC OR RX DRUG ADDED 002               NEW OTC OR RX DRUG ADDED 002               NEW OTC OR RX DRUG ADDED 002               NEW OTC OR RX DRUG ADDED 003              STUDY TREATMENT DISCONTINUED PERMANENTLY 003              STUDY TREATMENT DISCONTINUED PERMANENTLY 003              STUDY TREATMENT DISCONTINUED PERMANENTLY 003              STUDY TREATMENT DISCONTINUED PERMANENTLY ... View more

Data have character time  time 10:32 10:14 10:15 10:06 09:42   i want  10:32:00 10:14:00 10:15:00 10:06:00 09:42:00 ... View more

Raw Data subjid visitnum         visit date                            visit 101       1                 27NOV2018               VISIT 1 / BASELINE / DAY 1 101       2                 28NOV2018               VISIT 1 / BASELINE / DAY 1 101       3                29NOV2018                VISIT 1 / BASELINE / DAY 1 101       9.00            06DEC2018               UNSCHEDULED VISIT 1 101       9.00           06DEC2018                UNSCHEDULED VISIT 1 101       9.00           06DEC2018               UNSCHEDULED VISIT 1 102        1              20NOV2018               VISIT 1 / BASELINE / DAY 1 102        2                04DEC2018             VISIT 2 / INTERIM / DAY 15 102        3               18DEC2018              VISIT 3 / END OF STUDY  102        9.00          01DEC2018                UNSCHEDULED VISIT 1  102        9.00          01DEC2018                UNSCHEDULED VISIT 1 102        9.00          01DEC2018                UNSCHEDULED VISIT 1 102        9.00          01DEC2018                UNSCHEDULED VISIT 1   Want Data    subjid visitnum         visit date                            visit 101       1                 27NOV2018               VISIT 1 / BASELINE / DAY 1 101       2                 28NOV2018               VISIT 1 / BASELINE / DAY 1 101       3                29NOV2018                VISIT 1 / BASELINE / DAY 1 101       1.3            06DEC2018                 UNSCHEDULED VISIT 1 102        1              20NOV2018               VISIT 1 / BASELINE / DAY 1 102        1.1            01DEC2018                UNSCHEDULED VISIT 1  102        2               04DEC2018             VISIT 2 / INTERIM / DAY 15 102        3               18DEC2018              VISIT 3 / END OF STUDY      ... View more