topic Re: How to set a user-generated ID's to a set of values in ODS and Base Reporting

How to set a user-generated ID's to a set of values

deleted_user — Tue, 11 Sep 2007 19:52:01 GMT

Hi,
By making connection to a database in SAS, I can select particular columns from a table and this process continues for a set of time periods and all data is meged. Now I want to select a random generated ID's for each and every row that was selected, when I query the final data set.

How to get this?

thanks,

Re: How to set a user-generated ID's to a set of values

deleted_user — Tue, 11 Sep 2007 22:43:55 GMT

Hope I understand what your after.

One way:

DATA two;
SET one;
id = Uniform(0); * this will generate pseudo random numbers;
RUN;

* sort on the random numbers;
PROC SORT DATA=two;
BY id;

DATA three;
SET two(OBS=100); *** pick 100 "random" observations ;
RUN;

If you have the STAT package, PROC SURVEYSELECT is excellent and very versatile.
.
The above could be replaced by the following:

PROC SURVEYSELECT DATA=one METHOD=srs N=100 OUT=three;
RUN;

Re: How to set a user-generated ID's to a set of values

deleted_user — Thu, 13 Sep 2007 14:52:08 GMT

That worked, but giving random numbers.

I used id=_N_, which gave observation number as id.

thanks,

Re: How to set a user-generated ID's to a set of values

deleted_user — Thu, 13 Sep 2007 14:58:03 GMT

Also, below one worked:

id1='000'||left(put(_N_,best10.))

thanks