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: 
Rahul_SAS
‎01-28-2025
  • 122 Posts
  • 8 Likes Given
  • 0 Solutions
  • 4 Likes Received

Re: transpose data

by Quartz | Level 8 in SAS Programming
‎07-09-2015 08:25 AM
‎07-09-2015 08:25 AM
an small correction in the output dataset.... VAR1  VAR2  VAR3  VAR4  Sale    X     Y     Z     A A        P         X        M       12       3     22    1     21 B        Q        Y        N        43       2    10     3     36 C        R         Z        O         4       6     5      0     40 D        S         A        P       98       1     6      3     1 ... View more

Re: transpose data

by Quartz | Level 8 in SAS Programming
‎07-09-2015 04:57 AM
‎07-09-2015 04:57 AM
lets make it simple- HAVE: VAR1  VAR2  VAR3  VAR4  Sale A        P         X        M       12       B        Q        Y        N        43       C        R         Z        O         4       D        S         A        P       98       WANT: VAR1  VAR2  VAR3  VAR4  Sale    X     Y     Z     A A        P         X        M       12       3     2     6     1 B        Q        Y        N        43       8    10    9     16 C        R         Z        O         4       2     1     0     1 D        S         A        P       98       23    25   30   20 ... View more

Re: transpose data

by Quartz | Level 8 in SAS Programming
‎07-09-2015 04:35 AM
‎07-09-2015 04:35 AM
the output shoul look like this: VAR1  VAR2  VAR3  VAR4  VAR5  VAR6  VAR7  VAR8      X     Y     Z     A A        P         X        M       12       54      12        26          5     4     6     7 B        Q        Y        N        43       43      32        75          6     5     4     8 C        R         Z        O         4       45      15        17          3     3      7     4 D        S         A        P       98       34      65        66          23    1     6     3 ... View more

transpose data

by Quartz | Level 8 in SAS Programming
‎07-09-2015 03:29 AM
‎07-09-2015 03:29 AM
Hi Experts, I need to transpose the following data by Var3 so that all the attribute of VAR3 could become separate variable. Please help me to do so. VAR1  VAR2  VAR3  VAR4  VAR5  VAR6  VAR7  VAR8 A        P         X        M       12       54      12        26 B        Q        Y        N        43       43      32        75 C        R         Z        O         4       45      15        17 D        S         A        P       98       34      65        66 Regards Rahul ... View more

grouped percentage trending

by Quartz | Level 8 in SAS Visual Analytics
‎07-08-2015 02:34 PM
‎07-08-2015 02:34 PM
dear experts, I am trying to create a dashboard having weekly trending of Sale percent Item Group wise and used the below mentioned dimensions: Category:     Week Measure:     Sale % Group   :     Item Group In result, it shows weekly share of Item group wise sale percent. Is there a way to have weekly total % as 100% not shared perecent total. Regards Rahul ... View more

error while running any query in SAS VA Data Builder

by Quartz | Level 8 in SAS Visual Analytics
‎06-25-2015 08:25 AM
‎06-25-2015 08:25 AM
Hi Experts, I am getting an error while executing any query in SAS VA Data Builder although all the existing dashboards are up and running but am not able to update any of them. “The request could not be completed successfully due to a server error. Please contact your system administrator. Server error: com.sas.svcs.jobexecution.client.JobException: com.sas.svcs.jobexecution.client.TaskExecutionException: org.omg.CORBA.COMM_FAILURE: An exception was thrown while sending a packet to the peer.” Please help me. Regards Rahul ... View more

Re: managing the data for drilling up and down

by Quartz | Level 8 in SAS Visual Analytics
‎05-21-2015 11:30 PM
‎05-21-2015 11:30 PM
which kind of information your are looking for..... ... View more

Re: managing the data for drilling up and down

by Quartz | Level 8 in SAS Visual Analytics
‎05-21-2015 03:37 PM
‎05-21-2015 03:37 PM
Date            Region   State           City                     Store    Sale  5/18/2015,   South,    Hyderabad,  Andhra Pradesh,  1002,    10,291 Here I have taken Sale for a Store and a day and this single entry has to be decided into several parts: DAYPART- Breakfast                  Lunch                  Snacks                  Dinnner Channel-   Dine In                 Take Away                 Corporate                 Delivery                 Drive Through                 ODC these to categories has to be added in the above given sigle observation. Dayparts are same for all stores which is 4 but Channels varies store to store. I managed Daypards  but not able to add Channel for the given data. please help. Daypart is a breakup of day while Channel is a breakup for sale type. ... View more

Re: managing the data for drilling up and down

by Quartz | Level 8 in SAS Visual Analytics
‎05-21-2015 02:58 PM
‎05-21-2015 02:58 PM
Hi Mark, I am just trying to explain the problem once ogain.... I have the date mentioned above and want to add an additional category which channel but the problem is, the number of channels is not same for all the Stores and an average needs to be display on every drill up. However I managed it for Daypart which was same so I just devided by 4 to sale of entire day. ... View more

Re: managing the data for drilling up and down

by Quartz | Level 8 in SAS Visual Analytics
‎05-19-2015 11:30 PM
‎05-19-2015 11:30 PM
Hi Mark, Thanks for the reply, the channel type has its own Channel ID which a breakup of sale for a day. The challenge is, if we add it, the sale value comes wrong. Anyhow, I have to keep the store count correct so that there would no problem in drilling up to hierarchy. Hierarchy: Date- Asset Type- Channel- Region- State- City- Store Regards Anand ... View more

managing the data for drilling up and down

by Quartz | Level 8 in SAS Visual Analytics
‎05-19-2015 02:53 PM
‎05-19-2015 02:53 PM
Hi Experts, I have a data like mentioned below. Where in, I want to add an additional category called channel, which is a break up sale type for a day. The problem here is, the channel type is not fix count for a store, it varies 4 to 6 and depends upon store to store so how can I manage the sale for a day on inclusion of this Channel type. We can assume all six channel type as A, B, C, D, E, F. Earlier I added Day Part which was a fix count so we just devided by 4 on the sale value to balance the store-wise sale for a day. Please advise and help me as I have huge pressure to meet the deadlines. Regards Rahul Date assetType Region City State Store DAYPART DAYPARTID ADS_DAY ADS_MONTH ADS_YEAR 18-May-15 High Street North & Central Delhi Delhi 1001 Breakfast 1 0 51427.12 377531.35 18-May-15 High Street North & Central Delhi Delhi 1001 Lunch 2 60754 1226183.81 9910780.29 18-May-15 High Street North & Central Delhi Delhi 1001 Snack 3 92030.22 1624105.49 14714132.77 18-May-15 High Street North & Central Delhi Delhi 1001 Dinner 4 78326.5 1579755.5 11341499.65 18-May-15 High Street South Hyderabad Andhra Pradesh 1002 Breakfast 1 0 2919.26 25772.72 18-May-15 High Street South Hyderabad Andhra Pradesh 1002 Lunch 2 18289.86 412083.51 3318900.01 18-May-15 High Street South Hyderabad Andhra Pradesh 1002 Snack 3 28888.02 542433.74 4254478.99 18-May-15 High Street South Hyderabad Andhra Pradesh 1002 Dinner 4 29440.27 764147.1 5787352.55 18-May-15 High Street South Hyderabad Andhra Pradesh 1003 Breakfast 1 253 2534 9177.05 18-May-15 High Street South Hyderabad Andhra Pradesh 1003 Lunch 2 32509.08 511543.61 3947812.33 18-May-15 High Street South Hyderabad Andhra Pradesh 1003 Snack 3 39483.37 671119.98 5237376.17 18-May-15 High Street South Hyderabad Andhra Pradesh 1003 Dinner 4 36658.14 825789.63 6297839.63 18-May-15 High Street South Hyderabad Andhra Pradesh 1004 Breakfast 1 214 1236.93 8800.36 18-May-15 High Street South Hyderabad Andhra Pradesh 1004 Lunch 2 16821.72 255253.94 2122059.36 18-May-15 High Street South Hyderabad Andhra Pradesh 1004 Snack 3 19188.65 367893.14 3004546.54 18-May-15 High Street South Hyderabad Andhra Pradesh 1004 Dinner 4 30749.51 522403.79 3986165.71 18-May-15 High Street South Hyderabad Andhra Pradesh 1005 Breakfast 1 299 1546 15029.91 18-May-15 High Street South Hyderabad Andhra Pradesh 1005 Lunch 2 20776.37 465879.18 3896834.88 18-May-15 High Street South Hyderabad Andhra Pradesh 1005 Snack 3 29085.13 584998.16 4474962.43 18-May-15 High Street South Hyderabad Andhra Pradesh 1005 Dinner 4 39734.47 734959 5464303.32 18-May-15 IT Park South Bangalore Karnataka 1008 Breakfast 1 0 217 27646.5 18-May-15 IT Park South Bangalore Karnataka 1008 Lunch 2 24701.35 527201.1 4423561.8 18-May-15 IT Park South Bangalore Karnataka 1008 Snack 3 18778.25 406638.9 3081668.05 18-May-15 IT Park South Bangalore Karnataka 1008 Dinner 4 21557.2 491405.55 3949460.35 18-May-15 Mall North & Central Delhi Delhi 1009 Breakfast 1 0 0 59 18-May-15 Mall North & Central Delhi Delhi 1009 Lunch 2 46292.8 989138.36 7339227.45 18-May-15 Mall North & Central Delhi Delhi 1009 Snack 3 75595.36 1513032.78 12696425.84 18-May-15 Mall North & Central Delhi Delhi 1009 Dinner 4 85261.88 1884253.69 14383477.62 18-May-15 High Street South Bangalore Karnataka 1010 Breakfast 1 0 -312.5 7402.5 18-May-15 High Street South Bangalore Karnataka 1010 Lunch 2 26716.2 578170.25 4182295.3 18-May-15 High Street South Bangalore Karnataka 1010 Snack 3 27725.2 712407.92 4537838.22 18-May-15 High Street South Bangalore Karnataka 1010 Dinner 4 34050.2 795203.45 5621502.9 18-May-15 Drive Thru South Hyderabad Andhra Pradesh 1012 Breakfast 1 0 5956.93 35407.19 ... View more

Re: Multiple Categories in Cross Tab

by Quartz | Level 8 in SAS Visual Analytics
‎03-12-2015 06:27 AM
‎03-12-2015 06:27 AM
No, thats not the case. See, lets talk about 1 by 1, I have a report called ADS which has Measures DAY, MTD and YTD, another one is SSSG, which has the same measures but calculated differently and same thing happens with SSTG as well. The problem is, we can not create calculated item more than one having the same name. So, is there any work-around for the same. ... View more

Re: Multiple Categories in Cross Tab

by Quartz | Level 8 in SAS Visual Analytics
‎03-12-2015 05:17 AM
‎03-12-2015 05:17 AM
Hi Michelle, Attached screen shot is just an example and the same layout is my requirement. I have different Measures and Categories and explaining here: Core Stores Daily Sales Report # stores ADS SSSG SSTG Seq. Growth 11-Mar-15 Day MTD YTD Day MTD YTD Day MTD YTD Region 0 Day MTD YTD Day MTD YTD Day MTD YTD North 0 120 40 79 8273% (37)% (34)% (32)% (40)% (38)% (38)% KTK 0 20 48 105 10746% (37)% (29)% (27)% (39)% (37)% (35)% TN 0 15 40 80 8244% (32)% (31)% (27)% (38)% (37)% (35)% AP 0 10 32 68 6958% (37)% (38)% (36)% (37)% (37)% (39)% WEST 0 5 36 77 8008% (50)% (35)% (32)% (50)% (40)% (40)% KER 0 11 35 70 7528% (26)% (35)% (33)% (32)% (41)% (40)% In the above report we have three measures i.e. DAY, MTD, YTD which are variance between this year and last year, and all are calcualted saperately with respect to ADS, SSSG and SSTG. I could only achieve the result attached in the scree shot (sample cross tab) ... View more

Multiple Categories in Cross Tab

by Quartz | Level 8 in SAS Visual Analytics
‎03-12-2015 02:18 AM
‎03-12-2015 02:18 AM
Hi Experts, I am trying to achieve the same result as its developed in the attached screen shot but facing some challenges like I am not able to find a way to put multiple Categories and same names underneath. I have search each and every available source but didn't find any solution so please help me to get same result. Can we use label for the measures as the data items can contain unique names only. as per the screen shot there has to be a way to make selection for a particular category. I am using SAS Visual Analytic 6.4 Regards Rahul ... View more

Re: SAS VA connectivity to Oracle 10g

by Quartz | Level 8 in SAS Visual Analytics
‎02-05-2015 02:51 AM
‎02-05-2015 02:51 AM
hi SASKiwi, what is the difference between SAS/ACCESS to Oracle or SAS/ACCESS to ODBC. If I have SAS/ACCESS to ODBC so what is the complete process with command which is usefule in linux. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-28-2025 04:46 PM
Likes given to
Likes from
View All
Quick links