About ALEXIA1

ALEXIA1 · ‎07-17-2024

Hello, I am attempting to create a unique, random ID variable for all existing IDs within dataset y. I have played around with a bunch of code however, I get a few duplicate IDs each time. How do I transform the below code to produce a unique, random number between 1 and 10**8? I have used streaminit(1) to ensure the same random numbers are generated on each run. Data x; Set y; Call streaminit(1); ID = RAND('Integer',(10 ** 8)); Run; Thank you in advance,

ALEXIA1 · ‎12-03-2021

Hi ballardw, the dataset will later be merged to a larger dataset whereby one row exists for each ID/name. The max number of times a given ID/name combination can appear in the dataset above and future datasets is 4. The value of Topic never duplicates for a ID/Name combination. And, the order of the columns is not important. I'm expecting the code to be a big ugly but hopefully this information helps! Thanks

ALEXIA1 · ‎12-02-2021

I'm am trying to take the following dataset (for example): data test; input ID Name $ Topic A1 A2; datalines; 1 Alex 1 1 5 1 Alex 2 5 1 1 Bob 2 5 1 1 Smith 4 1 5 2 Greg 1 1 1 2 Greg 2 1 1 3 Joe 3 1 5 3 Joe 4 1 5 run; And collapse it down by ID and Name so that it looks like this (the table has been cut off but you get the idea hopefully). I am relatively new to SAS so I'm not sure what the best approach would be. I've tried transposing with no luck, as well as creating blank columns and moving the data (however this is very inefficient if you have a big dataset). Any recommendations are welcome!

Online Status	Offline
Date Last Visited	‎07-18-2024 02:20 AM

Create unique, random identifiers

Re: Flattening/Transposing a dataset

Flattening/Transposing a dataset

Create unique, random identifiers

Re: Flattening/Transposing a dataset

Flattening/Transposing a dataset