About lapetitemaman

lapetitemaman · ‎08-22-2022

This data set shows results from 3 replications. Each replication contains 3 observations. I am testing my code before I increase the number of replications but haven't been successful.

lapetitemaman · ‎08-22-2022

Thank you so much for your help. I did not know that I can paste code into a code box here. I will do that in the future. For this sample run, I only set 50 replications (but I only used 3 in the data example here). I have tried your code but all the 'replicate' variable is 1 instead of 1, 1, 1, 2, 2, 2, 3, 3, 3. Is there something that I have missed? Thanks again.

lapetitemaman · ‎08-22-2022

Greetings everyone, I have a data set that is generated from replications and I need to add a replication number to each set. data have; input entrynumber var1 var2; cards; 1 -1.189 -2.655 2 -0.735 -1.896 3 0.452 0-0.984 1 -0.291 1.998 2 0.003 -0.015 3 1.267 2.974 1 0.192 -0.523 2 -1.715 -0.569 3 2.876 1.998 ; data need; input entrynumber var1 var2 replication; cards; 1 -1.189 -2.655 1 2 -0.735 -1.896 1 3 0.452 0-0.984 1 1 -0.291 1.998 2 2 0.003 -0.015 2 3 1.267 2.974 2 1 0.192 -0.523 3 2 -1.715 -0.569 3 3 2.876 1.998 3 ; How do I achieve this? Do I use do loop? Any input will be greatly appreciated.

lapetitemaman · ‎06-07-2022

Thank you for sharing your code. Somehow I was not able to get the data as shown. My actual ItemIDs are longer, more like I45609, I46874, etc. and they are not in sequential order (could this be the problem?). Somehow I got the item IDs listed as I45609AB, I45609ABC, I45609ABD, I45609ABE, etc. and the dummy code did not work correctly.

lapetitemaman · ‎06-07-2022

Greetings everyone, I have an exam dataset for multiple response items but need to separate each option and transpose the dataset from long to wide then dummy code each option. Not all examinees answered all questions. Item1 and Item2 have 5 options (2 correct answers) while Item3 has 6 options (3 correct answers). How do I achieve this? Any help is much appreciated. data exam; input ID $ ItemID $ Response $; cards; 1 Item1 BC 1 Item3 ACD 2 Item1 CD 2 Item2 AC 2 Item3 BCD 3 Item1 AB 3 Item2 BD 4 Item2 CE 4 Item3 ABF 5 Item1 AE 5 Item2 BD 5 Item3 BEF ; data need; input ID $ Item1A Item1B Item1C Item1D Item1E Item2A Item2B Item2C Item2D Item2E Item3A Item3B Item3C Item3D Item3E Item3F; cards; 1 0 1 1 0 0 . . . . . 1 0 1 1 0 0 2 0 0 1 1 0 1 0 1 0 0 0 1 1 1 0 0 3 1 1 0 0 0 0 1 0 1 0 . . . . . . 4 0 0 1 0 1 . . . . . 1 1 0 0 0 1 5 1 0 0 0 1 0 1 0 1 0 0 1 0 0 1 1 ;

lapetitemaman · ‎06-03-2022

Thank you!

lapetitemaman · ‎06-03-2022

Hello everyone, I have a dataset for an exam but need to reformat them from long to wide with specific variable names and dichotomizing all options. I can recode the answers with if then statements but it gets too long for a long test (like over 150 items). How do I achieve this through array and do loop? Thank you very much in advance! data example; input ID $ measure Item1 $ Item2 $ Item3 $; cards; 1 -1.26 B D A 2 -0.49 A C D 3 1.58 B D A 4 0.69 C D A 5 -0.63 A C B ; data want; input ID $ measure I1A I1B I1C I1D I2A I2B I2C I2D I3A I3B I3C I3D; cards; 1 -1.26 0 1 0 0 0 0 0 1 1 0 0 0 2 -0.49 1 0 0 0 0 0 1 0 0 0 0 1 3 1.58 0 1 0 0 0 0 0 1 1 0 0 0 4 0.69 0 0 1 0 0 0 0 1 1 0 0 0 5 -0.63 1 0 0 0 0 0 1 0 0 1 0 0 ; Variable names basically use I (for item) and 1 as the first item, then the options A, B, C, D. For answer A, it becomes 1 0 0 0, answer B is 0 1 0 0, etc. for a particular item.

lapetitemaman · ‎03-28-2022

I had to set up a dataset this way in order to properly run in another program.

lapetitemaman · ‎03-28-2022

These are all character variables. I am not sure why there are spaces. I am new to this forum and still learning how to post questions.

lapetitemaman · ‎03-28-2022

Thank you! This worked. I have tried to use array but couldn't get my code to work properly. Thanks again!

lapetitemaman · ‎03-25-2022

data want; set data example; if Item105 in (' ', '.') then Item105='-1'; if Item124 in (' ', '.') then Item124='-1'; run;

lapetitemaman · ‎03-25-2022

Hello, fellow SAS users, I have a large dataset with many blank values. I need to replace the blank values with -1. I use the following code but it only changes one variable at a time. I am wondering if someone could help me out with this. Thank you so much! data example; input ID Item105 $ Item124 $ Item192 $ Item020 $ Item 005 $ Item 041 $ Item225 $ Item308 $; datalines; 001 A . B 1 . 0 C A 002 B D A 0 0 . . C 003 . A C . . 1 B . 004 C C . . 1 0 A C 005 B . D 0 0 1 . . ; data want; input ID Item105 $ Item124 $ Item192 $ Item020 $ Item 005 $ Item 041 $ Item225 $ Item308 $; datalines; 001 A -1 B 1 -1 0 C A 002 B D A 0 0 -1 -1 C 003 -1 A C -1 -1 1 B -1 004 C C -1 -1 1 0 A C 005 B -1 D 0 0 1 -1 -1 ; This code works but I have over 1000 variables. data want; set data example; if Item105 in (' ', '.') then Item105='-1'; if Item124 in (' ', '.') then Item105='-1'; run;

lapetitemaman · ‎03-07-2022

The reason I used transpose to get this file is because I had a transposed response file and these two files need to match (in terms of item order, examinee ID order). I wish the item order followed a constant value... Thank you for the help.

lapetitemaman · ‎03-07-2022

The example file is what I have obtained after transposing another file. There is no transposing here. The values A, B, C, D, and 1 are the correct answers (or key) and each ID were administered different items. The values I want are only one row of values (with no missing value) that I can use as the key file for another program. I can change and rename the first variable after I obtain one row of values.

lapetitemaman · ‎03-07-2022

Sorry, Item789 should be Item789 $.

Online Status	Offline
Date Last Visited	‎05-06-2025 10:34 AM

Re: How do I create a replication number to a loop variable?

Re: How do I create a replication number to a loop variable?

How do I create a replication number to a loop variable?

Re: How to transpose multiple response data from long to wide and dumm...

How to transpose multiple response data from long to wide and dummy co...

Re: How to reformat data from long to wide with dichotomizing and spec...

How to reformat data from long to wide with dichotomizing and specific...

Re: How to replace a blank value with -1

Re: How to replace a blank value with -1

Re: How to replace a blank value with -1

Re: How do I create a replication number to a loop variable?

Re: How do I create a replication number to a loop variable?

How do I create a replication number to a loop variable?

Re: How to transpose multiple response data from long to wide and dumm...

How to transpose multiple response data from long to wide and dummy co...

Re: How to reformat data from long to wide with dichotomizing and spec...

How to reformat data from long to wide with dichotomizing and specific...

Re: How to replace a blank value with -1

Re: How to replace a blank value with -1

Re: How to replace a blank value with -1

Re: How to replace a blank value with -1

How to replace a blank value with -1

Re: Obtaining a row of key from a transpose file

Re: Obtaining a row of key from a transpose file

Re: Obtaining a row of key from a transpose file