Cynthia; Talking with tech support def gives rise that this may be a problem with my stsem somewhere as they had no issue either. I'll simply try at home and see what happens there as well and see if that make a difference. It makes no sense at all. In the interim, I will continue w/ the "boxes" until I get to the bottom of this. And yes I stand corrected or rather I amend the statement of "seem to work for HTML output but not for RTF" to "seem to work for HTML output but not for RTF on my system. Thanks again for your help. Lawrence ... View more

have you tried : proc sql ; describe view your.view ; quit ; ... View more

Ignore..I managed to embed the who case statement in the join.. Thanks! ... View more

Amar; I figured it out. by removing the if first.room = last.room then delete statement I got the missing unit back.. Thanks again! Lawrence ... View more

Thanks for the help, Polingjw's query worked best. The PUT(A.Attending_Physician, $Special.) simply assigns a format that I created. Just my SQL could use some work. Thank you. Lawrence ... View more

Once again-Thanks Cynthia! ... View more

Sanjay; I wish I could do that, but this forum does not allow for that.. ... View more

Cynthia; Thanks for the solutions. I was just reading about order when the thread came through. Also the tip on the analysis/display helped immensely. Thanks again! ... View more

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

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

You will need to wrap the PROC SGRENDER code with the same ODS statements as your SGPLOT code. Basically, the SGRENDER binds the data with the GTL template to create the graph. Be sure to replace "yourdataset" with the dataset from the SGPLOT code. Thanks! Dan Message was edited by: DanH@sas ... View more

Bill, You are right, if you don't ask, you don't get. Found a much easier solution actually. Our sharepoint allows (some users) to save as an Access 2007-10 DB with a linked table to sharepoint. Solves the problem! ... View more

Thanks Linus! ... View more