topic Using Loop to create data columns in SAS Procedures

Using Loop to create data columns

jerry898969 — Tue, 24 Aug 2010 14:59:13 GMT

I need to create a data set from scratch.

I need to create some year columns that goes from 1999-2003 then skips a year till 2007.

My data set should look like this
y1999 y2000 y 2001 y2002 y2003 y2005 y2007

Is this possible?

I'm not sure if this is the correct path to take but I have a table that has a variable that has all the years for a product. Some products have some of the years and some have all. I'm trying to find the best way to display that data in a matrix.

Thank you for your help

Re: Using Loop to create data columns

sbb — Tue, 24 Aug 2010 15:12:37 GMT

Look at PROC TRANSPOSE to convert a "vertical" observation oriented SAS file to a "horizontal" column oriented SAS file.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

proc transpose site:sas.com

Re: Using Loop to create data columns

Peter_C — Tue, 24 Aug 2010 15:37:04 GMT

creating the columns needs no loop, just a simple statement like:[pre] length y1999 -y2003 y2005 y2007 ;[/pre]defines the columns but does not dynamically construct or fill the columns based on the data. For that, use Scott's method - proc transpose

good luck
peterC

Re: Using Loop to create data columns

jerry898969 — Tue, 24 Aug 2010 15:46:15 GMT

Thank you both so much for all your help.

The length statement did what I wanted. Thanks

The proc tranpose actually corrected a different issue I was having.

Thanks again for the quick and awesome help.