are 'one' and 'two' sorted by lab and grp? i.e.   proc sort data=one; by lab grp; run; proc sort data=two; by lab grp; run; *merge after here ...; If this is not the issue, please include the log.     -unison   ... View more

Great! 🙂   -unison ... View more

Hi there, something like this solve your problem?   data have; input id wait_time pts_1 pts_2 pts_3; datalines; 1 12.85 1.67 2 1.5 ; run; data want; set have; array pts pts:; do over pts; pts=pts+wait_time; end; run; -unison ... View more

Hi there, Are you using something like virtualbox to run SAS studio?   -unison ... View more

You can probably adjust this to be more robust (right now, there are issues if multiple datasets have the same name but different formats).. But here's an idea! /* some user defined format*/ proc format; value companyfmt 1='Company A' 2='Company B' 3='Company C'; run; /* a data set where one variable is formatted using that format */ data test; input company variable $; format company companyfmt.; cards; 1 a 1 b 2 d 3 e ; run; *Stores result of var format into global macro var: _stdfmt; %macro retreivefmt(var); %global _stdfmt; %local dsid; %let dsid = %sysfunc(open(sashelp.vcolumn(where=(name="&var") obs=1))); %if &dsid %then %do; %syscall set(dsid); %let rc=%sysfunc(fetchobs(&dsid,1)); %let _stdfmt = &format; %let dsid = %sysfunc(close(&dsid)); %end; %put _stdfmt; %mend; %retreivefmt(company); proc print data=test(where=(put(company,&_stdfmt.)='Company A')); -unison ... View more