thnaks a mot Kurt. It works as attended. evenf if the link is a littl weird with "\" and "/" like this : lien= \\\/ukipu004.dummy-website.fr\folst\Export_files\result.xls ... View more

hi PaigeMiller   sorry, but I still need some help. by specifying "options nomprint", the result is muchbetter but there is still "The SAS System" printed. thanks a lot in advance ... View more

If you want the text output of the describe statements, then direct that output to a seperate file, you will always get information about the run to log, you can minimise it, but there will always be feedback.  Its really hard to follow your post but simply: data _null_; set sashelp.vtable (where=(libname="&p_lib_name." and substr(memname,1,2)="CL")) end=last; if _n_=1 then call execute('proc printto listing="c:/code.txt";run;proc sql;'); call execute(cats('describe table &p_lib_name..',memname,';')); if last then call execute('quit;proc printto listing=listing;run;'); run; ... View more

thanks a lot Rick   it works. I don't have the message "PROC NLIN failed to converge" anymore but "Convergence criterion met" I Wonder why you suggeses this grid values ? I assume it is because my initials values were around a=55, b=62 and c=8, , exact ? thanks   ... View more

You can use this macro,  just add you DATASET NAME and LIBRARY NAME into it.   %macro getvars(lib,dsn); %global vlist; proc sql; select name into :vlist separated by ' ' from dictionary.columns where memname = upcase("&dsn") and libname =upcase("&lib") and name like 'class%' ;quit; %mend; %getvars(LIBRARY,DATASET); %Put &vlist ... View more

From search; https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=forum-board%3Aprogramming&q=cumulative+sum   50 responses all with code which does what you want.  ... View more

It works perfectly thanks ! ... View more

@Nasser_DRMCP wrote: hello,   I found the solution for multple columns. the syntax in the input statement is below (RATE_2007-RATE_2021) (15*:commax.)   Nasser Right.  Note that you don't need the 15* as SAS will automatically recycle the list of informats (or formats) when it is shorter than the list of variables.  You could also remove the informat specifications from the INPUT statement and instead add an INFORMAT statement. ... View more

I am big fan of PRXCHANGE for this kind of problem which is origined from @Patrick   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 %let list_have = word1 word2 word3; 70 %let list="%sysfunc(prxchange(s/\s+/" "/,-1,&list_have))"; 71 %put &list ; "word1" "word2" "word3" 72 73 74 %let list_have = word1 word2 word3; 75 %let list=%bquote('%sysfunc(prxchange(s/\s+/' '/,-1,&list_have))'); 76 %put &list ; 'word1' 'word2' 'word3' 77 78 79 %let list_have = word1 word2 word3; 80 %let list=%sysfunc(prxchange(s/\s+/|/,-1,&list_have)); 81 %put &list ; word1|word2|word3 82 83 %let list_have = word1 word2 word3; 84 %let list=%sysfunc(prxchange(s/(\w+)/_$1%str(,)/,-1,&list_have)); 85 %put &list ; _word1, _word2, _word3, 86 87 88 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 99 ... View more

Kurt,   by lauching your code , the result is  'hellobye GOPTIONS NOACCESSIBLE' i succeed to prevent the GOPTIONS NOACCESSIBLE only by closing and restart sas EG. thanks all for your help ... View more

In PROC REPORT, order of statements matter. Try moving the COMPUTE before the DEFINE statement, similar to the posted example. ... View more