Will the folders which don't contain any content, say like a month after the forum has ended, be removed? Would make browsing a bit easier maybe ... View more

Hallo @basefan ,   Aktuell ist es mit ods excel noch nicht möglich Bilder auf Zellen-Ebene hinzuzufügen - deshalb funktioniert das mit dem preimage auch nicht.   Was allerdings möglich ist, ist es Bilder als Hintergrundbilder mitzugeben - dazu hat Chevell Parker ein super Paper geschrieben: http://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf   Hoffe das hilft dir weiter. ... View more

I'm not sure maybe this is a feature of a newer SAS/STAT Version then you have - but SAS/STAT 15.1 supports it just fine: https://documentation.sas.com/?docsetId=statug&docsetVersion=15.1&docsetTarget=statug_phreg_syntax.htm&locale=en ... View more

Hey @Mick_lb ,   I'm starting out with a few pointers to help you along the way and will have a final answer at the end.   What you are running into here is a classic macro if-condition problem. The get a better understanding of what is happening inside of the macro you should use the following options: options symbolgen mlogic mprint; You can deactivete them again with a e.g options nosymbolgen;   Now you can get a better look at how your variables are assigned and evaluted during the macro execution.   Next step lets assign the value of your if condition to a variable and show it in the log: %let x = "10/&my."; %put x=&x; This result in x="10/01/2020" and if you take a look at the variable &_date it shows 10/01/2020 now you see a clear difference. The two enclosing ". Well they just signify you might say but it is important to note that the macro language is just generating text in and of itself and thus " is another character and now it should be clear that the if-condition can actually never be true because of the way macros in SAS work.   Now what is the solution? Just dropping the " in the if condition works perfectly.   And now a full working example - which I hope works as you intent: options symbolgen mlogic mprint; %macro test; %let rc=0; %let my = %sysfunc(today(),MMYYS.); %put &my.; /*01/2020*/ %let _date= %sysfunc(today(),DDMMYY10.); %let x = 10/&my.; %put =&x; %put ===> &_date.; /*09/01/2020*/ %if &rc=1 %then %do; %put GOODBYE; %end; %else %if &rc=0 and &_date=10/&my. %then %do; %put HELLO; %end; %mend; %test ... View more

I'm sorry to say this but without any error message I'm afraid I can not help you. But this behaviour seems highly a typical for SAS if the node is marked as having produced an error there should be an error message in the log. Have a log at this post: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Enterprise-Miner-shortcut-How-to-find-logs/ta-p/375434 - maybe the error message gets printed to that log ... View more

If you tried to delete the Control Point node and add it back in? I know this sounds dumb but maybe there was some kind of hickup this should work. ... View more

Just use the _numeric_ and _character_ keywords like I did in my example. That will create an array with all numeric/character variables ... View more

Just add an additional check if the file exists or not to the second if statement   %let rc=%sysfunc(fileexist(/sas/temp/bbs_m.log)); %if &rc=0 and &_date="10/&my." %then %put Hello; ... View more

It looks like there is no data being passed into your Decision Tree Node if you click the node and look under Imported Data is it empty? If yes look into your Process and determine why data isn't being passed along (i.e. look into the Exported Data in the previous node). ... View more

Since I didn't have any sample data I constructed this simple example but it should work just fine for you. Just replace the variable definition with your set statement data work.result(drop=i); x = .; p = 6; array a{*} _numeric_; do i = 1 to dim(a); if a{i}=. then a{i}=0; end; run; ... View more

You are using select * to select all columns of all tables and after that you specify some columns again and these are the one that you get warned about. Solution either remove the select * and just select the columns you need or only use select * to get all columns. If you want to add the columns again you should give them a different name with A.CSID as cs_identification etc. ... View more