Peter; I know where you are going with this I think. Something to ponder the next time I have to do this more efficiently. In the interim, I simply parsed out a subset, ran a macro, and re-merged later. For all though, I do appreciate all the tips. Best Lawrence %macro group_roles (data=, var=); proc sort data=&data(keep=&var) out=values nodupkey; by &var; run; data _null_; set values end=last; call symputx('GROUP'||left(_n_),&var); if last then call symputx('count',_n_, 'g'); run; %put _local_; DATA _NULL_ ; select(&var); %do i=1 %to &count; DATA GROUP&i; SET PREP_ROLES; where role2="&&GROUP&i"; IF SUBSTR(COMPLIANCE,1,1)='1' THEN &&GROUP&i.._YES=1; IF SUBSTR(COMPLIANCE,1,1)='2' THEN &&GROUP&i.._NO=1; run; %END; %mend group_roles; %group_roles(data=roles, var=role2); ... View more

Chang; I am going to try your solution now... ... View more

Thanks Cynthia for the tip. I was simply trying to recode this in such a way that it creates a new variable as I have 20 some job classifications so that in the end.. _01_Y _01_N ob1 1 ob2 1 ob2 1 ... obs20 1 This data will then be transposed. I am just trying to figure out a way so that I can convert the data strings such as _17_Y to a variable field if this helps w/o needing to create each one. I can do an entire macro to do this for each number but it gets complicated remerging sets but can be done. I was looking for an easier solution w/in the data set. it does not have to be a macro. hope this helps explain my dilemma. Thanks again. Lawrence ... View more

Sorry for the delay in response I have been swamped! So the table structure looks like that below: Surg_ID cd_field cd_value "field name" format in table end format 1 100 Block Last name char char 1 333 1 414 1000 Surg_start character time:HH:MM 1 415 1215 Surg_end character time:HH:MM 2 100 Smith Last name char char 2 333 2 414 900 Surg_start character time:HH:MM 2 415 1147 Surg_end character time:HH:MM 3 100 Jones Last name char char 3 333 3 414 1600 Surg_start character time:HH:MM 3 415 1753 Surg_end character time:HH:MM where the first three columns are in the table for example. So in essence, yes I am transposing data as each surgery may have 90 entries or so. So at the end of the day, each line would have distinct values so that: surg_ID, cd_value as name where cd_field=100, cd_value as surg_start where cd_field=414 etc etc.. I can do this currently in a macro by pulling out the cd_fields I want, putting them in a table, writing a macro that will pull the values and then another quick macro to merge all the values. However, I am trying to write this query in SQL w/o macros so it can be ported later to a stored procedure in SQL... Thanks again. Lawrence ... View more

Dan; It sort of worked...It did generate the temp.sas file and I did modify it. And it does make the box white but when I add the proc sgrender data=yourdataset template=sgplot; run; statement it leaves out the the actual data. Plus it renders it as an image not as a RTF file as specified. I can change the GTL if I actually can find the parent style? Or somehow create a new template with the LAYOUT GRIDDED option. I am a newbie at GTL, so it may take some doing.... Thanks again. Lawrence ... View more

sorry about that-I am using SGPLOT. I managed to use offsetmax to get by, but still looking at other solutions. Thanks. Lawrence ... View more

Brentos; Normally you can output the set within the proc function with the output out=p p=yhat (p is an arbitrary designation) statement with the predicted values by using the p=yhat . From there, you can transpose the set and use the functions min,max, etc... See code below. If there are more efficent methods I would be game to hear them. Hope this helps you. data X1; set p; x=compress('x'||_n_); run; proc transpose data=X1 out=descstats; id x; var predicted; run; data descstats; set descstats; min1=min(of x1-x?); max1=max(of x1-x?); run; proc print; var min1 max1; run; ... View more

Thanks Linus! ... View more

Dan; I'll take a look. Thanks for sharing this. ~Lawrence ... View more

Peter; Worked like a charm! Much Thanks! Lawrence ... View more