topic Re: IDENTITY ou AUTOINCREMENT in SAS Programming

IDENTITY ou AUTOINCREMENT

Madrug_ — Thu, 07 Mar 2013 14:19:43 GMT

Prezados,

É possivel criar um campo auto numerado (IDENTITY) no SAS? Quais são as maneiras de fazer esse processo?

Ex:

CREATE TABLE exemplo

(

COD_CLI INT IDENTITY,

NOME VARCHAR(50),

EMAIL VARCHAR(50)

CONSTRAINT EXEMPLO_PK_COD_CLI PRIMARY KEY(COD_CLI)

);

Obrigado pela atenção!

Re: IDENTITY ou AUTOINCREMENT

TomKari — Fri, 08 Mar 2013 16:34:00 GMT

No, there is no identity option in SAS. Perhaps the undocumented monotonic() function could be useful

http://www.amadeus.co.uk/sas-technical-services/tips-and-techniques/sql/the-monotonic-function/.

Re: IDENTITY ou AUTOINCREMENT

Madrug_ — Fri, 15 Mar 2013 19:50:20 GMT

TomKari, Boa Tarde!

Eu consegui, utilizei o exemplo que você passou.

Muito Obrigado!

Re: IDENTITY ou AUTOINCREMENT

TomKari — Fri, 15 Mar 2013 22:39:16 GMT

Seja bem-vindo!

Tom

Re: IDENTITY ou AUTOINCREMENT

Madrug_ — Wed, 17 Apr 2013 15:17:32 GMT

Obrigado!

Re: IDENTITY ou AUTOINCREMENT

Ksharp — Sat, 20 Apr 2013 10:02:54 GMT

I will not ust that undocumented function for the sake of risk. I would like use ODS.

ods listing close;

ods output sql_results=want;

proc sql number;

select * from sashelp.class;

quit;

ods listing;

Ksharp

Re: IDENTITY ou AUTOINCREMENT

Madrug_ — Mon, 22 Apr 2013 14:20:24 GMT

Ksharp, Bom Dia!

Você tem um exemplo de como usar o código que você mostrou?

Ex:

PROC SQL;

CREATE TABLE MINHA_TABELA AS

SELECT * FROM TABELA_BASE;

RUN;

Re: IDENTITY ou AUTOINCREMENT

Ksharp — Mon, 22 Apr 2013 14:26:50 GMT

Please English first . I have to go to sleep now. will be back soon after a beauty sleep.

Re: IDENTITY ou AUTOINCREMENT

Madrug_ — Tue, 23 Apr 2013 18:53:30 GMT

Ksharp, Good Day!

Do you have an example of how to use the code you showed?

Ex:

PROC SQL;

CREATE TABLE MINHA_TABELA AS

SELECT * FROM TABELA_BASE;

RUN;

Re: IDENTITY ou AUTOINCREMENT

PGStats — Tue, 23 Apr 2013 19:14:32 GMT

Olá. Just follow what Ksharp wrote :

ods listing close;

ods output sql_results=MINHA_TABELA;

proc sql number;

select * from TABELA_BASE;

quit;

ods listing;

The first statement prevents the printing of query results. The second statement directs the query result to dataset MINHA_TABELA. Option number adds a column in the query result to contain record numbers. The last statement restores normal result printing.

MINHA_TABELA will contain the same columns as TABELA_BASE with an extra column for record numbers.

Re: IDENTITY ou AUTOINCREMENT

Ksharp — Wed, 24 Apr 2013 05:47:08 GMT

PG, Thanks. So detail explanation for me .

Ksharp