You have tried using a loop? [pre]%let varCount = 10; %do i = 1 %to &varCount; %local x&i; %end;[/pre] ... View more

If "col_ins_id" is a dataset variable, then using cat can help. [pre]call execute(cats('%EDC(THICK,' col_ins_id, ')');[/pre] ... View more

Using proc transpose requires the data to be sorted by acct_num. [pre]data work.long; input acct_num asset_num; datalines; 1 1 1 2 1 3 1 4 2 5 2 6 2 7 2 8 2 9 3 10 3 11 ; run; proc transpose data=work.long out=work.wide(drop=_name_) prefix=asset_num; by acct_num; var asset_num; run;[/pre] ... View more

Maybe this helps: [pre] %macro filter(ages=); %local datasetPostfix; %let datasetPostfix = %sysfunc(compress(&ages, %str( ))); data work.Class&datasetPostfix; set sashelp.class; where age in (&ages); run; %mend; %filter(ages=13 15);[/pre] Works as long as you pass at least one value. ... View more

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