ReshapeLong

Creates a new dataset with multiple rows per case by assigning a set of variables in the original dataset to a single variable in the new dataset.

Properties

Name	Type		Description
MakeItems	ReshapeItemDescription	0..n	New variables created by this command.
CaseNumberVariable	string	0..1	New variable identifying the case number in the wide data that created this row.
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.
KeepNullCases	boolean	0..1	When set to TRUE, rows in which all constructed variables are missing are not deleted.
CountByID	string	0..1	New variable with the number of cases in the long dataset that were created from the source row in the wide dataset.
CountByIDLabel	string	0..1	Label for the CountByID variable.

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

• CommandBase

  • TransformBase

    • ReshapeLong

Relationships

The following identified item types reference this type.

ReshapeLong_examples

========= SPSS Example =================

varstocases
 /make name "Full Name" from named namem
 /make income from incd incm
 /index dadmom "Parent"
 /id=id1
 /drop= var88 to var99
 /null= KEEP
 /count= casecount "Number of rows from original case" .

{"command": "ReshapeLong",
    "MakeItems": [
            "ReshapeItemDescription":
                {"TargetVariableName": "name",
                "TargetVariableLabel": "Full Name",
                "SourceVariables":
                    {"$type": "VariableListExpression",
                    "Variables": [
                        {"$type": "VariableSymbolExpression", "VariableName": "named"},
                        {"$type": "VariableSymbolExpression", "VariableName": "namem"}
                        ]   },
                "IndexVariable": "dadmom",
                "IndexVariableLabel": "Parent"},
            "ReshapeItemDescription":
                {"TargetVariable": "income",
                "SourceVariables":
                    {"$type": "VariableListExpression",
                    "Variables": [
                        {"$type": "VariableSymbolExpression", "VariableName": "incd"},
                        {"$type": "VariableSymbolExpression", "VariableName": "incm"}
                        ]   },
            "IndexVariable": "dadmom"}
            ],
    "CaseNumberVariable":"id1",
     "DropVariables": [
                    {"$type": "VariableRangeExpression",
                    "First":"var88",
                    "Last":"var99"}
                    ],
    "KeepNullCases":"True",
    "CountByID": "casecount",
    "CountByIDLabel": "Number of rows from original case"
    }

============ Stata Example 1 ==================

reshape long inc ue, i(region id) j(year)

{"command": "ReshapeLong",
    "MakeItems": [
            "ReshapeItemDescription":
                {"TargetVariableName": "inc",
                "Stub": "inc",
                "IndexVariableName": "year"},
            "ReshapeItemDescription":
                {"TargetVariableName": "ue",
                "Stub": "ue",
                "IndexVariableName": "year"}
            ],
    "IDVariables": [
                {"$type": "VariableSymbolExpression","VariableName": "region"},
                {"$type": "VariableSymbolExpression","VariableName": "id"}
                ]
        }

============ Stata Example 2 ==================

reshape long inc, i(id) j(sex "male" "female") string

 {"command": "ReshapeLong",
    "MakeItems": [
            "ReshapeItemDescription":
                {"TargetVariableName": "inc",
                "Stub": "inc",
                "IndexVariableName": "sex",
                "IndexValues": [
                    {"$type":"StringListExpression",
                        "Values": [
                            {"$type": "StringConstantExpression", "Value": "male"},
                            {"$type": "StringConstantExpression", "Value": "female"}
                            ]
                        }
                    ],
                }
            ],
    "IDVariables": [
                {"$type": "VariableSymbolExpression","VariableName": "region"},
                {"$type": "VariableSymbolExpression","VariableName": "id"}
                ]
        }