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: 
cmurugesan
‎03-16-2020
  • 9 Posts
  • 5 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: SAS Visual analytics 7.4 - DATA Explorer - Missing

by Fluorite | Level 6 in New SAS User
‎12-23-2019 04:57 PM
‎12-23-2019 04:57 PM
Sure. i will check and update..thanks ... View more

Re: SAS Visual analytics 7.4 - DATA Explorer - Missing

by Fluorite | Level 6 in New SAS User
‎12-23-2019 02:44 PM
‎12-23-2019 02:44 PM
my roles are I have the above roles but when I check the reporting site. is there anything else I need to check?   ... View more

Re: SAS Visual analytics 7.4 - DATA Explorer - Missing

by Fluorite | Level 6 in New SAS User
‎12-19-2019 02:18 PM
‎12-19-2019 02:18 PM
Thanks a lot for your response! Let me check that ... View more

SAS Visual analytics 7.4 - DATA Explorer - Missing

by Fluorite | Level 6 in New SAS User
‎12-19-2019 01:12 PM
‎12-19-2019 01:12 PM
Hi All, New to SAS report world, After logged into SAS Visual analytics UI, I am able to see "Report Designer", "Data Preparation" but missing "Data explorer" is it something with privilege/permission Or I need to set up anything for Dashboard display ... View more

Re: SAS Beginer- issues with Join statemet in proc sql

by Fluorite | Level 6 in New SAS User
‎07-29-2019 06:00 PM
1 Like
‎07-29-2019 06:00 PM
1 Like
like @Kurt_Bremser said, there is duplicate "FROM" clause in the join. ... View more

Re: How surrogate key generator works with (option: increment from max...

by Fluorite | Level 6 in SAS Data Management
‎07-19-2019 11:59 AM
‎07-19-2019 11:59 AM
Thanks @Patrick @LaurieF    The online help in DI Studio provides a bit more information: ... View more

Re: How surrogate key generator works with (option: increment from max...

by Fluorite | Level 6 in SAS Data Management
‎07-18-2019 11:53 PM
‎07-18-2019 11:53 PM
@LaurieF thanks Lauri you brought up a good point. yes, it is indexed key column but still referring sequence is a faster way than going to table/index.   it would be great referring sequence if we want to load input files in parallel to the same target table. it is surprising to me why SAS not having an option to refer sequence for key generator.       ... View more

How surrogate key generator works with (option: increment from maximum...

by Fluorite | Level 6 in SAS Data Management
‎07-18-2019 01:12 PM
‎07-18-2019 01:12 PM
Dear All, I am new to SAS world and have little experience in Oracle. Based on my oracle experience it is better to use sequence for any number (key) field as the sequence saves the current value and next value.   When I see below options in "Surrogate key generator" (DI studio)   1) increment from maximum value in target table 2)increment from specified value 3)increment based on another table   My system loads millions and millions of data daily. What I read from option 1 as "select max value from dim_tab" before proceeding the number generation. isn't it performance issue when I have millions (approx 100 million records)?     ... View more

Re: Slow Performance on Oracle Partitioned Table

by Fluorite | Level 6 in SAS Data Management
‎07-16-2019 06:05 PM
‎07-16-2019 06:05 PM
It might be late response.  Faced the same kind of issue in Oracle query when dealing with Partition.   TRN.date_key between 20180105 and 20180520 --> might cause full table scan.   use in clause by mentioning date key (dkey1,dkey2..etc). might help     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-16-2020 07:29 PM
Likes given to
Likes from
View All
Quick links