Hi guys, i got this errors when need to fix the field method when origin=Derived, i try to fill method with : XD.XDSEQ   but i got this error:   variable XD.XDSEQN : Method 'XD.XDSEQ' could not be found in the current Define version.   any help?   Thanks.   Cuan. ... View more

Hi guys, please could you help me to understand this because my head is gonna exploted.   I create the next have dataset:   data have; input pulse $ pulsen; datalines; 80.0 80.0 90.0 90.0           . ;   data want; lenght pulsechar pulsechar2 $20.; set have; pulsechar=strip(input(pulsen,best.)); convert a numeric variable to character variable; pulsechar2=pulse; run;   The issue i have is: even SAS show me pulsechar as a character variable, the missing value numeric . is not converted to a blank value, the dot is remaining there, and i found it very annoying, because pulsechar is not a real character value.   Is that conversion numeric to character pulsechar=strip(input(pulsen,best.)); no strictly  speaking a real conversion from numeric to character?   Any help to make pulsechar (show the blank value as a dot) exactly the same than pulsechar2 (show the blank value)?   Thank you in advance.   Cuan.             ... View more

Hi guys,   I hope you can help me with this problem.   subject daily visit 101 11aug2021 period 1 101 12 aug2021 period 1 101  13aug2021 ---------> period 1 101 14aug2021 ----------> period 1 101 15 aug2021 period 2 101 16 aug2021 period 2 101 17 aug2021 period 2 101 18 aug2021 -------> period 2 101 19 aug2021 period 3 102 11aug2021 period 1 102 12 aug2021 period 1 102  13aug2021 -------->period 1 102 14aug2021. -------->period 1 102 15 aug2021 period 2 102 16 aug2021 period 2 102 17 aug2021 period 2 102 18 aug2021 ------> period 2 102 19 aug2021 period 3 How can i complete period 1 days 13 and 14, and period 2 day 18, basically the blank records (arrow) need to get the value of  the previous period until new period start.   Thanks in advance.   Cuan.             ... View more

Hi guys,   I hope you can help me with this:   I have 3 subjects: 1001, 1002 and 1003   Taking daily doses this periods of days:   subject start        stop 1001. 10jun2021 17jun2021 1001  18jun2021  25jun2021 1001   26jun2021  02jul2021 1002  02feb2021  10feb2021 1002  11feb2021  3mar2021 1002   04mar2021 07mar2021 1003   10dec2021 15dec2021 1003   16dec2021  28dec2021 1003.   29dec2021  05jan2022   I want to create a dataset with daily records from the start de dose (start firs record=10jun2021) to the end of the dose (stop last record=02jul2021)...example for subject 1001   same for the other subjects...something like this   1001 10jun2021 10jun2021 1001 11jun2021. 11jun2021 1001 12jun2021 12jun2021 ... 1001 02jul2021 02jul2021 1002  02eb2021 02feb2021 ... 1002  07mar2021 07mar2021 1003 10dec2021 10dec2021 1003 ... 1003 05jan2022 05jan2022   It will be great if you can help me to generate these daily records.   Thanks in advance.   Cuan ... View more

Dear Sas Community, have the next problem, it is not trivial, please try to give me the dataset I am asking for below. Thank you very much in advance. data have; input id treat date: date9.; format date date9.; cards; 1 1 16oct2017 1 1 30oct2017 1 2 14nov2017 1 2 26nov2017 1 2 27nov2017 1 1 11dec2017 1 2 12dec2017 1 2 13dec2017 1 2 24dec2017 1 2 25dec2017 1 1 27dec2017 1 2 09jan2018 2 1 16oct2017 2 1 30oct2017 2 2 14nov2017 2 2 26nov2017 2 2 27nov2017 2 1 11dec2017 2 2 12dec2017 2 2 24dec2017 2 2 25dec2017 2 1 27dec2017 2 2 09jan2018 2 2 10jan2018 2 2 11jan2018 2 2 22jan2018 2 1 05feb2018 I need a dataset want: subjid treat start stop 1 1 16oct2017 13nov2017 1 1 28nov2017 11dec2017 1 1 26dec2017 08jan2017 2 1 16oct2017 13nov2017 2 1 28nov2017 11dec2017 2 1 26dec2017 08jan2017 2 1 23jan2018 05feb2018 Thank you very much. Cuan. ... View more