@torvyle wrote:
How does one use this code? Is it only replacing the "/folders/myfolders" with the desired directory?
Thanks
You insert the root directories of the trees you want to search in in the DATALINES block of the first data step (replace /folders/myfolders, as that was the data directory used in the no longer available SAS University Edition).
... View more
Thank you very much, ballardw! Removal of the single quotes worked. If I were to update two variables, the code is this: data _null_;
set work.datahave end=final;
if _n_ = 1 then call execute("proc sql ;");
call execute("update work.datawant a set proc_start_date_time1="||proc_start_date_time1||" where transaction_id="||transaction_id||";");
call execute("update work.datawant a set proc_start_date_time2="||proc_start_date_time2||" where transaction_id="||transaction_id||";");
if final then call execute('quit;');
run; When I tried to update the large dataset using Call Execute the SAS server stopped around 4min mark. I'll try to get this sorted and try your data step suggestion as well.
... View more
First step: make sure your variable has a length of $5 or longer. Otherwise you need to assign the new string to a new variable.
data want;
set have;
var = cat( substr(var, 1, 1), 'K', substr(var, 2) );
run;
... View more
