Hello Peter, I'm trying to create the dateformat to monthday. Can I still have it like a datevariable? I tried to calculate it and put in a character format but then the sorting is not correct anymore. If you want, you can show me a sample. Thanks, Filip Here is a sample of my data: ... View more

Thanks, is it also possible with a treemap and a crosstab? ... View more

Thanks all for your help. data all_data; set TEMP.TABLE_PGM_CONTENTS_COMMENTS; run; proc sort data=all_data; by pgm_sas line_nr; run; proc sql; create table allLibnames as select distinct libname from sashelp.vlibnam where libname ne "WORK"; run; data allLibnames; set allLibnames; lengthlib = length(libname); run; proc sort data=allLibnames; by lengthlib; run;   proc sql;   select strip(libname) into:all_libs SEPARATED BY "#"  from alllibnames; quit; %macro loopLibname; %let count = 1; data Result; format library $8.; set all_data; %let lib=%scan(&all_libs,&count,%STR(#)); %do %while (&lib ne); if index(upcase(pgm_line) , "&lib") and index(upcase(pgm_line) , "*") and not index(upcase(pgm_line) , "/*")  and not index(upcase(pgm_line) , "(*)")  and not index(upcase(pgm_line) , "JOB")  and not index(upcase(pgm_line) , "SCD2")  and not index(upcase(pgm_line) , "/")  then library  = "&lib"; %let count=%eval(&count+1); %let lib=%scan(&all_libs,&count,%STR(#)); %end; if library ne ""; run; %mend; %looplibname; proc sort data=result nodupkey; by  pgm_sas library; run; data TEMP.LIBRARIES_PER_JOB; set result(keep=pgm_sas library); run; ... View more

Thanks for your replies. I have tried your suggestion Patrick but it seems it throws out the table does not include the big parts which are commented. ... View more

No: my question is the following: I want a list of all libraries used in each job. How I was working now: - librariers are pre-assigned - we have a list of all the code in one table I make a list of all libraries available, and i will loop them one by one. I check if the library can be found in each record of the table with the complete code If so, i create a field with the name of the library and i set it to 1. I hope it is more clear now ... View more

Im trying to find the libraries with the index function ... View more

We have SAS DI 4.21 I think static. I have a table with all lines of code. I'm trying to loop through all the libraries and find with index if it is used. There are better ways probably. ... View more

I'm sorry. I'm coming closer. The variable jaar is in the macro variable &var_class which defines all of my class variables. On basis of Type i want to color a row red , or green. Can I manage this with <parent> or am i wrong? proc format;     value $type 'D'='Green'                 'T'='Red'; run; ods listing close;                                                                      ods html file=_webout (title="Gevangenisarbeid") style=sasweb/*stylesheet=(URL="\\spvsasbi005.intra.just.fgov.be\D\bi_dwh\Epi\Cdrga-scrtp\uds\data\style.css")*/; PROC TABULATE data=table_result ;  CLASS &vars_class type / MISSING ; classlev type   / s={background=$type.}; VAR sumtotaal gedetineerde; TABLE &vars_table * type, jaar = 'Jaar' * (sumtotaal gedetineerde) ; LABEL sumtotaal='Totaal' gedetineerde='# gedetineerden'; RUN; ods html close; ... View more