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?
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;
:
You did not include the ( ) needed when you have dataset options.
Try:
data cov1 (type=EST);
set cov1;
run;
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;
:
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.