DATA Step, Macro, Functions and more

Create indexed table

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Create indexed table

Hi,

I was wondering if it is possible to create a table based upon an other table and add an index immediatly?


basic Table_test

Naam

Key

Blabla

Boemboem

Jos

125634

Dq

Sddsf

Jos

125634

Cxc

Ffdfd

Maie

159631

Dsdjk

Jkhjk

Marius

178963

Sdsd

Ssds

Aline

345678

Dsdsdsdi

Ioyoyo

Aline

345678

Sdsds

Sdsdsd

Marc

456789

Szaéz

Azaz

Marc

456789

Sdsi

uuii

Result I would like to have.

Table_result

Id

Key

1

125634

2

159631

3

178963

4

345678

5

456789

PROC SQL;

   CREATE TABLE Table_result AS

   SELECT DISTINCT t1.Key

      FROM Table_test t1;

QUIT;


Accepted Solutions
Solution
‎09-02-2014 07:01 AM
Trusted Advisor
Posts: 1,228

Re: Create indexed table

data want (keep=id key);

retain id;

set have;

by key;

if first.key then id+1;

if first.key;

run;

View solution in original post


All Replies
Super Contributor
Posts: 308

Re: Create indexed table

Hello,

Just add within the proc sql the create index line:

PROC SQL;

   CREATE TABLE Table_result AS

   SELECT DISTINCT t1.Key

      FROM Table_test t1;

     create index key on Table_result;

QUIT;

Occasional Contributor
Posts: 14

Re: Create indexed table

If I add the create index key I get this result

Table_result

Key

125634

159631

178963

345678

456789

Solution
‎09-02-2014 07:01 AM
Trusted Advisor
Posts: 1,228

Re: Create indexed table

data want (keep=id key);

retain id;

set have;

by key;

if first.key then id+1;

if first.key;

run;

Occasional Contributor
Posts: 14

Re: Create indexed table

Thanks

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 213 views
  • 0 likes
  • 3 in conversation