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

EG doesn't have a feature to write a .sas7bdat file to a local location without using SAS to do it. That's why you need local SAS. But you can use Tasks->Data-Download SAS Data Set to bring a remote SAS data set to your local drive. However, there isn't a way to then send that via e-mail attachment from within EG. You'll need to use another process to achieve that. Chris ... View more

None of the above solution is a single SQL. Question is, why is that important? Is this you real summarized data huge, and you want to avoid more than one pass of data? In that case, one could use a view approach for the SQL group by step. And for ranking, why not use a procedure which was created to do - ranking...? In my eyes, it is the simplest (and supported) code: proc rank data=work.a1 out=a2 descending; var tot_sales; ranks rank_sales; run; /Linus Oh, missed the ranks statement... Message was edited by: Linus H ... View more

THANKS Technolero!!! That was the step I was missing. My prompts are working perfectly! ... View more

Hello Bncoxuk, Dataset r in my program contains the information you requested and it is the same as in KSHARP's output but does not contain counts. Sincerely, SPR ... View more

This error is coming from SAS/ACCESS, perhaps via your ODBC driver to the database you are using. I'm not sure what would cause it to suddenly stop working, but you might try adding an OBS limit on the table references to see if you can get it to work with a smaller set...to help debug it. Chris ... View more

Hi. I have another resolution. Using command 'dir c:\temp\*.xls /s' which can display all the xls files in the temp directory and its all the sub-directory. then using FILENAME and PIPE to get the directory and filename.But each xls file must has unique name to avoid erase the dataset with same name. [pre] *To import multi xls files from multi sub-directory.Suppose all the sub-directory with xls files are in the 'c:\temp\'; filename _xls pipe 'dir c:\temp\*.xls /s'; data xls_file; infile _xls length=len; input whole $varying200. len; retain directory; length file_name $ 200; if strip(whole) eq: 'c:\temp' then directory=scan(whole,1,' '); else if scan(whole,-1,'.') eq 'xls' then do; _name=scan(trim(whole),-1,' '); file_name=catx('\',directory,_name); output; end; keep file_name; run; data _null_; set xls_file nobs=num_obs; call symputx(cats('path',_n_),file_name); call symputx(cats('name',_n_),scan(file_name,-2,'.\')); call symputx('nobs',num_obs); run; %put _user_; options mprint mlogic symbolgen; %macro xls_to_csv; %do i=1 %to &nobs; proc import datafile="&&path&i" out=&&name&i dbms=excel replace; getnames=yes; mixed=yes; run; proc export data=&&name&i outfile="%scan(&&path&i,1,'.').csv " dbms=csv replace;run; %end; %mend ; %xls_to_csv [/pre] Ksharp ... View more

Hello KDang, The Initialization step has been included to create initial data for your input arrays a1q, etc. It is not necessary in your program. Sincerely, SPR ... View more

the problem is with the data being out of valid range for the model. Even though "odd" fraction powers might provide a real root there are also "imaginary" roots (- since you wish to be rigorously mathematical I think that was the terminology when I learnt complex maths in school....) but mine was not imaginary but a real problem: re-basing a measure of the rate of increase (or decline).. So as that terminology switched from increase to decline, the negative sign was removed to "outside" the calculation and into the terminology... ... View more

Thank you, yes I will have multiple observations by week for each class. Thanks again. ... View more

Hi Brian As Scott suggested: data _null_; start='07jan2010'd; do stop=start to '12jan2010'd; wdvar=intck('weekday17w',start,stop); put wdvar= @10 start= WEEKDATX. @50 stop= WEEKDATX. /; end; run; HTH Patrick ... View more

Thank you. Tested your solution. It worked fine. Agree with you that it's the informat! ... View more

Are you trying to point the libref to a different location? Or are you just re-running the code that assigned the libref? If the latter then test first before defining the library.  Here is can example command using the IFC and LIBREF functions to conditionally issue the libname statement only when the libref does not already exist. 4    %sysfunc(ifc(%sysfunc(libref(macros)),libname macros '~/temp',)); NOTE: Libref MACROS was successfully assigned as follows:       Engine:        V9       Physical Name: /home/abernt/temp 5    %sysfunc(ifc(%sysfunc(libref(macros)),libname macros '~/temp',)); The other thing to consider is changing the SASMSTORE option before trying to modify the libref. ... View more