About Gangi

Gangi · ‎10-04-2022

attached the data, In sheet1 Customer_id is assigned to ID1, if that ID matches to manager in Sheet2 for that branch then Cu will get same manager. if not assign to other manager in the same branch. But Finally each manager should get equal number of Customers assigned to them. In this case, for abc branch, below number customers assigned to each manager. manager1-- 32 manager2-- 32 manager3-- 31 Thank you

Gangi · ‎10-03-2022

There are n number of customers belongs to one branches and there multiple managers(say 3 managers in this case) in the same branch. some customers are reserved to manager1, need to assign rest of the customers managers such that all the managers are assigned to equal number of customers. Customer_NBR Branch Assign_ID 1 abc Manger1 2 abc Manager2 3 abc Manager2 4 abc -- 5 abc -- . . . 100 abc -- After assigning mangers to each customer, I would need each manager to have equal number of customers assigined Manger1 34 Customers Manager 2 33 Customers Manager3 33 Customers

Gangi · ‎11-08-2019

I tried using cast(B as VARCHAR), I got the error as Teradata prepare: Syntax error, expected something like '(' between the 'VARCHAR' keyword and ')' I also tried defining the length Varchar(10000) but still I got the error. Thank you,

Gangi · ‎11-07-2019

I have table able called ABC in database with column names as A,B,C,D,E. Out of these columns B column has data in XML format. when I tried to import data from datsabse using PROC SQL it the throwing an error, "ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine."

Gangi · ‎05-29-2018

I have file with name as "NBB.YCOT010.MAY25" (semicolon as delimiter) which is output from mainframe, Please help me how can load it to using code, Note: If I load using Import wizard I can see file taken as below, INFILE 'C:\Users\Temp\SEG8776\NBB.YCOT010-e5eca727229347ce9dab2e0cbd18c2ea.txt'

Gangi · ‎01-31-2018

you can use sum statement, example as below, data t1; input id jul_17 Aug_17 sep_17 oct_17 nov_17 dec_17; datalines; 1111 . . 1 1 1 1 1112 . . . . . 1 1113 1 1 . 1 . . 1114 . . . . 1 1 1115 1 . . . 1 . 1116 1 . . . 1 . ; run; data t2; set t1; ENTRIES= sum(of jul_17--Dec_17); run; accept it if it works..

Gangi · ‎01-31-2018

Thank you very much for your reply, suggested code works superbly, but I have got one more issue, when I try to download that as excel using proc report the grandtotal coming as blank cell rest everything looks good, could you please suggest me how I can achieve this? Thank you very much.. data test1; length C_tier $11; input year Areacode country $ tier sales; c_tier = put(tier,1.0); datalines; 2017 1 US 1 100 2017 1 US 2 200 2017 1 US 3 300 2017 1 US 4 120 2017 1 US 5 450 2017 1 US 0 390 2017 2 US 0 100 2017 2 US 1 300 2017 2 US 2 60 2017 2 US 3 1000 2017 3 US 0 200 2017 3 US 1 220 2017 3 US 2 140 2017 1 US 4 390 2017 2 US 5 100 2017 2 US 3 300 2017 2 US 4 60 2017 2 US 3 1000 2017 3 US 5 200 2017 3 US 1 220 2017 3 US 4 140 ; run; ods excel file= "C:\Users\abc\Desktop\bca.xlsx"; proc report data=test1 style(summary)=Header; columns year Areacode country c_tier sales; define year/display "Year of Sale"; define Areacode/display "Area"; define country/ display "Country"; define c_tier/group "Tier"; define sales/ analysis sum "Total Sales"; break after c_tier /summarize dol dul; rbreak after/summarize; compute after c_tier; call define('c_tier','style','style=Header{pretext="SubTotal"}'); endcomp; compute after; call define('c_tier','style','style=Header{pretext="Grand Total"}'); endcomp; run; ods excel close;

Gangi · ‎01-25-2018

Thank you very much for quick reply, code and images are below data test1; input year Areacode country $ tier sales; datalines; 2017 1 US 1 100 2017 1 US 2 200 2017 1 US 3 300 2017 1 US 4 120 2017 1 US 5 450 2017 1 US 0 390 2017 2 US 0 100 2017 2 US 1 300 2017 2 US 2 60 2017 2 US 3 1000 2017 3 US 0 200 2017 3 US 1 220 2017 3 US 2 140 2017 1 US 4 390 2017 2 US 5 100 2017 2 US 3 300 2017 2 US 4 60 2017 2 US 3 1000 2017 3 US 5 200 2017 3 US 1 220 2017 3 US 4 140 ; run; proc report data=test1; columns year Areacode country tier sales; define year/display "Year of Sale"; define Areacode/display "Area"; define country/ display "Country"; define Tier/group "Tier"; define sales/ analysis sum "Total Sales"; break after Tier /summarize dol dul; rbreak after/summarize; run; as highlighted below, I am trying to give name for every subtotal and also grand total, please suggest me how I can achieve this? run;

Gangi · ‎01-24-2018

I am trying to give some name in the box highlighted in the image, (for Grand Total and Subtotals) im using the below code to produce the report, Please help me. proc report data=abc OUT=test; columns YEAR1 OFFER_MONTH CNTRY_CD Term Tier TOTAL_OFFERS; define year1/ display "YEAR"; define OFFER_MONTH/display "OFFER MONTH"; define CNTRY_CD/ display "COUNTRY"; define Tier/group "Tier"; define TOTAL_OFFERS/ analysis sum "Sales" format=comma8.; break after Tier /summarize dol dul; Compute after ; type="Grand Total :"; endcomp; run;

Gangi · ‎12-13-2017

Perfectly worked...!!! Thank you

Gangi · ‎12-13-2017

I have data set with the date and no of sales for that particular date, I need create report to see how many days took for every thousand sales, Example: Date NoOfSales 01Jan17 200 02Jan17 350 03Jan17 350 04Jan17 200 05Jan17 100 06Jan17 400 07Jan17 300 08Jan17 200 09Jan17 200 . . . . and so on from this table i need to create a table on what date it crossed 1000, 2000, 3000 sales and soon here 04Jan17 1000 08Jan17 2000 ? Please suggest he how we can achieve this in PROC SQL or DATA step ?

Gangi · ‎08-25-2017

Thank you very much for the Answer.. It is working as expected.

Gangi · ‎08-25-2017

Thank you for your suggestion, I tried the solution but now It is coming as all the market_areq together and Regions togethere. I need Market area Followed by the corresponding regions. Thank you

Gangi · ‎08-25-2017

I am new SAS EG and trying to create proc report using charcter Varibles, Table look like below, market_Area Market_Region Customer_Id east A 12 east A 13 east B 10 east C 17 and so on I need report like, Area Count(Customer) East 4 A 2 B 1 C 1 Like this for all regions, I am trying proc report data=Data_Have; column Market_Area Market_Region Customer_Id; define Market_Area/group; define Market_Region/group; define Customer_Id/sum "Sum of Distinct" width=8; run; But its not working, Kndly Help

Online Status	Offline
Date Last Visited	‎10-07-2022 05:23 AM

Re: Assign Var equally post reserving some for one Variable?

Assign Var equally post reserving some for one Variable?

Re: How to Import column which is stored as XML format in database?

How to Import column which is stored as XML format in database?

How to import unspecified format file to SAS EG?

Re: Count number of changes in variables over time

Re: How to Label totals and subtotals in PROC Report?

Re: How to Label totals and subtotals in PROC Report?

How to Label totals and subtotals in PROC Report?

Re: How to get date for every thousand sales in SAS

Re: Count number of changes in variables over time

Re: Assign Var equally post reserving some for one Variable?

Assign Var equally post reserving some for one Variable?

Re: How to Import column which is stored as XML format in database?

How to Import column which is stored as XML format in database?

How to import unspecified format file to SAS EG?

Re: Count number of changes in variables over time

Re: How to Label totals and subtotals in PROC Report?

Re: How to Label totals and subtotals in PROC Report?

How to Label totals and subtotals in PROC Report?

Re: How to get date for every thousand sales in SAS

How to get date for every thousand sales in SAS

Re: Two Way Proc Report

Re: Two Way Proc Report

Two Way Proc Report