topic Re: Converting a sas dataset to a description file (like sql) in SAS Programming

Converting a sas dataset to a description file (like sql)

W1ndwaker — Thu, 21 Sep 2023 09:13:11 GMT

Hello all,

i'm trying to figure out if it's possible to convert a dataset file, for example, like this:

Example.sas7bdat

col1 | col 2

a | b

a1 | b1

into a description file, like you do with oracle, that would look like a datastep proces;

data example;

attrib col1 format=$4.;

attrib col2 format $4.;

col1=a;

col2=b;

output;

col1=a1;

col2=b1;

output;

run;

is it possible to create this kind of description file form a dataset with a procedure?

thanks!

Amir — Thu, 21 Sep 2023 10:08:27 GMT

Hi,

There is a blog post on this topic which might help:

Thanks & kind regards,

Amir.

LinusH — Thu, 21 Sep 2023 10:36:25 GMT

Closer to your Oracle anology, there is PROC SQL DESCRIBE TABLE statment, which will give you CREATE TABLE/INDEX in the SAS log.

W1ndwaker — Thu, 21 Sep 2023 10:47:18 GMT

Hi!!

have to say this is very much what i wanted, thanks for the enlightnement!

W1ndwaker — Thu, 21 Sep 2023 10:48:03 GMT

i will combine the precedure below with the describe to create the table and then if it has indexes it will be recreated too automatically.