true story 😄 ... View more

Also a quick hint, whenever you post a question regarding clinical sas, you can mention it in the topic or at the start of your question so that it would not cause a misunderstanding. SAS is used in a lot of fields, and as this is a a global platform, we need to be somewhat a little more specific sometimes 🙂 ... View more

usually supplementary data for EG domain contains BEAT number or Repetition number for that particular ECG test. It is not necessary that every EG domains will contain supplementary information. Hence can you please elaborate as to what information do you need to populate in SUPPEG? Also if you have already created EG domain, can you please share that as well?   ... View more

and it should give result.. i tried the code before posting it ... View more

sure. just post a question in sas communitiies if you need anything ... View more

if you are using sas, direct import it using import tab in file and dont use the first part of the code ... View more

Heres your below program with the required updates :-     DATA ABC_CORP; FORMAT DOB VISIT_DATE DATE9.; DO SUBJ = 1 TO 10; DOB = INT(RANUNI(1234)*15000); VISIT_DATE = INT(RANUNI(0)*1000) + '01JAN2000'D; OUTPUT; END; RUN; ***program to create data set AGES; DATA AGES; set abc_corp; AGE_ACTUAL=YRDIF(DOB,'15JAN2005'D,'ACTUAL'); AGE_TODAY= ROUND(YRDIF(DOB,TODAY(),'ACTUAL'),.1); AGE= INT(AGE_TODAY); VISIT_DATE= INT(RANUNI(0)*1000)+ '01JAN2000'D; RUN;     You did not set the abc-corp data set and hence you were not getting the results. Also the age= statement had age which was niot initialised, hence i assumed and put age_today instead of age Please check if this is what you want, otherwise please let me know . ... View more

right click on libraries and then click refresh ... View more

Heres your program. Its a little big and not alligned well :p, but it should do the trick:-         DATA WORK.trial1; LENGTH ID 8 Group 8 Role $ 1 V1me 8 V1D 8 V1M 8 V1O 8 ; FORMAT ID BEST12. Group BEST12. Role $CHAR1. V1me BEST12. V1D BEST12. V1M BEST12. V1O BEST12. ; INFORMAT ID BEST12. Group BEST12. Role $CHAR1. V1me BEST12. V1D BEST12. V1M BEST12. V1O BEST12. ; INFILE "please put your path\filename here"' LRECL=18 ENCODING="WLATIN1" TERMSTR=CRLF DLM='7F'x MISSOVER DSD ; INPUT ID : BEST32. Group : BEST32. Role : $CHAR1. V1me : BEST32. V1D : BEST32. V1M : BEST32. V1O : BEST32. ; RUN; DATA K/*(KEEP=ID GROUP ROLE V1ME)*/; SET TRIAL1; RUN; proc sql; select id,count(id) into :idvars separated by " _num_",:cnt from k; quit; PROC SORT DATA=K(rename=(v1d=d v1m=m v1o=o));BY id;RUN; PROC TRANSPOSE DATA=K OUT=L name=role prefix=_num_; BY group; ID id; VAR d m o; RUN; data l; set l; role=upcase(role); data c(keep=role v1me); set k; run; proc sort data=c;by role; proc sort data=l;by role; data s; merge l(in=a) c; by role; if a; run; %macro count; %do i=1 %to &cnt.; data s; set s; %scan(_num_&idvars.,&i.)=%scan(_num_&idvars.,&i.)-v1me; run; %end; %mend count; %count; Proc sort data=s;by group ; proc transpose data=s out=a name=ida; by group ; id role; var _num_&idvars.; run; data b(drop=ida); set a; id=input(compress(ida,"_num_"),best.); run; proc sort data=k out=met(keep=id group);by id group; proc sort data=b;by id group; data t(rename=(D=D_accuracy M=M_Accuracy O=O_Accuracy)); merge met(in=a) b; by id group; if a; run;   the input dataset is trial1 and output dataset is t.   Note:- please change the location in the infile statement. Also let me know if you need any changes.   The output looks like below attached screenshot ... View more

OK,, i thought of it as a result.. so you want the results of v1d,v1m,v1o to be in one column ? if it is else-wise, could you please show me how the end result would look like? I don't want to provide you with a wrong code. ... View more

can you show what the source data would look like? ... View more