Transposing variables in specific columns before importing

[baidw002]

Can we transpose variables in a specific column say column 3 (and rename column 3 to something like new_var) before we import?

[statgeek]

It depends on the structure of the data. You cannot transpose it, but there are various ways to read files that have data across multiple lines or have multiple records that you need to combine to one. Several of these are covered in the documentation about reading in data here:

Creating multiple records from a single line of data:
https://documentation.sas.com/?docsetId=basess&docsetTarget=n068wqvbjnndvjn17mqpoxdj7te7.htm&docsetVersion=9.4&locale=en

Create single record from multiple lines of data
https://documentation.sas.com/?docsetId=basess&docsetTarget=p0s16wvzu0z9q7n0zmxia30s6qyc.htm&docsetVersion=9.4&locale=en