DATA Step, Macro, Functions and more

Process columns into observations

Reply
New Contributor
Posts: 2

Process columns into observations

[ Edited ]

Hi 

 

I am new into the SAS programming

 

Please advise how can i create the data which convert the below in 4 different columns

 

1Sep11 389.00 1Oct11 491.00 1Nov11 370.00 1Dec11 335.00
2Sep11 423.00 2Oct11 478.00 2Nov11 407.00 2Dec11 442.00
3Sep11 482.00 3Oct11 300.00 3Nov11 303.00 3Dec11 372.00
4Sep11 407.00 4Oct11 405.00 4Nov11 398.00 4Dec11 465.00
5Sep11 354.00 5Oct11 388.00 5Nov11 427.00 5Dec11 393.00
6Sep11 432.00 6Oct11 387.00 6Nov11 360.00 6Dec11 393.00
7Sep11 476.00 7Oct11 330.00 7Nov11 494.00 7Dec11 498.00
8Sep11 426.00 8Oct11 412.00 8Nov11 444.00 8Dec11 314.00
9Sep11 439.00 9Oct11 322.00 9Nov11 392.00 9Dec11 404.00
10Sep11 484.00 10Oct11 364.00 10Nov11 491.00 10Dec11 455.00
11Sep11 485.00 11Oct11 456.00 11Nov11 451.00 11Dec11 479.00
12Sep11 440.00 12Oct11 492.00 12Nov11 468.00 12Dec11 357.00
13Sep11 479.00 13Oct11 468.00 13Nov11 463.00 13Dec11 315.00
14Sep11 353.00 14Oct11 442.00 14Nov11 479.00 14Dec11 366.00
15Sep11 457.00 15Oct11 401.00 15Nov11 386.00 15Dec11 406.00
16Sep11 488.00 16Oct11 421.00 16Nov11 430.00 16Dec11 486.00
17Sep11 418.00 17Oct11 396.00 17Nov11 356.00 17Dec11 306.00
18Sep11 440.00 18Oct11 444.00 18Nov11 427.00 18Dec11 354.00
19Sep11 479.00 19Oct11 421.00 19Nov11 428.00 19Dec11 434.00
20Sep11 376.00 20Oct11 339.00 20Nov11 443.00 20Dec11 317.00
21Sep11 488.00 21Oct11 494.00 21Nov11 423.00 21Dec11 414.00
22Sep11 490.00 22Oct11 442.00 22Nov11 340.00 22Dec11 471.00
23Sep11 419.00 23Oct11 475.00 23Nov11 342.00 23Dec11 450.00
24Sep11 338.00 24Oct11 421.00 24Nov11 355.00 24Dec11 385.00
25Sep11 408.00 25Oct11 405.00 25Nov11 389.00 25Dec11 332.00
26Sep11 380.00 26Oct11 433.00 26Nov11 409.00 26Dec11 449.00
27Sep11 349.00 27Oct11 324.00 27Nov11 374.00 27Dec11 393.00
28Sep11 428.00 28Oct11 434.00 28Nov11 327.00 28Dec11 367.00
29Sep11 459.00 29Oct11 425.00 29Nov11 418.00 29Dec11 468.00
30Sep11 426.00 30Oct11 430.00 30Nov11 385.00 30Dec11 479.00

 

 

Super User
Super User
Posts: 9,838

Re: SAS

Posted in reply to Vaibhav_Kalra

Please follow some general guidance on posting a quesiton:

Provide test data in the form of a datastep - i.e. something we can run and have the data.  You can see plenty of examples on other questions or here:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

 

Next post what the output should look like, I cannot guess what it is supposed to look like?

 

Use descriptive thread titles.

Super User
Posts: 13,926

Re: Process columns into observations

Posted in reply to Vaibhav_Kalra

is that currently a SAS data set? What are the names of the variables? What are the variable types? What names do you want for the output set. And WHAT does the output look like? There are several ways your request could be interpreted and some of them could be very poor ideas.

 

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