topic Create the dummy data for one variable in SAS Programming

Create the dummy data for one variable

meab — Wed, 16 Nov 2022 19:13:07 GMT

Hi All,

I need help with creating the dummy data for lborres variable using the attached document.

To create the dummy data for lborres below are the rules.

For lab tests with numeric result and character (TESTNAME in Test1):
1) Set non-missing lborres as blank.
2) Generate random lborres values between minimum and maximum values of unblinded ‘LBORRES’. Make sure the maximum length of LBORRES (dummy) in blinded data is same as in unblinded data.
3) If unblinded ‘LBORRES’ contains ‘<xxx’ or ‘>xxx’, randomly assign from 5% -10% blinded ‘LBORRES’ as ‘<xxx’ or ‘>xxx’.
4) If unblinded ‘LBORRES’ contains other special marks or text with no digits (if applicable), randomly assign from 5% -10% blinded ‘LBORRES’ as the special marks or text.
5) Concatenate blinded dataset for all the combinations of lab test.

For lab tests with character result (TESTNAME equal Test2):
1) Set non-missing ‘LBORRES’ as blank.
2) Generate random ‘LBORRES’ values of ‘negative’ or ‘positive’. Make sure the maximum length of LBORRES (dummy) in blinded data is same as in unblinded data.

i didn't used rand function much, i tried some ways it didn't worked. Can you please help with this one.

Thank You.

Regards,

Bhavani.

Re: Create the dummy data for one variable

PaigeMiller — Wed, 16 Nov 2022 20:43:18 GMT

Please show us what you have tried so far.

Also, most of us will not accept data in Excel files, we need data presented as working SAS data step code, which you can type in yourself or follow these instructions.

And I don't understand any of the steps you have there, starting with this one:

"1) Set non-missing lborres as blank."

Makes no sense to me. So please explain this one (and all the others as well) and show us the code you have tried. What does any of this have to do with dummy variables, which are mentioned in your title and some places in your text, but the instructions of the 5 steps don't seem to be creating dummy variables.

Re: Create the dummy data for one variable

meab — Wed, 16 Nov 2022 20:47:35 GMT

added the code to attachment.

Re: Create the dummy data for one variable

meab — Wed, 16 Nov 2022 20:51:32 GMT

need to replace the data is LBORRES field with dummy data. the rules for creating the dummy data in specified in my first post.

Re: Create the dummy data for one variable

PaigeMiller — Wed, 16 Nov 2022 22:11:41 GMT

As I (and many others) will not or cannot download attachments, please post the code in your reply by copying and pasting the code into the window that appears when you click on the "Little running man" icon. Also, please provide a portion of your data as I explained.