What about simply saying; %let mvar=;   ... View more

Additional experimenting resulted in a solution (not very elegant I think): data insure;   input n c car$ age;   ln = log(n);   datalines;    500   42  small  1    1200  37  medium 1    100    1  large  1    400  101  small  2    500   73  medium 2    300   14  large  2    ; run; ods _all_ close; /* Closes all output */ ods output ObStats=myObStats (keep=car age pred   rename=(pred=PredictedValue)); /* Creates dataset MyObStats without displaying any output  */ proc genmod data=insure;   class car age;   model c = car age / dist   = poisson     link   = log     offset = ln     obstats; run; proc print data=insure; /* Does not produce output  because output is closed */ run; /*  Returns Sasreport back */ ODS tagsets.sasreport12(ID=EGSR) FILE=EGSR STYLE=Plateau STYLESHEET=(URL="file:///C:/SAS92/EnterpriseGuide/4.3/Styles/Plateau.css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); proc print data=insure; /* Displays SASreport  */ run; I guess that ODS tagsets.sasreport12(ID=EGSR) FILE=EGSR STYLE=Plateau STYLESHEET=(URL="file:///C:/SAS92/EnterpriseGuide/4.3/Styles/Plateau.css") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); depends on specific SAS installation. This ODS statement is produced by EG 4.3 if one checks TOOLS/Options/Results General/Show generated wrapper code in SAS log. ... View more

Hello Doc@Duke, Using your suggestions I made some progress, namely ODS _ALL_ Close; closes all open destinations, which is good. However, I can not figure out how to open SASREPORT12 tagset again. Using ODS markup tagset=sasreport12; produces an error pointing to unsuficient authorization to access sasreport12.xml. This is expected because I have no access to SAS server. Any help? ... View more

Thanks for additional info. I also see "ODS tagsets.dsasreport12 etc." in my LOG. You wrote "I think that you need to close that to eliminate the SAS Report". How to do that? SPR ... View more

Hello, Our admin told me that this error is due to expired local version of PC SAS and recommended to uninstall it. This action had several consequences: 1. The "Select Format" window opened by "Send to E-mail Recipient" does not contain SAS Data File format any more. 2. "Send to E-Mail recipient as a Step in Project" opens "Send" wizard and on clicking "Next" displays the error: Local SAS is required for sending a SAS Data File to an email recipient. Chris, it is strange that EG can send a bunch of differnt formats except native SAS files, is not it? Sincerely, SPR ... View more

Hello Patrick, It is very useful as an insight into internal mechanics of EG 4.3 sending E-mail. The one point I would like to clarify. You wrote: "And is your excel saved "locally"?". I send the same dataset but use different formats (Excel or native SAS): Assume the file name is test.sas7bdat from work library. In EG I open this file, select "Send To E-mail Recipient". Then in the "Select Format" window I select either "Microsoft Excel 97-2003 workbooks (*.xls)" (this works fine) or "SAS Data Files (V7 Long Name) (*.sas7bdat)" (this produces the above mentioned error). So it looks for me that in both cases file is sent "not locally" or I'm wrong? Sincerely, SPR ... View more

Yes, it is true. This constant could be found from the equation log(y+C) = 1 for y < 0. This guarantees that log(y+C) => 0. SPR ... View more

Hello Yiferic, I do not think that adding a constant to y is a bad idea. For a simple model log(y+C)=A+SUM(BiXi), we get y=exp(A+SUM(BiXi))-C. What "others" say, why is it a bad idea? Sincerely, SPR ... View more

Hello SASAcc, I am not sure that understand you correctly. What do you mean by t1 = max(0,c1 - c4);? Is this t1 = max(0,c1,c2,c3); or t1 = max(0,c1-c3):? Using c4 is impossible because c1, c2, c3 are numeric and c4 is character. Anyway this my solution: [pre] Data New; input c1 c2 c3 c4 $; datalines; 1 2 3 c2 1 3 5 c1 run; data a; set new; t1 = max(0, c1,c2,c3); if c4="c2" then c2=t1; else if c4="c1" then c1=t1; drop t1; run; [/pre] Sincerely, SPR ... View more

Hello Kevin, This code: DATA test; MERGE data1 data2; BY ID_1; IF a+b > 10; /*Note: a in data1, b in data2*/ RUN; works correctly. Merge happens before IF will execute. However, your logic in the initial code has a problem: IF MISSING(age_1) AND MISSING(AGE_2) THEN age='X'; You do not specify what to do if age_1 is missing and age_2 is not. This creates missing values for age. The same is true when age_1 is not missing but age_2 is missing. This is a test program: [pre] data data1; ID_1=1; a=5; output; ID_1=1; a=.; output; ID_1=2; a=3; output; ID_1=2; a=0; output; run; data data2; ID_1=1; b=6; output; ID_1=1; b=.; output; ID_1=2; b=8; output; ID_1=2; b=1; output; run; DATA test; MERGE data1 data2; IF MISSING(a) AND MISSING(b) THEN age='X'; BY ID_1; RUN; [/pre] Dataset test: [pre] ID_1 a b age 1 5 6 1 . . X 2 3 8 2 0 1 [/pre] Sincerely, SPR ... View more

Hello Bncoxuk, Check your LOG. It looks like you have an error: ELSE THEN should be simply ELSE. Sincerely, SPR ... View more