Hello,   The program I am executing read from the dataset Dictionary.tables, several datasets and views available in the selected library but in the SAS logs there are error messages because not all the datasets behind the views could be located. ERROR: SQL View XYZ could not be processed because at least one of the data sets, or views, referenced directly (or indirectly) by it could not be located, or opened successfully.   The SAS views were created in the past years and then the datasets behind the views were moved in the backup folders and deleted from libraries. Also: tried to obtain a list of the "existing" views with proc datasets but the results are similar (ie error messages for non-existing views). tried with SAS macro function: ie %sysfunc(exist(&dsn., VIEW)), but it does not work in this case, namely the views exist. The program should be a part of a scheduled SAS job but error messages makes the program execution stops. Please, could you suggest a SAS function/proc sql statement or option that is able to prove whether a SAS view exists(aka the datasets behind the views still exist)?       ... View more

I would like to cluster a geo map using the k-means cluster algorithms, or another cluster algorithm: my scope is identify clusters based on geographical location that have similarites between a specific attribute/s: the clusters obtained are a combination of location and a KPI. There any methodology or procedure I could use in SAS? ... View more

Hi Experts, It's the first time I am working on such project and I would like some advices. The scope of the project is to extract from free-text documents street addresses, if provided in the text. I am attempting to extract street addresses from the text documents and I was thinking of using SAS Visual Text Analytics, because from the documentation, it should contain the functionality to do the task. Finally, the text documents to be analyzed are not US ones but in foreign language covered by SAS Visual Text Analytics. Do you have experiences in this regard to suggest me a feasible approach? ... View more

Hello, My question involves colors definition in a proc template for producting a clustered bars chart. Bars represent products while clusters represent years: each product has its own color and the graph shows the sales of some products across several years. In the past, I used HEX colors coding for several SAS graphs using proc sgplot with excellent results. Some examples of HEX color coding used in the past are: "#C95117" (red) or "#FAD500" (yellow). When I tried to use the hex color coding scheme in proc template I received an error message, while using the SAS color scheme the procedure runs fine. The client has a company color coding and wants the graphs to be aligned with that, so here is my question: which color coding should be used with proc template: SAS , HEX, RGB or others? Also, in the proc template I defined colors in the following way: proc template ...; ...... begingraph/ datacolors=(green yellow red) datacontrastcolors=(green yellow red); .... run; Is there another way to define colors used by a bar chart in proc template? Greeting, ... View more

Hello experts, I would like to save the output of a PROC SGPLOT/SGPANEL with a BY statement on multiple pdf pages. At present there are about 8 different categories - values of the by variable - that I would like to represent with a graph, hence using the BY statement is the easiest thing. Problem is, the pdf output stops after the first graph, namely the first value of the by variable.  I browsed a bit on communities.sas.com and saw several papers/answers about multiple graphs in a PDF page (meaning one PDF page) but my case is the opposite. As PDF output, I would like to obtain multiple PDF pages, generated by proc sgplot/proc sgpanel with a BY statement. How to save all the graphs in PDF? Kind regards ... View more