Hi all,   I'm trying to write a report. I created custom bits of ods text to include some breaks between sections. But for some reason they fail to load, while I've used them successfully in the past. I don't know what different in my current code/report for it to not print the text.   proc template; define style styles.wuss2019; parent=styles.sasdocprinter; class usertext from systemtitle / font=("Arial",11pt); style paragraph from usertext; end; run; ods escapechar="^"; title1 ""; ods text="^S={fontweight=bold} Analysis"; ods text="^S={fontweight=bold} First pass at a report. Feedback much appreciated"; ods text="^S={fontweight=bold} Generated on 08/12/2021"; /* Set dataset so we don't overwrite the original */ DATA mydat; SET sashelp.cars; RUN; /*----*/ ods text="^S={fontweight=bold} --------------------------------------------------------------------------------------------"; /*----*/ ods text="^S={fontweight=bold} Main"; ods text="^S={fontweight=bold} --------------------------------------------------------------------------------------------"; PROC GCHART DATA=mydat ; HBAR type / CLIPREF FRAME TYPE=FREQ COUTLINE=BLACK MAXIS=AXIS1 RAXIS=AXIS2 ; RUN; ods text="^S={fontweight=bold} --------------------------------------------------------------------------------------------"; ods text="^S={fontweight=bold} Second"; ods text="^S={fontweight=bold} --------------------------------------------------------------------------------------------"; proc freq data=mydat; tables type; run; So the "Main" bit prints fine. The "Second" bit is not printed. I don't necessarily need to use this ods stuff, I just need to create clear distinctions between sections of the analysis in my report. I've tried titles, but these print on all pages of the report. Anything that can help clearly differentiate sections is useful.    Thanks ... View more

Hi everyone,   I have a dataset that roughly looks like the one below.   data have; infile cards delimiter='|'; input X1 $ V1 $ V2 $ V3 $; cards; |a1| |a1 | ||c2,a1| c3,c2 | ||b2| | te || | | ; run; Now I want to create a new column miss that indicates whether or not a row had any observation in V1, V2, or V3. Row 1, 2 and 3 all have values in either V1, V2, V3 or some combination, so miss would here be 1. Row 4 has no values in V1-V3, so miss would be 0.  Important is that the solution is dynamic, since the dataset grows on a frequent basis.    I think an additional issue for my data is that i'm not sure these empty spaces are actually flagged as missing? How would I go about checking that? i've tried some of the missing functions in SAS, but i find them so unintuitive that I might as well just be doing it wrong and getting confusing results.   Thanks a bunch.   ... View more

  Hi everyone   I would like to add a variable to my data that indicates wether or not the value in V1 matches the value in V2.  V1 is actually mostly empty, most rows don't contain a value. If there is a value, it can be any combination of the values possible for V2 separated by a comma (,). I've sketched a bit of an example.    More general, I want to check if the string/character(?) in V2 shows up in V1, regardless of order or size.    V1 V2 Match   a1 0 a1, b1 a1 1 b2, b3, c6 b2 1 c4, b2 b2 1 BO a1 0   I've tried something with find, but I think I get an error related to the missings in V1?   DATA my_data;  Match = FIND(Var1, Var2) gt 0; RUN;   I'm very new to SAS, so sorry if I made a silly mistake. Thanks a bunch though! ... View more