cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pscott
‎01-09-2017
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Arrays

by Calcite | Level 5 in SAS Procedures
‎01-04-2017 01:18 PM
‎01-04-2017 01:18 PM
Yes I have the report working properly I just need the variables to work properly! ... View more

Arrays

by Calcite | Level 5 in SAS Procedures
‎01-04-2017 12:57 PM
‎01-04-2017 12:57 PM
I have a table that loops kinda like below only with every combination of those three variables. And I would like to create a report based on every horizonal Column of that table E.g. one report would where comany = next, serial # = 965465, Tech= Superman and another where company = next , serial # = 56465, Tech = Jed.I'm not sure the best way to do this but I tried this and it failed.    data MacSerial2; set MacSerial2; do i= 1 to 5; %let Tech = Tech[i] %let targetno2 = serial#[i] %let targetno3 = company[i] end; run;     Company Serial # Tech Next 965465 Superman Next 56465 Jed Google 2463 Jed Google 1583 Justice Matt 15612 bad ... View more

Re: Transposing

by Calcite | Level 5 in SAS Procedures
‎08-09-2016 06:25 PM
‎08-09-2016 06:25 PM
Im sorry but because of security reasons I cant post exactly what the data looks like but I hope this helps. The data looks something like this;   DWID Stone1_row_1 Stone1_row_2 Stone1_row_3 Stone2_row1 Stone2_row2 Stone2_row3 1 1 3 6 3 9 9 2 2 3 3 4 8 7 3 3 5 7 3 8 4 4 4 6 3 7 7 3   And I would like it to look like this    DWID Stone_NBR Row_1 Row_2 Row_3 1 1 1 3 6 1 2 3 9 9 2 1 2 3 3 2 2 4 8 7 3 1 3 5 7 3 2 3 8 4 4 1 4 6 3 4 2 7 7 3 ... View more

Re: Transposing

by Calcite | Level 5 in SAS Procedures
‎08-09-2016 05:35 PM
‎08-09-2016 05:35 PM
Those are values, and I would like it in a data set. I would like to have the rows horizontal and the stones verticle.   Stone_nbr   row1   row2   row3  1                    3         4         5   1                    2         2         2 1 2 2 2 ... View more

Transposing

by Calcite | Level 5 in SAS Procedures
‎08-09-2016 05:21 PM
‎08-09-2016 05:21 PM
Hello,   I have sorta a complex transpose I need to do I neet to take something like this   Stone1_row_1 Stone1_row_2 Stone1_row_3 Stone2_row1 Stone2_row2 Stone2_row3   and make it look like this   Stone1_row_1 Stone1_row_2 Stone1_row_3 Stone2_row1 Stone2_row2 Stone2_row3   Does anybody know an easy way to do this.   Thanks for the help, Preston ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-09-2017 04:59 PM
Quick links