Check there is fix available on SAS Site for this:   http://support.sas.com/kb/62/655.html ... View more

Hi Michael,   If I'm not mistaken, READBUFF & BUFFSIZE (SQL PASS Through Option) are related to the -MEMSIZE option allocated to your SAS session, right? If you increase these options READBUFF & BUFFSIZE, without increasing the -MEMSIZE then you are likely to see decremented performance, after all, these options affect he amount of records you are placing in memory in every fetch operation from the database. It's no difference in concept when dealing with sorting large data set or even summarizing a data set, having the optimum -memsize & -sortsize option values affect your SAS performance.   Just my 2 cents, Ahmed ... View more

No problem. There is one significant advantage to not using signon scripts - you don't need to support and maintain them.   We've just started using SAS/CONNECT again ourselves to communicate between SAS BI and SAS VA. We have it configured so you just use the SIGNON statement and nothing else. There is no script and it uses Windows Authentication so you don't need to supply a user or password either. Simple is good! ... View more

Thanks for the suggestion. I've searched the WebDav Server and I didn't find any vdb-query files. I could see the SAS Visual Analytic Reports(2G).   I've searched in:http://mywebserver.com:7980/SASContentServer/   Am I missing something here? Thanks. Regards, Berry ... View more

did you try to suppress information of SAS log, like that: options nosource nonotes errors=0; <...your code...> options source notes; ???     let me know have a nice day   MC ... View more

1) For SAS programs there's a Code Importer wizard that is creating job and table metadata objects for you. Usually it requires some manual post processing to look good. 2) To import metadata from other vendors than DAD you use the Meta Data Bridges add on product. I couldn't find Btrieve as a supported interface there, but perhaps you can explore another option for interchange of metadata? But as @MT1985 says, you need to describe in more detail what those files are. ... View more

i find a usefull introduction to topic:. http://www2.sas.com/proceedings/sugi31/176-31.pdf and http://www.sascommunity.org/wiki/Tips_for_sas_programming_with_ultraedit hope this help ... View more

I think for a twisted work-around: 1. - make a StoredProcess that call another with the dynamic prompt; 2 - the first STP create Metadata table (http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/viewer.htm#a003114179.htm ) before the second STP run; 3 - when Second STP run can read values for table in the dynamic prompt; 4 - before Endind of second STP delete metadata table (http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/viewer.htm#a003114182.htm)   you can try to put the creation of metadata table at the beginning of the STP, and the delete after, but i don't test it and i think that can be an ERROR.   hope this help sorry but i didn't have a simple way have nice day MC   ... View more

did you try the PCFILES libname options: MIXED=YES or  MIXED_DATA=YES or MIXED_DATATYPE ? i found this SUGI PDF a good guide to start.   hope this help let me know have a nice day   MC ... View more

you can find information about rolling regressin in SAS: http://www.lexjansen.com/nesug/nesug07/sa/sa04.pdf http://www.sas-programming.com/2011/08/rolling-analysis-of-time-series.html http://www.lexjansen.com/nesug/nesug12/fi/fi08.pdf   the procedure can be: Proc FCMP Proc REG   hope this help have nice day let me know MC ... View more

i don't understand very well your question, but:   If i read the tile of your topic i can say refresh metadata's table and the new variable appear in SAS VA. if i read your topic i think you can make a stored procedure in SAS Enterprised Guide and realese to your users the functionality. In this way people can use a task without see the code. let me know have a nice day ... View more