Hi, Try this: Proc template; Define style Style.Custom; parent=styles.default; style usertext from usertext /       font_size=8pt       font_weight=bold; end; run; ... View more

Hi, Have a look at your log, and the intermediary datasets in the process (i.e. run one step at a time) to identify the issue.  If you are still having issues then post the output from the log where it shows errors/warnings, or the exact code and some test input where it is not doing what you want.  You need to clarify what "resultant observation" you are not getting. ... View more

I think you need to modify your template to get that, style usertext I believe.  Have a look at this article: SAS(R) 9.2 Output Delivery System: User's Guide ... View more

Sweet, peek and poke good ol' ZX81 days all over again.  Will have to investigate the pokelong function. ... View more

Just change the section: data temp;   do i= '78060','7784','4659','07999','46611','77989','5990';     call execute('data code_'||strip(i)||';                     set work.test;');     do j="&VAR_LIST.";       call execute('if '||strip(j)||'="'||strip(i)||'" then output;');     end;     call execute('run;');   end; run; To something like: data temp;   do i= '78060','7784','4659','07999','46611','77989','5990';     call execute('data code_'||strip(i)||';                     set work.test;                          select('||strip(j)');     do j="&VAR_LIST.";       call execute('when '||strip(i) then mark=1;');     end;     call execute('end;where mark=1;run;');   end; run; ... View more

Well, quick and dirty method using macro: data have; infile datalines; input str $; datalines; abcdefgh bcdeghfa fghedcbb ehgbcdae ; run; proc sql;   select  LENGTH   into    :MAX_LEN   from    SASHELP.VCOLUMN   where   LIBNAME="WORK"       and MEMNAME="HAVE"; quit; %macro Parse ();   data want;     set have;     array col{&MAX_LEN.} $1.;     %do i=1 %to &MAX_LEN.;       col&i.=substr(str,&i.,1);     %end;   run; %mend Parse; %Parse; ... View more

Well, you could try the below, one thing I would check is what should happen if the code appears in more than one variable, say col1 and col2 both have 46611, should that row output twice or once?  The below outputs twice, however if you want it only once then change the if with the embedded output, to a select/when as KurtBremser has suggested.  The main perk with the below code is that it generates the code based on the data, so if you have lots of codes in a dataset, and lots of variables, the code doesn't need to change you can use that to generate the code (in this example I put the list in the do loop, however you could as easy have it in a dataset and put that I as a set). data test;   attrib code1 code2 code3 code4 format=$20.;   code1='7784'; code4='46611'; output;   code2='7784'; code4='46611'; output;   code1='7784'; code2='5990'; output; run; proc sql;   select  distinct NAME   into    :VAR_LIST separated by '","'   from    SASHELP.VCOLUMN   where   LIBNAME="WORK"       and MEMNAME="TEST"; quit; data temp;   do i= '78060','7784','4659','07999','46611','77989','5990';     call execute('data code_'||strip(i)||';                     set work.test;');     do j="&VAR_LIST.";       call execute('if '||strip(j)||'="'||strip(i)||'" then output;');     end;     call execute('run;');   end; run; ... View more

I assume you want a table where the acctid only appears in table1 not table2? proc sql;     create table anyname as   select *      from   Table1       where  acctid not in (select distinct acctid from table2); quit; Though, why do you select all table 2's variables as the point of the not in is to select data where it doesn't exist in table2. ... View more