With regards to SAS App Dev - SCL/AF - its old.  I don't think many use it anymore.  You can integrate SAS with other more widely used technologies though - Java, .Net etc.  ... View more

Hi ballardw and Tom Unfortunately I can't both mark you as correct answer but both of you were right! Thanks! Happy days Steve ... View more

Consider the EXCEPT operator in PROC SQL. ... View more

Thanks Guys!!!! ... View more

Not a lot to look up on it (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002605538.htm), but the anydtdte informat appears to be able to read dates that give all of the other date informats problems.  A useful system option to supplement it is the: options datestyle=mdy in order to guide the informat regarding the order of the three date parts. ... View more

You are welcome. ... View more

Understood.  Linlin's suggested code was an example of one of the forms of an interative do loop.  It is documented at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201276.htm However, in your case, you will also need to include a length statement or else the length will be determined by the first value in the list.  e.g., data want;   set have;   length test $10;   do test='RBC','WBC','Urine','Platelets';   output;   end; run; ... View more

shortcuts that Art297 refers to are great try if not first.subject then call missing( age, sex, telno, address ); or %let varlist = age sex telno address ; if not first.subject then call missing( of &varlist ) ; ... View more

If you want table name: data one two three; set sashelp.class; output  one two three; run; option mprint mlogic symbolgen; %let t_list=work.one work.two work.three; %macro tlist; %let i=1; %let name&i=%scan(&t_list,&i,%str( )); %do %while(&&name&i ne ); %let t_name&i=&&name&i(in=in&i) ; %let i=%eval(&i+1); %let name&i=%scan(&t_list,&i,%str( )); %end; data all ; set %do j=1 %to &i-1;        &&t_name&j      %end;      ; length indsname $ 40; select; %do k=1 %to &i-1; when(in&k) indsname="&&name&k"; %end; otherwise; end; run; %mend list; %tlist Ksharp ... View more