Hi, I created the %getValues macro below, which should return all values of a column in a data set, within single quotes, separated by a space. [PRE] %macro getValues(dsname,colname); %let dsid=%sysfunc(open(&dsname)); %let vartype=%sysfunc(vartype(&dsid,%sysfunc(varnum(&dsid,&colname)))); %do %while(not(%sysfunc(fetch(&dsid)))); %if (&vartype=C) %then %do; %str(%')%sysfunc(compress(%sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,&colname))))))%str(%') %end; %else %do; %sysfunc(compress(%sysfunc(getvarn(&dsid,%sysfunc(varnum(&dsid,&colname)))))) %end; %end; %let dsid=%sysfunc(close(&dsid)); %mend getValues; [/PRE] It works when I %put it: [PRE]15 %put %getValues(SASHELP.CLASS,NAME); 'Alfred' 'Alice' 'Barbara' 'Carol' 'Henry' 'James' 'Jane' 'Janet' 'Jeffrey' 'John' 'Joyce' 'Judy' 'Louise' 'Mary' 'Philip' 'Robert' 'Ronald' 'Thomas' 'William' [/PRE] However, when I include the macro in a proc sql, it doesn't work: [PRE] 15 proc sql; 16 create table x as 17 select * 18 from sashelp.class 19 where name in (%getValues(SASHELP.CLASS,NAME)) _ 22 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, (, -, SELECT. _ 76 ERROR 76-322: Syntax error, statement will be ignored. MPRINT(GETVALUES): 'Alfred' 'Alice' 'Barbara' 'Carol' 'Henry' 'James' 'Jane' 'Janet' 'Jeffrey' 'John' 'Joyce' 'Judy' 'Louise' 'Mary' 'Philip' 'Robert' 'Ronald' 'Thomas' 'William 20 ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 21 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds [/PRE] In the log I see that the last quote is missing. When I replace the %str(%') in the macro with double quotes or other characters, it works fine. But I need the single quotes to prevent macro resolution. What am I doing wrong? Thanks, Bart ... View more

Hi, I created a new tagset called "ivb" with parent=tagsets.html4. This tagset adds some javascript in the doc_head event. Now I want to "subclass" the ivb tagset to add some extra javascript. In the subclass I notice that the parent's doc_head event is overriden by the child's. Is there a way to call the parent's doc_head event from the child? -Bart ... View more

Hi, Is it possible to open a WRS Report from the SAS Portal with a predefined subset? My case: 1. Report for New York 2. Report for San Francisco Clicking report 1 should give my WRS report with subset NY applied. Clicking report 2 should give my WRS report with subset SF applied. Thanks, Bart ... View more

Hi, Is it possible to have the column header text of Lists and Tables wrap at specific places, like using the split= option on PROC REPORT? Thanks, Bart ... View more

Hi, How can I set the ODS output style for a Stored Process when it executes from WRS? -Bart ... View more

Hi, There was another post on this forum concerning this problem but I didn't get the info from it that I wanted, so I try again. 🙂 See the result of the following code: [PRE] proc report data=sashelp.class nowindows; columns age sex,(name height); define age /group; define sex /across; define name /display; define height / analysis; run; [/PRE] [PRE] Sex F M Age Name Height Name Height 11 Joyce 51.3 Thomas 57.5 12 Jane 59.8 . Louise 56.3 James 57.3 . John 59 . Robert 64.8 13 Alice 56.5 . Barbara 65.3 Jeffrey 62.5 14 Carol 62.8 . Judy 64.3 Alfred 69 . Henry 63.5 15 Janet 62.5 . Mary 66.5 Ronald 67 . William 66.5 16 . Philip 72 [/PRE] Why is proc report skipping the lines? And what is the algorithm? The result I'm looking for is like this but with the empty cells shifted up per AGE. -Bart Message was edited by: bheinsius Message was edited by: bheinsius Added code results Message was edited by: bheinsius ... View more