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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.