@jlf wrote: The association problem still hasn't been resolved. Sorry to hear that. In this case I have three suggestions: If your SAS software is a bit old (e.g., version 9.3), the advice given in Re: What to set as default app for handling sas program files (.sas) in Windows and the SAS GF 2013 paper linked there might help. A similar discussion (linking to the same paper), but also describing other solutions, can be found in the thread Fixing .SAS file associations with SAS 9.4. Personally, I wouldn't want to start a full SAS session (but the SAS Universal Viewer) when I double-click a .sas file: please see my reply Re: What to set as default app for handling sas program files (.sas) in Windows for more details and how I open SAS programs in the Enhanced Editor. If neither of the above solves your problem, I suggest that you contact SAS Technical Support. Good luck! ... View more

@PamG wrote: If I do a left justification then text touches the box. Is there a way to put a left margin between the text and the box? I think adding white-space characters to the text, as suggested by data_null__, is the easiest (if not the only) option -- similar to the first NOTE statement, note h=12pt; the purpose of which is to insert space between the text and the top of the box. ... View more

Hello @PamG,   Try the TITLE statement with a HEIGHT= option.   Example: title1 height=5 "Data : aaa"; title2 height=4 "Years of study: xxx"; title3 height=3 "Outcomes: BBB"; proc print data=sashelp.class; run; title; The values 5, 4, 3 are relative sizes, but you can specify absolute values like 24pt as well. ... View more

Hello @jlf,   That problem and possible solutions are described in this Knowledge Base article: Troubleshooting issues related to SAS® file-type association in a Windows operating environment. ... View more

Hello @Hlm2019,   Minor correction: SYMGET is not a CALL routine, but a function.   Example (for @Roberto_BM): data _null_; set sashelp.class; mvar='age'||put(age,2.); if not symexist(mvar) then call symputx(mvar,name); else call symputx(mvar,catx(' ',symget(mvar),name)); run; %put &=age11; %put &=age12; %put &=age13; ... ... View more

Alternatively, you could follow Example 2: Clustering a Grouped Scatter Plot from the documentation: data want; set forest_data; series=1; a=a1; lowa=lowa1; uppera=uppera1; output; series=2; a=a2; lowa=lowa2; uppera=uppera2; output; drop a1--uppera2; run; proc sgplot data=want; scatter x=XValue y=a / yerrorlower=lowa yerrorupper=uppera group=series groupdisplay=cluster clusterwidth=0.15; yaxis label="Odds Ratio" ; run; ... View more

@alepage wrote: I have 14 datasets to check, using proc contents.  For future checks like this (especially if more datasets are involved) you may want to consider querying DICTIONARY.COLUMNS rather than reviewing a lot of PROC CONTENTS output: /* List all TRX.PRM_TRX_... datasets not containing variable driverType */ proc sql; select memname from dictionary.columns where libname='TRX' & memname eqt 'PRM_TRX_' group by 1 having max(upcase(name)='DRIVERTYPE')=0; quit; ... View more

Hi @ssll,   You could avoid the %IF-%THEN/%ELSE statements like this: %let m=NNEEEERRREEE; %let N=no report will be generated; %let R=quarter to date comparison report; %let E=not in Q3 and not in Jan or Feb; %let c=%substr(&m,&current_month_num,1); %put &&&c;   However, I suspect that you actually want to execute some reporting statements if &c=R. In this case you could at least avoid the nesting: %let m=NNEEEERRREEE; %let N=no report will be generated; %let E=not in Q3 and not in Jan or Feb; %let c=%substr(&m,&current_month_num,1); %if &c=R %then %do; %inc 'C:\Temp\myQtoDreport.sas' / source; %end; %else %do; %put &&&c; %end; ... View more

Alternatively, you could store the exact value of max(of result1-result16) in variable SummaryResult (and thus have more information available) and define a format to display 100 as "UNKNOWN", 200 as "NO", etc. proc format; value sumres .='MISSING' 100='UNKNOWN' 200='NO' 300-high='YES' other='STRANGE' ; run; data want; set have; if n(of result:) then SummaryResult=max(of result:); format SummaryResult sumres.; run; This formatted variable could be used in CLASS statements (e.g. in PROC MEANS), as a group variable in PROC REPORT, for creating frequency tables (with PROC FREQ), etc. However, it would be slightly less convenient than a character variable if you had to retrieve the formatted values very often (as in if vvalue(SummaryResult)='YES' then ...). ... View more

@shoin wrote: My apologies Chris, I clicked on the wrong accept as solution ... Hello @shoin, It's easy to correct this: Select Chris's post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution. ... View more

Hello @RJY9,   Glad to see that Tom's solution worked for you. Then it would be fair and help later readers if you marked his helpful reply as the accepted solution, not your own "thank you" post. Could you please change that? It's very easy: Select his post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution.   ... View more

Hi @hellohere, @hellohere wrote: I prefer in SAS/SQL. Then try this:   proc sql; create table want as select a.*, max(b.x1) as x1_running_max from temp a, temp b where a.byvar=b.byvar & b.ind<=a.ind group by 1,2,3,4; quit;     ... View more