Then View is a good choice. %let outvalue=5; data want/view=want; set ds1; outvalue=&outvalue; run; Ksharp ... View more

What are you trying to accomplish?  Are you just trying NOT to include the variable names?  If so, use the option putnames=no.  Take a look at: http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103525.htm ... View more

Hi Wouldn't this just be to collect the highest exit code of the SAS programs you're submitting (as part of the dos script). As I understand it each of these programs is submitted in batch (within this .bat file). So these are a couple of child processes and there won't be a common SAS macro variable around as every single job runs in its own environment. Alternatively you could use the Windows Task Scheduler or LSF (if installed at your site) to handle job execution and error conditions. HTH Patrick ... View more

Thanks! A lot of good advices! Thank you again ... View more

For SQL views: describe view libname.viewname; For data step views, use the describe statement. For details, see online doc, /Linus ... View more

mmm... simple! Thank you very much Olivier! Simone ... View more

data Have; input a b; cards ; 0 1 1 2 2 3 0 1 2 5 1 1 2 1 1 3 ; run; data want(keep=a b); set have end=last; retain counter 0 RetA RetB; RetA=a; RetB=b; if counter>2 then counter=0; do until( (counter>RetA and not last) or (last and counter>2)); if RetA=counter then do; a=RetA; b=RetB; end; else do; a=counter; call missing(b); end; output; counter+1; end; run; proc print data=want; run; HTH Patrick ... View more