BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Cruise
Ammonite | Level 13

@Kurt_Bremser

PROC SETINIT;RUN;
Original site validation data
Current version: 9.04.01M3P062415

 

Given with "where" condition, I have 116 death_of_diagnosis_mm=99. After run with rand("INTEGER", death_of_death_mm) those 119 missing values are simply replaced by .

Strange.

Kurt_Bremser
Super User

@Cruise wrote:

@Kurt_Bremser

PROC SETINIT;RUN;
Original site validation data
Current version: 9.04.01M3P062415

 

Given with "where" condition, I have 116 death_of_diagnosis_mm=99. After run with rand("INTEGER", death_of_death_mm) those 119 missing values are simply replaced by .

Strange.


Since INTEGER does not work, the function call creates a missing value. That's clear from the log.

Use UNIFORM instead, that has been around since the beginning of rand().

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • 7779 views
  • 2 likes
  • 4 in conversation