Can you please let me know how to export "Variable View" data into a rdbms table ?
This topic has been locked.
Pinned topic Export variable view data into a rdbms table
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
SystemAdmin 110000D4XK2077 Posts
Re: Export variable view data into a rdbms table2013-02-01T15:05:15ZThis is the accepted answer. This is the accepted answer.It isn't practical to export Variable View into a single table, because it is not rectangular. Since each variable can have a varying number of missing value codes, value labels, and custom attributes, you would need a more complicated structure unless you shove all these values together into a single field with some reserved character as a separator or you create a row in the table for each value label etc for each variable, which would be very denormalized.
However, all the metadata, i.e., the contents of Variable View, can be accessed with Python code, so you could then build Statistics datasets for the components are write these to a set of database tables.