Please share a small example of code that causes the problem.   Please share the log from running that code. Also please explain the problem.  Do you get errors in your log?  Is the ODS output file not being created? etc.   ... View more

If the library has SAS datasets in it, you should see the size.  But it looks like the library points to CAS tables?  It's possible the sashelp catalog won't know the size of the table.  That often happens with libraries that point to relational databases as well.    If you need to get the size of a CAS table, you might want to look at CAS-specific methods, see e.g. this thread: https://communities.sas.com/t5/SAS-Viya/How-to-get-the-size-of-a-table-in-CAS/td-p/760880 . ... View more

@NewUsrStat wrote: Could you please give me an example? Thank you very much! Please note Tom's first answer.  He already provided a full example, almost identical to Kathryn's. ... View more

Sorry, my macro code will only work if the code is inside a macro definition. ... View more

One of the key parts to learning the macro language is to learn the difference between %IF and IF.     If you want to use the macro language to decide which SAS code the macro will generate, you use the %IF statement.   It sounds like you might want: %let cie=b2; data class; format company $1.; set sashelp.class; %if &cie=b1 %then %do; company="A"; %end; %else %if &cie=b2 %then %do; company="B"; %end; run; ... View more

I'm just guessing, but PYTHON cares about leading white space (indenting) in code.  When you compile a macro, it does not preserve white space in the code it will generate when executed.  So likely a compiled macro can't generate valid python code, if the python code is inline in the macro definition.  It's the same reason you can't use a CARDS statement inside a macro.  The %include approach kindly recommended in the error message sounds like a good workaround. ... View more

From prior discussion threads, I'm pretty sure you can trust the certification guide.  SAS wants you to pass the certification test.  They're not likely to add test questions on topics that are not addressed in the certification guide.  You just want to make sure you have the most recent certification guide.  I'm sure there are plenty of prior versions bouncing around the interwebs. ... View more

One benefit of log scanning vs using the job's return code to detect problems is it allows each job to customize the definition of failure.   For example, almost all of my jobs will treat notes about uninitialized variables, missing values be calculated, and automatic type conversions as errors that I consider job failure.  But some programs are written to allow such messages (unfortunately). If I inherit a job which is designed to use automatic type conversions, I can easily turn off that check in my log scanner, while leaving the check on for other jobs. ... View more

if you run: proc contents data=have (keep=Syndrome_1 Syndrome_2); run; proc freq data=have; tables Syndrome_1 Syndrome_2 ; format Syndrome_1 Syndrome_2 ; *remove any formats attached to the variables; run; What do you see?    It sounds like the variable type is numeric.  If that's the case typically you would have a format which maps each numeric code to a text string, something like: proc format; value Syndrome 1="Weight gain" 2="Other clinical signs" ; run; Do you have a format like that? ... View more

@yabwon wrote: In fact the sorting is very reason why implementing request of adding functions to merging is not "doable" in general case. Sorted data (ready for MERGE) after applying a function can be not MERGEble anymore. Ahh, that makes sense.  Definitely not implementable in MERGE. Thanks again. ... View more

Amazing @yabwon , so creative, as always! ... View more

Thanks @DanH_sas .  I tried again with width=10in height=7in today and it worked.  I'm pretty sure I was testing in a fresh session yesterday, so not sure how I managed to muck it up. ... View more

@sbxkoenk wrote: Try using these options on the panelby statement (behind the forward slash): LAYOUT=panel columns=4 novarname Koen That gives a single row with 4 columns, and uses the whole page correctly:     But I want a single column, with two rows. If I use Layout=panel columns=1, I'm back to having an image half the width of the page:   ... View more

No, you cannot do it in the MERGE step.     The MERGE statement reads the key values from each dataset, then decides which record(s) to read into the PDV.   You cannot use an expression on the BY statement.   Edit:  I was going to write that it's not possible to modify the key value before it is read by the  BY statement, because the data would need to be read into the PDV first.   But the WHERE statement is happy to modify key values before they are read into the PDV, so you can do stuff like: where upcase(category)='FOO'.  So theoretically the BY statement could allow you to manipulate the key values before they are compared.  But I don't think we're likely to see that added as a new feature. ... View more

Thanks for the thought Dan.     When I try e.g. width=10in height=7in  the plot is empty and the log tells me: Cell height -34 is smaller than the minimum cell height 1. All contents are removed from the layout. Cell height -34 is smaller than the minimum cell height 1. All contents are removed from the layout. ... View more