Help using Base SAS procedures

array or proc tranpose

Reply
Occasional Contributor
Posts: 14

array or proc tranpose

If i want to transpose a dataset that has millions of records which method wolud be efficient enough either a proc tranpose or arrays.

Thanks.

PROC Star
Posts: 7,468

array or proc tranpose

You have to provide more info.  How many variables before and after the desired transpose and is there a by variable.

Valued Guide
Posts: 2,177

array or proc tranpose

transpose might like to hold the entire file in memory. That will cause problems for very large data.

If you know the data structure, you are that step ahead of proc transpose and will probably make a more successful transpose in a data step.

Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 3 in conversation