Hi all, I should use the proc means in a particular way: n-1 values are stored in a DS (e.g. DS1) the last value is passed by a macro variable. How can I do without writing the last value into the DS? %let outvalue=5; PROC MEANS DATA=DS1 noprint ; class id; VAR x ; /*and the value stored in the macro variable &outvalue*/ OUTPUT OUT=outfile(drop=_TYPE_ _FREQ_) median =mymedian; RUN ; Thank you Simone ... View more

Hi, the proc below exports the DS starting from the first observation, what's wrong with the firstobs=1 option? Thank you proc export data= xxx (firstobs=2) outfile=C:\yyy dbms=dlm; delimiter=" "; run; Simone ... View more

Hi, I've put some SAS programs in a .bat file that runs every day. At the end of the process SAS send me an email with the log file. With which automatic macro variable could I check if there was an error in the execution? In this manner I'd avoid receiving the whole log file. Thank you ... View more

Hi, I'm trying to optimize a SQL loop like this %do i=1 %to 100 %by 2; proc sql; create table table&i as select x , idx, z, sum(y) as tot&i from database where idx between &i and %eval(&i+1) group by x; quit; %end; This loop creates 50 little tables referring to the variable in the where clause. After that I merge all the tables. The time process is very long, probably ralated to the huge database (3.000.000 records, 10GB). How can i avoid the 50 tables? Thanks in advance Simone ... View more

Hi, I have some doubts about tables & views. If i have to create some DS in order to manipulate data and then generate a final dataset, which kind of intermediate file is better to use, view or table? I know that views are smaller, what about the difference in the elaboration time? Thank you Simone ... View more