- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
:
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set
Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets
--------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You did not include the ( ) needed when you have dataset options.
Try:
data cov1 (type=EST);
set cov1;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
:
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set
Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets
--------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;