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: 
Shiring
‎07-29-2016
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-28-2016 02:50 PM
‎07-28-2016 02:50 PM
Hi, Ksharp, Thank you for your response! However, A & B are columns from data files. when I try to replace A and B using libname.dataname--there are syntax errors. Also, lib.data2 include B but also other variables that's not in the variable --how  can I address that?  Moreover, for my table A : it's 4*8 b/c there are only 4 types. for my table B: there are 500k rows while each row has a type in the type column, thus the dimension is 500k*length(duration). Is there still a way to calculate it? ... View more

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-27-2016 11:02 AM
‎07-27-2016 11:02 AM
IML coding would be very helpful since I just got the package but have no idea how to code. Do I have to have my matrix to be one to one corresponding tho? Is there a way for matrices to auto-search (to match up the type) and directly compute?   Thank you so much for your help! ... View more

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-20-2016 06:12 PM
‎07-20-2016 06:12 PM
our corporate app database have multiple SAS parts, including SAS IML, but I only downloaded the prereq part. My dataset has about 100,000 data points, and we are thinking about expand it further. Right now I am running the multiplication on type, then I need to run it again with gender, length, death tables. so dataset B stays the same, but A changes according to how we partition. Thank you for your input! ... View more

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-20-2016 05:06 PM
‎07-20-2016 05:06 PM
I'm downloading IML right now. How to temporarily load a multidimensional array? I just transferred into SAS yesterday from R, so super unfamiliar with the syntax ... View more

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-20-2016 04:54 PM
‎07-20-2016 04:54 PM
Instead of doing a loop, are there faster ways to do this? My dataset is quite large, and I actually have multiple table As (different characteristic functions I need to apply to dataset B). So would it be possible to single out the dur array and compute without sorting, merging, or looping? Thank you so much! ... View more

Re: Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-20-2016 02:26 PM
‎07-20-2016 02:26 PM
I keep getting this error message: ERROR: BY variables are not properly sorted on data set tableB. My type is character variable b/c it's actually different names. Is that why? ... View more

Multiplication of tables

by Calcite | Level 5 in SAS Programming
‎07-20-2016 01:55 PM
‎07-20-2016 01:55 PM
Hi,   I have two SAS tables: A type Dur1 Dur2 Dur3 1       .1      .2       .4 2       .4       .3       0   B ....type Dur1 Dur2 Dur3 Dur4 Dur5.... .... 1       8       3      3       9        4      ..... ...  2       8       4      3       9        4      ......   I want to create a new table C with the following feature: when type = i in B, use the correponding line in A to multiply and apply the last rate (in this case, Dur3's rate) to all the coloumns pass the matching columns. i.e.  for the 1st line in B, C would be ....type Dur1 Dur2 Dur3 Dur4 Dur5.... .... 1     8*.1   3*.2  3*.4    9*.4   4*.4      .....         Also, I would like to change the column names in C--how can I do that in the process of multiplication? Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-29-2016 03:12 PM
Quick links