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!
Hi,
There is a blog post on this topic which might help:
Thanks & kind regards,
Amir.
Hi,
There is a blog post on this topic which might help:
Thanks & kind regards,
Amir.
Closer to your Oracle anology, there is PROC SQL DESCRIBE TABLE statment, which will give you CREATE TABLE/INDEX in the SAS log.
SAS Help Center: Syntax: PROC SQL DESCRIBE Statement
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.