How to generate an identical random variable in sas

I want to create a variable want which is a randomly generated number following uniform distribution for dataset data. I want the number to be the same for all rows. I tried the following:

data data; set data; want = ranuni(0) ; run;

But this gives different value for each row.

I also tried to generate a macro variable then pass the value to the dataset, but I am struggling to make it work. Can anyone teach me how to do it please?

I tried the following:

%let want1= %ranuni(0) ;

I also tried:

%let want1= %eval ( ranuni(0) );



data data;

set data;

want = &want1;

run;

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

add a comment |

I want to create a variable want which is a randomly generated number following uniform distribution for dataset data. I want the number to be the same for all rows. I tried the following:

data data; set data; want = ranuni(0) ; run;

But this gives different value for each row.

I also tried to generate a macro variable then pass the value to the dataset, but I am struggling to make it work. Can anyone teach me how to do it please?

I tried the following:

%let want1= %ranuni(0) ;

I also tried:

%let want1= %eval ( ranuni(0) );



data data;

set data;

want = &want1;

run;

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

add a comment |

I want to create a variable want which is a randomly generated number following uniform distribution for dataset data. I want the number to be the same for all rows. I tried the following:

data data; set data; want = ranuni(0) ; run;

But this gives different value for each row.

I also tried to generate a macro variable then pass the value to the dataset, but I am struggling to make it work. Can anyone teach me how to do it please?

I tried the following:

%let want1= %ranuni(0) ;

I also tried:

%let want1= %eval ( ranuni(0) );



data data;

set data;

want = &want1;

run;

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

I want to create a variable want which is a randomly generated number following uniform distribution for dataset data. I want the number to be the same for all rows. I tried the following:

data data; set data; want = ranuni(0) ; run;

But this gives different value for each row.

I also tried to generate a macro variable then pass the value to the dataset, but I am struggling to make it work. Can anyone teach me how to do it please?

I tried the following:

%let want1= %ranuni(0) ;

I also tried:

%let want1= %eval ( ranuni(0) );



data data;

set data;

want = &want1;

run;

sas

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

edited Jan 1 at 16:02

asked Jan 1 at 15:56

fly36

2031312

asked Jan 1 at 15:56

fly36

2031312

asked Jan 1 at 15:56

fly36

2031312

add a comment |

2 Answers
2

active

oldest

votes

To set the same value on every observation use the RETAIN statement to prevent SAS from resetting the value when it starts the next iteration of the data step.

data want;

  set have;

  if _n_=1 then myvar = ranuni(0) ; 

  retain myvar;

run;

To use functions in macro code you need to use the %SYSFUNC() macro function.

%let mvar = %sysfunc(ranuni(0));



data want;

  set have;

  retain myvar &mvar ;

run;

answered Jan 1 at 16:11

Tom

23.7k2718

add a comment |

Use %sysfunc to code gen a fixed random number assigned within the DATA step.

data data; 

  set data;

  want = %sysfunc(ranuni(0));

run;

Here is an SQL version using the same for comparison:

proc sql;

  alter table have add want num;

  update have set want=%sysfunc(ranuni(0));

quit;

answered Jan 1 at 17:36

Richard

9,12721228

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996857%2fhow-to-generate-an-identical-random-variable-in-sas%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

To set the same value on every observation use the RETAIN statement to prevent SAS from resetting the value when it starts the next iteration of the data step.

data want;

  set have;

  if _n_=1 then myvar = ranuni(0) ; 

  retain myvar;

run;

To use functions in macro code you need to use the %SYSFUNC() macro function.

%let mvar = %sysfunc(ranuni(0));



data want;

  set have;

  retain myvar &mvar ;

run;

answered Jan 1 at 16:11

Tom

23.7k2718

add a comment |

To set the same value on every observation use the RETAIN statement to prevent SAS from resetting the value when it starts the next iteration of the data step.

data want;

  set have;

  if _n_=1 then myvar = ranuni(0) ; 

  retain myvar;

run;

To use functions in macro code you need to use the %SYSFUNC() macro function.

%let mvar = %sysfunc(ranuni(0));



data want;

  set have;

  retain myvar &mvar ;

run;

answered Jan 1 at 16:11

Tom

23.7k2718

add a comment |

To set the same value on every observation use the RETAIN statement to prevent SAS from resetting the value when it starts the next iteration of the data step.

data want;

  set have;

  if _n_=1 then myvar = ranuni(0) ; 

  retain myvar;

run;

To use functions in macro code you need to use the %SYSFUNC() macro function.

%let mvar = %sysfunc(ranuni(0));



data want;

  set have;

  retain myvar &mvar ;

run;

answered Jan 1 at 16:11

Tom

23.7k2718

To set the same value on every observation use the RETAIN statement to prevent SAS from resetting the value when it starts the next iteration of the data step.

data want;

  set have;

  if _n_=1 then myvar = ranuni(0) ; 

  retain myvar;

run;

To use functions in macro code you need to use the %SYSFUNC() macro function.

%let mvar = %sysfunc(ranuni(0));



data want;

  set have;

  retain myvar &mvar ;

run;

answered Jan 1 at 16:11

Tom

23.7k2718

answered Jan 1 at 16:11

Tom

23.7k2718

answered Jan 1 at 16:11

Tom

23.7k2718

answered Jan 1 at 16:11

Tom

23.7k2718

add a comment |

Use %sysfunc to code gen a fixed random number assigned within the DATA step.

data data; 

  set data;

  want = %sysfunc(ranuni(0));

run;

Here is an SQL version using the same for comparison:

proc sql;

  alter table have add want num;

  update have set want=%sysfunc(ranuni(0));

quit;

answered Jan 1 at 17:36

Richard

9,12721228

add a comment |

Use %sysfunc to code gen a fixed random number assigned within the DATA step.

data data; 

  set data;

  want = %sysfunc(ranuni(0));

run;

Here is an SQL version using the same for comparison:

proc sql;

  alter table have add want num;

  update have set want=%sysfunc(ranuni(0));

quit;

answered Jan 1 at 17:36

Richard

9,12721228

add a comment |

Use %sysfunc to code gen a fixed random number assigned within the DATA step.

data data; 

  set data;

  want = %sysfunc(ranuni(0));

run;

Here is an SQL version using the same for comparison:

proc sql;

  alter table have add want num;

  update have set want=%sysfunc(ranuni(0));

quit;

answered Jan 1 at 17:36

Richard

9,12721228

Use %sysfunc to code gen a fixed random number assigned within the DATA step.

data data; 

  set data;

  want = %sysfunc(ranuni(0));

run;

Here is an SQL version using the same for comparison:

proc sql;

  alter table have add want num;

  update have set want=%sysfunc(ranuni(0));

quit;

answered Jan 1 at 17:36

Richard

9,12721228

answered Jan 1 at 17:36

Richard

9,12721228

answered Jan 1 at 17:36

Richard

9,12721228

answered Jan 1 at 17:36

Richard

9,12721228

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtjtk