in SPM GUID have the following form - 082ad130-0a08-0305-01bb-3453da1ad2cb.
I have no idea if its fully random or not, but if its random I made macro to generate it -
%macro gen(table=,rows=,seed=);
%macro mini;
%local src;
%let src=1234567890abcdefghijklmnopqrstuvwxyz_;
data tmp(keep=code);
s="&seed";
format code $36.;
format temp1 $1.;
retain code "";
do _n_ = 1 to 37;
if _n_ in (14,19,24,29) then do;
code="-"||code;
end; else do;
do i=0 to i>=1;
r1 = ranuni(s)*36;
i=r1;
end;
temp1=substr("&src",i,1);
code=temp1||code;
end;
*put _all_;
end;
call symput("temp2",code);
run;
data &table;
set tmp &table;
run;
%mend;
data &table;
run;
data _null_;
do _n_=1 to &rows;
call execute('%mini');
end;
run;
%mend;
%gen(table='gen',rows=10,seed=0);
May be someone know any other variants of random generation?
And I wait for people who worked with %SPMBMF, I need some youe experience pls)
Message was edited by: Fry
Message was edited by: Fry