ReshapeWide

ReshapeWide is not supported in the current version of SDTL, because it depends on values in the data. However, it may be useful when values of the index variable are available in the metadata file or the data can be processed.

Properties

Name Type   Description
MakeItems ReshapeItemDescription 0..n New variables created by this command.
IDVariables VariableReferenceBase 0..1 One or more variables identifying unique rows in the wide data.
DropVariables VariableReferenceBase 0..1 Variables to be dropped from the new dataset.
KeepVariables VariableReferenceBase 0..1 Variables to be kept in the new dataset.

Properties Inherited from TransformBase

Name Type   Description
ProducesDataframe DataframeDescription 0..n Signify the dataframe which this transform produces.
ConsumesDataframe DataframeDescription 0..n Signify the dataframe which this transform acts upon.

Properties Inherited from CommandBase

Name Type   Description
Command string 1..1 The type of command
SourceInformation SourceInformation 0..n Information about the source of the command.
MessageText string 0..n Adds a message that can be displayed with the command.

Item Type Hierarchy

Relationships

stub

ReshapeWide_Stata_Examples

Example 1: ``` reshape wide inc ue, i(region id) j(year)

{“command”: “ReshapeWide”,
“MakeItems”: [
“ReshapeItemDescription”:

{“$type”: “ReshapeItemDescription”, “SourceVariableName”: “inc”, “Stub”: “inc”,

“IndexVariableName”:”year”,

“IndexValues”: {“$type”:”NumberRangeExpression”,

“From”: “80”, “To”: “83”, “By”: “1”}

},

“ReshapeItemDescription”:

{“$type”: “ReshapeItemDescription”, “SourceVariableName”: “ue”, “Stub”: “ue”, “IndexValues”: {“$type”:”NumberRangeExpression”,

“From”: “80”, “To”: “83”, “By”: “1”}

}

],

“IDVariables”: [
{“$type”: “VariableSymbolExpression”,”VariableName”: “region”}, {“$type”: “VariableSymbolExpression”,”VariableName”: “id”} ],

}

```

Long format Centre MetricTable QMetric Status Records PX001 RawCombinedResidencyfile Starts legal 50 PX001 RawCombinedResidencyfile Starts illegal 10 PX001 RawCombinedResidencyfile Transitions legal 57 PX001 RawCombinedResidencyfile Transitions illegal 3 PX001 RawCombinedResidencyfile Ends legal 60 PX001 RawCombinedResidencyfile Ends illegal 0 PX001 RawCombinedResidencyfile SexValues legal 60 PX001 RawCombinedResidencyfile SexValues illegal 0 PX001 RawCombinedResidencyfile DoBValues legal 60 PX001 RawCombinedResidencyfile DoBValues illegal 0

Wide format Centre MetricTable QMetric Illegal Legal PX001 RawCombinedResidencyfile Starts 10 50 PX001 RawCombinedResidencyfile Transitions 3 57 PX001 RawCombinedResidencyfile Ends 0 60 PX001 RawCombinedResidencyfile SexValues 0 60 PX001 RawCombinedResidencyfile DoBValues 0 60 ```

Stata: reshape wide records, i(Centre MetricTable QMetric) j(Status)

``` {“command”:”ReshapeWide”,

“MakeItems”:[

“ReshapeItemDescription”: {“SourceVariableName”:”Records”,

“Stub”:””, “IndexVariableName”:”Status”, “IndexValues”: {“$type”:”StringListExpression”,

“values”:[ “illegal”, “legal”] } }

],

“IDVariables”:[
{“$type”: “VariableSymbolExpression”,”VariableName”:”Centre”}, {“$type”: “VariableSymbolExpression”,”VariableName”:”MetricTable”}, {“$type”: “VariableSymbolExpression”,”VariableName”:”QMetric”} ]

}

```