topic Re: Changing datatype of dataset from unspecified type to specially strutured sas dataset (EST type) in SAS Programming

Changing datatype of dataset from unspecified type to specially strutured sas dataset (EST type)

zfusfeld — Thu, 20 Jun 2024 19:17:26 GMT

I think the question is pretty self explanatory.

I have a dataset that I need to convert to a specially structured dataset for an analytic procedure I am doing (proc mianalyze). It is currently of an unspecified type, and I need to convert it to an EST type structure.

I thought it would be a simple datastep, e.g.

data cov1 type=EST;
set cov1;
run;

but this spits out a syntax error.

Can someone link to a resource on how to manipulate the dataset to be of the EST data structure?

Re: Changing datatype of dataset from unspecified type to specially strutured sas dataset (EST type)

Tom — Thu, 20 Jun 2024 19:44:56 GMT

You did not include the ( ) needed when you have dataset options.

Try:

data cov1 (type=EST);
  set cov1;
run;

Re: Changing datatype of dataset from unspecified type to specially strutured sas dataset (EST type)

mkeintz — Thu, 20 Jun 2024 20:24:01 GMT

A minor efficiency note. You don't have to copy a data set to change its type to EST. Instead you can modify the metadata for COV1 using PROC DATASETS.


proc datasets lib=work nodetails nolist;
  modify cov1 (type=EST);
quit;

Re: Changing datatype of dataset from unspecified type to specially strutured sas dataset (EST type)

zfusfeld — Thu, 20 Jun 2024 20:34:18 GMT

thanks! I also realized i could call the type in the mi analyze procedure a la

proc mianalyze data=cov1(type=EST);
modeleffects intercept x1 x2 x3;
run;