This option is defined in the server-metadata and be altered by your sas-administrators only. ... View more

In the SAS-Management-Console you can export a Stored Process. This step creates a SAS Package file (name ends with spk) containg code and underlying external objects stored in WebDAV. ... View more

Hi R_Win, the following code queries sashelp.vcolumn to get the variable names and call execute to create a proc datasets with the rename statment for all variables. [pre] data _null_; set sashelp.vcolumn( keep= Name LibName MemName rename= (Name = OldName) where= (Libname='WORK' and MemName = 'A') ) end= last; length NewName $ 32; if _n_ = 1 then do; call execute('proc datasets library=work nolist;'); call execute('modify a;'); call execute('rename '); end; NewName = compress(OldName, ' '); OldName = cats("'", OldName, "'n"); call execute(trim(OldName) !! ' = ' !! trim(NewName)); if last then do; call execute(';'); call execute('run;'); end; run;[/pre] ... View more

Variables containing date-, time- and datetime-values are always integers. They look like "dates" when a format is applied to them. So adding a format to the variable containing the maximum will solve the problem. [pre]proc sql print; select max(modate) format=datetime. from sashelp.vtable; quit;[/pre] ... View more

Why do you want to convert the files? Importing the text-file by using the infile-statements' termstr-option set to crlf works like charm. ... View more

Maybe i am missing something, but sashelp.vtable seems to contain the required data: [pre] proc sql print; select sum(filesize) as SpaceUsed from sashelp.vtable where Libname = 'WORK' and MemType = 'DATA' ; quit;[/pre] pre-tags added Message was edited by: andreas_lds ... View more

SAS will use CEDA (cross-environment data access) to read/write datasets created on another plattform, resulting in an increased runtime. ... View more

Posting the code used to accomplish the task increases the chance to get useful answers. ... View more

chang_y_chung found a paper on that topic: http://support.sas.com/forums/thread.jspa?messageID=43038ꠞ ... View more

1. Create a dataset containing the charge-transaction-relationship: [pre]data work.fee; input min max charge; datalines; 1 10000 0.25 10001 25000 0.21 25001 50000 0.2 50001 . 0.18 ; run;[/pre] 2. Combine the transaction dataset with the fee dataset: [pre]data work.charged; set work.transactions; length total helper 8; retain total helper; drop helper min max charge; total = 0; helper = 0; do i = 1 to 4; set work.fee point=i; if transaction > min then do; if not missing(max) then do; total = (max - helper) * charge + total; helper = max; end; else do; total = (transaction - helper) * charge + total; end; end; end; run;[/pre] Still to do: create a macro containing the calculating data-step, with parameters for the three datasets involved. ... View more

Please don't create multiple threads for one topic. If you don't want to wait for an answer contacting SAS Tech Support is recommended. ... View more

You should explain why you think that creating that many macro variables is necessary. The macro-variables name can be created by appending the dataset variable "no" to the appropriate letter. [pre]data _null_; set yourdata; call symput(cats('A', no), amt); call symput(cats('B', no), number); run;[/pre] Message was edited by: andreas_lds ... View more

Why is macro required to solve the problem? You should post an example of the required output dataset. ... View more

MD5 is a one-way hash-function, restoring the originial value is not easy. I doubt that it can be done within SAS. More information about the md5-algorithm can be found at http://en.wikipedia.org/wiki/Md5 ... View more