https://communities.sas.com/t5/SAS-Programming/Create-a-calculated-unique-ID-in-SAS-Data-Studio/m-p/908625#M358550 <P>Do you have any special requirements when it comes to the id?</P> <P>You can use SAS functions to create a UUID (<A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0y09yghr5r11cn1b4ocojwqvrqe.htm" target="_blank">https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0y09yghr5r11cn1b4ocojwqvrqe.htm</A>), or hashing your business key column(s):</P> <P>MD5 <A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0mu81ozw0013yn1kzwve5ola26e.htm" target="_blank">https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0mu81ozw0013yn1kzwve5ola26e.htm</A></P> <P><A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p04sqiymw1a6unn1uvh943eudcvz.htm" target="_blank"><FONT color="#000000">SHA256:</FONT> https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p04sqiymw1a6unn1uvh943eudcvz.htm</A></P> <P>If you want to create a sequence no you probably need to program that yourself, or utilize SAS Studio Engineer steps.</P> <P>Or if you have an external DB, you can often define a column there with these characteristics.</P> Mon, 18 Dec 2023 15:18:21 GMT LinusH 2023-12-18T15:18:21Z https://communities.sas.com/t5/SAS-Programming/Create-a-calculated-unique-ID-in-SAS-Data-Studio/m-p/908605#M358544 <P>hello, i often use data studio to create Unique ID&nbsp; but data sudio doesn't work kike a want. I want to know if it's possible to do this in studio. And if it's ok, what is the calculated item?</P> <P>&nbsp;</P> Mon, 18 Dec 2023 15:19:53 GMT https://communities.sas.com/t5/SAS-Programming/Create-a-calculated-unique-ID-in-SAS-Data-Studio/m-p/908605#M358544 YannRC 2023-12-18T15:19:53Z https://communities.sas.com/t5/SAS-Programming/Create-a-calculated-unique-ID-in-SAS-Data-Studio/m-p/908625#M358550 <P>Do you have any special requirements when it comes to the id?</P> <P>You can use SAS functions to create a UUID (<A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0y09yghr5r11cn1b4ocojwqvrqe.htm" target="_blank">https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0y09yghr5r11cn1b4ocojwqvrqe.htm</A>), or hashing your business key column(s):</P> <P>MD5 <A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0mu81ozw0013yn1kzwve5ola26e.htm" target="_blank">https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0mu81ozw0013yn1kzwve5ola26e.htm</A></P> <P><A href="https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p04sqiymw1a6unn1uvh943eudcvz.htm" target="_blank"><FONT color="#000000">SHA256:</FONT> https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/p04sqiymw1a6unn1uvh943eudcvz.htm</A></P> <P>If you want to create a sequence no you probably need to program that yourself, or utilize SAS Studio Engineer steps.</P> <P>Or if you have an external DB, you can often define a column there with these characteristics.</P> Mon, 18 Dec 2023 15:18:21 GMT https://communities.sas.com/t5/SAS-Programming/Create-a-calculated-unique-ID-in-SAS-Data-Studio/m-p/908625#M358550 LinusH 2023-12-18T15:18:21Z