I am looking for the information related to the flow, under scheduler manager option in SAS Management Console.   Were you ever able to find this information in metadata? ... View more

Use OS command ( LS or DIR ) to get these CSV pathname . And;   data have; input fname $80.; infile dummy filevar=fname end=last truncover dsd ; do while(not last);   input x1 x2 x3 x4 .....;   output; end; cards; C:temp\00001\x.csv C:temp\00002\x.csv .............. ; ... View more

A view does not contain data. It is simply the recipe to generate the data. So, yes, the data retrieved when calling the view is always up to date. ... View more

Pretty sure that's now a SQL update error, which I don't know how to resolve. I would suggest trying a simpler query to ensure that updates are occurring and then once you know it can be done, fine tuning your SQL query to get it working as desired. ... View more

What you're doing here is conditional formatting based on a a specific value of Floor it seems? You need to uniquely identify the groups somehow. This seems to work for your example data. I suspect it may not work for your real data if you've oversimplified your example data set.   data dattrmap; set want; value=Floor; length FILLCOLOR $8; id = 'floor'; if Floor='Floor 2' then FILLCOLOR= 'Red'; else FILLCOLOR='Green'; output; keep id value fillcolor; run; proc sort data=dattrmap; by ID; run; TITLE &titlstuf "Number of Falls (Last 7 Days)"; proc sgplot data=want dattrmap=dattrmap noautolegend noborder nowall ; ods graphics / noborder; Hbar Floor/response=Fall7 group= floor groupdisplay=cluster attrid=floor dataskin=crisp fill ; run; ... View more