About DrBoogie

DrBoogie · ‎05-30-2018

Thank You, with %sysevalf(&est>0.4,boolean) it works. However I don't really understand, why there is such a difference between positive and negative values. But SAS is sometimes quite hard to unterstand, so it's OK. 🙂

DrBoogie · ‎05-30-2018

Hi all, I have a question with respect to the %sysevalf. I use in a macro programm the %if-condition of the following form: %if %sysevalf(&est)>0.4 %then %do; .... %end; It works fine if &est has positive values, for example 0.312 or 1.214.But if &est is negative, for example -0.091, then I become the error: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. I dont' understand why it could be important if the number in the macro variable is positive or not. Has somebody seen this effect and has an explanation? Thanks in advance.

DrBoogie · ‎05-09-2018

Thanks a lot!

DrBoogie · ‎05-09-2018

"Yes, unfortunately with a bad storage solution, you will end up with bad processes" Yep. but I have no influence at all as for the storage solution. I am a very small person in a very large company. 🙂

DrBoogie · ‎05-09-2018

Thank You, it's a nice idea, but then I have to be sure that there are no other files in the library which is also not an optimal way for me.

DrBoogie · ‎05-09-2018

Then I get ERROR: Required operator not found in expression: fileexist(work.to_&next_mon._&jahr.)

DrBoogie · ‎05-09-2018

Hi all, I am trying now to set together several files, with this code: %macro imp; %let mon = jan feb mar apr mai jun jul aug sep okt nov dez; data outtab; set %do jahr=16 %to 18; %do i=1 %to %sysfunc(countw(&mon)); %let next_mon = %scan(&mon, &i); work.to_&next_mon._&jahr. %end; %end; ; run; %mend; It works fine. But it could be potentially a problem if one of the files doesn't exist. I want now to incorporate a corresponding check. So I made this change: %macro imp; %let mon = jan feb mar apr mai jun jul aug sep okt nov dez; data outtab; set %do jahr=16 %to 18; %do i=1 %to %sysfunc(countw(&mon)); %let next_mon = %scan(&mon, &i); %if fileexist(to_&next_mon._&jahr.) %then work.to_&next_mon._&jahr.; %end; %end; ; run; %mend; Unfortunately this doesn't work because %if fileexist is always FALSE although the files are available. I guess that %if fileexist cannot be placed in the data step. But what is the alternative way? Do You have some idea? Thanks in advance.

DrBoogie · ‎04-26-2018

Thank You. My problem is probably that I don't really understand the purpose and advantage of metadata itself. I am working as a SAS programmer since 2007 but I never had much to do with metadata. And all what I done worked well without. 🙂 I understand that for example in the scope of Data Integration metadata is essential. Or if there are many users who have access to the data I could imagine that metadata can help organize processes in a secure way. But as for "normal" processes of data manipulation with only very few users (which is the case at my place) it seems not really that usefull for me.

DrBoogie · ‎04-25-2018

Hi all, sorry for a stupid question, but could You please briefly explain me what is the purpose of proc metalib? I have never used it myself and now I inherited a program where it is used (with the update_rule=delete). So, the table definition in the metadata is deleted although the table remains physically existing. Why would someone do so? I don't understand this. 😞 Thanks in advance.

DrBoogie · ‎02-27-2014

Thank You, this is exactly what I looked for

DrBoogie · ‎02-26-2014

Thank you, but this approach doesn't work, I attempted it already. I obtain the note "Apparent symbolic reference ... not resolved". It seems that the macro variables from prompts are not global, so they are not available at the end of the process. And since I use wizard-generated queries and not programs in my process I don't know how I can declare these macro variables as global. :smileycry:

DrBoogie · ‎02-26-2014

Hi all, I have a SAS EG project where some of parameteres are defined through the prompt mask. So, if starting this project the user have to select values for these parameters, using the prompt mask. What I want is to save the selected prompt values in some file (text, html, SAS - this does'n matter) at the end of the process, so that the user would be able to see afterwards, which values he(she) selected for this particular run. Is there some easy possibility to do this? Thanks in advance, Denis

DrBoogie · ‎12-20-2013

The correct hot fix was actually this one http://ftp.sas.com/techsup/download/hotfix/HF2/C/C44/C44032/xx/wx6/C44032x6.exe

DrBoogie · ‎12-19-2013

Hi all, I have the following problem: if trying to open the project (which ran successfully just before I saved and closed it) I obtain the error "SAS system.formatexception string was not recognized as a valid datetime". Though I already found the corresponding hot fix here: http://support.sas.com/kb/39/526.html, I am still not sure that this is the appropriate way to solve the problem because here http://ftp.sas.com/techsup/download/hotfix/HF2/D18.html#39526 I see "Error opening a SAS® Enterprise Guide® project created in a different locale" which is not true. And the installation brings nothing, the note is "Either this package is not applicable for the current platform, or this product cannot be found on your system, so the updates contained in this bundle will not be installed." Did anybody see a similar problem and knows how to fix it? Thanks in advance, Denis

DrBoogie · ‎12-10-2013

Hi all. I have the following problem. I have one process in EG where at the beginning some files are loaded which are thenused in some queries. These files are actually in the DB2 format but from SAS EG I see them as normal SAS files (so there is apparently some conversion in the background, sorry, I am not an expert in SAS PC Files). In any case the process ran quite good for a couple of weeks but yesterday I found it broken, namely, the files at the beginning were marked with the red cross and in all queries the links to the files were broken (one could still see the names of files but no variables any more and all joins were vanished). But the files are still there, where they were before! (They are in the permanent Meta-Libraries on the server.) So SAS EG forgot somehow, where the files came from. :smileyshocked: I couldn't find other way to repair the process as to load the files and to join them in queries again (and this costs a lot of time). So my questions: 1) could the repair be made more quickly? 2) what could be a reason for this problem? (for example, could it be so that if DB2 files were updated, the "links" to SAS were somehow damaged?) Can somebody help me please? Thanks in advance, Denis

Online Status	Offline
Date Last Visited	‎05-30-2018 08:41 AM

Re: Strange behaviour of %sysevalf with negative values of the macro v...

Strange behaviour of %sysevalf with negative values of the macro varia...

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Check if the file exists inside of a macro

Re: The purpose of proc metalib

The purpose of proc metalib

Re: Save values from prompts in a SAS EG project

Re: Strange behaviour of %sysevalf with negative values of the macro v...

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Strange behaviour of %sysevalf with negative values of the macro v...

Strange behaviour of %sysevalf with negative values of the macro varia...

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Re: Check if the file exists inside of a macro

Check if the file exists inside of a macro

Re: The purpose of proc metalib

The purpose of proc metalib

Re: Save values from prompts in a SAS EG project

Re: Save values from prompts in a SAS EG project

Save values from prompts in a SAS EG project

Re: SAS EG cannot open the project

SAS EG cannot open the project

Process damaged