I have two variables, which contains list of dataset variables. A = "VAR1 VAR2 VAR4" and B = "VAR3 VAR4". I want to get string with all 4 VAR1-4 (ascending order is not required). Would be better to solve it inside one Datastep. Is it possible? Or I have to lists VARNAME functions for each of varnum based on NVARS attribute applied to "DSNAME(keep=" || A " " || "B" || ")"? Or I have to use 2 arrays and loops? Is there a better/elegant solution? ... View more

I try to create Vertical BAR (Red) width specified width (Study Day)(YAxis) for all Subjects(Yaxis) Swimmer Plot. HighLowPlot Y = Subject High = REFENDY Low = REFSTDY / Type = BAR BARWIDTH = 1 HighCap = NONE Primary = True Display=(FillPattern) FillPatternAttrs=(Pattern=L1 Color=LightRed) FillAttrs = (Color = LightGreen Transparency=0.6) LegendLabel="Washout Window" Name="washout" ; Problem is that red lines in FillPattern doesn't match for different Subjects. Someone know another method, how to draw such red vertical rectangle? ... View more

I want to get observation number from expression <dsname(where=(...))> by using macro code. So I could write in any place (inside other procedure or %if statement) %if %sysfunc(nobs(dsname(where=(...)))) > 0 %then %do;  BY-statement-code; %end; My current solution uses PROC FCMP and DOSUBL inside custom function NOBS. After all I use %sysfunc(NOBS(...)). Inside NOBS function I use NOBS ATTRN to obtain answer if possible. Otherwise, inside DOSUBL I use PROC SQL to count observation number. Is there any other universal solution, which more stable than NLOBSF? I think I could use FETCH inside NOBS function, but I don't know: should I extract WHERE= option and then apply something like If not where_string then delete; But there is a problem, that i can't in one function call extract where_string and use it as code.  DOSUBL seems very hard for performance. It's intitializes additional environment/space/memory? Is there a way to do this elegantly and reliably?   ... View more

Is there any method, where I can extract dataset name from expressions like: <work.ds(...where=(...))> <ds(... where=(...))> or somehow check that this expression is valid in macro calls (wthout PROC or DATA statements)? ... View more

I try to create template (StudentizedPanel).   Problem is that I want to print it with by statement. Is it possible to do it without macro do loop? I created macrovariables in format _MIN_#byval(AVISITN). So I have _MIN_2 _MIN_3 and _MIN_4 macro variables (and for other statistics). And  there is symget function in proc template with using _BYVAL_: But my Residual Stistics in png still empty:   Is symget applicable in proc template? Or maybe there is another way to add other statistics  (not default, for example, p-value from another procedure) in right down corner without macro loop?   UPD:   I tried other code:   but output is  still  empty. Probably problem in _BYVAL_? ... View more

I used proc mixed to produce Studentized Residuals with model CHG =... CHG variable has label Change. But in output png file inner title (which placed in position, where usually template's entrytitle statement applied). So how I can change this entrytitle to Studentized Residuals for Change from Baseline?   ... View more

I try to create template for  PROC SGRENDER DATA=INDS TEMPLATE=myTemplate; I want to rotate legend (by Default it Horizontal in any position),  but can't find option. I found ODS LEGEND, but it seems like it's working for PROC GPLOT.  Is there exist such option or another method to rotate legend in SGRENDER?    ... View more

Hello. Suppose I use proc mixed to show Studentized Residuals and create .rtf file.    If I want to change color and maybe some other graph options for each plots (Labels, Tick values). I can try to use option UNPACK, and then somehow by using SGRENDER and proc template and layout lattice edit all possible options and show output datasets on Layout/Graph. But I don't know how to show Right-Bottom Corner (table with statistics [these are ODS OUTPUT fitstatistics and descriptive statistics obtained using proc means on ODS OUTPUT StudentByPredicted ]). How I can solve this? Or maybe there is exists some way to edit style of StudentPanel? Something like: ODS RTF BODY="..." style=styles.MyStyle; ods graphics on; proc mixed data=inds plots=StudentPanel; class &class.; model &model.; run; ods graphics off; ODS RTF CLOSE Could you help me? Also Tried ODS LAYOUT, but it seems that it doesn't work with RTF.  ... View more

Is there are some alias for %sysfunc() key word? Somethin like %s? Sysfunc to long to write and read. ... View more

Is it possible to get all variable names from dataset by using %sysfunc() (i mean by using only macro code without datasteps and procedures like SQL")? So i could insert this call as argument for other user's defined macro function. Probably it has to use %sysfunc(varname) function. ... View more