About Babloo

Babloo · ‎09-12-2018

Appreciate if someone of you help me tackle in the following situation to create a mapping in DI Studio. I have to create one variable called 'KNDATL' from the table POLICY and the field is 'Policy_Issue_dt' If 'Policy_Issue_dt' is missing then I've to compare the variable KNKATD from the current month dataset (POL_SEP_2018) with KNKATD of previous month dataset (POL_AUG_2018) . If equal, than take the same KNDATL of previous month, if different, take last date of previous month (e.g. 31-08-2018). KNKATD is character variable which has values like '1', '2', '3', '4' KNDATL is numeric variable which has values like 31-08-2018, 17-08-2018....

Babloo · ‎08-25-2018

Could you please guide me to create a similar chart in proc report or proc tabulate or proc freq?

Babloo · ‎08-25-2018

I received the following error message after executing the proc sgplot code. Is that not a license issue? 53 proc sgplot data=plot; ERROR: The SAS/GRAPH product with which SGPLOT (2) is associated is either not licensed for your system or the product license has expired. Please contact your SAS installation representative. ERROR: Bad product ID for procedure SGPLOT.

Babloo · ‎08-24-2018

Thank you for the code. Is there any way that you can produce a similar chart in Proc report or proc tabulate?

Babloo · ‎08-24-2018

Thank you for the code. Is there any way that we try with proc freq except the coloring part? I just noticed that I do not licensed for graphical procedures.

Babloo · ‎08-24-2018

Could you please help me with the procedure which creates the desired output?

Babloo · ‎08-24-2018

I want to create a bar chart as follows with the following data. I knew that we can accomplish this using proc sgplot but I'm not certain to create a chart for each observation. Appreciate if someone of you help me here. Data preparation: data test; length name average_talk_time_answered_calls Average_ACW_Time_Answered_Calls $200; name='Van der Haeghen, Wendye (E003983)'; Average_Talk_Time_Answered_Calls='116,3953488'; Average_ACW_Time_Answered_Calls='290,4883721';output; name='Verhaeghe, Johny (E002902)'; Average_Talk_Time_Answered_Calls='86,66666667'; Average_ACW_Time_Answered_Calls='2,333333333';output; ; run; data temp(drop=Average_Talk_Time_Answered_Calls Average_ACW_Time_Answered_Calls) ; set test; Avg_Talk_Time_Answered_Calls=input(tranwrd(Average_Talk_Time_Answered_Calls,',','.'),best.); Avg_ACW_Time_Answered_Calls=input(tranwrd(Average_ACW_Time_Answered_Calls,',','.'),best.); run; Dataset: name Avg_Talk_Time_Answered_Calls Avg_ACW_Time_Answered_Calls Van der Haeghen, Wendye (E003983) 1.163.953.488 2.904.883.721 Verhaeghe, Johny (E002902) 8.666.666.667 2.333.333.333

Babloo · ‎08-24-2018

Even after giving the length, I'm receiving the output as follows. data test; length name average_talk_time_answered_calls Average_ACW_Time_Answered_Calls $200; name='Van der Haeghen, Wendy (D003983)';output; Average_Talk_Time_Answered_Calls='116,3953488';output; name='Van der Haeghen, Wendy (D003983)';output; Average_Talk_Time_Answered_Calls='86,66666667';output; name='Verhaeghe, John (D002902)';output; Average_ACW_Time_Answered_Calls='290,4883721';output; name='Verhaeghe, John (D002902)';output; Average_ACW_Time_Answered_Calls='2,333333333';output; ; run; Output: name average_talk_time_answered_calls Average_ACW_Time_Answered_Calls Van der Haeghen, Wendy (D003983) Van der Haeghen, Wendy (D003983) 116,3953488 Van der Haeghen, Wendy (D003983) 116,3953488 Van der Haeghen, Wendy (D003983) 86,66666667 Verhaeghe, John (D002902) 86,66666667 Verhaeghe, John (D002902) 86,66666667 290,4883721 Verhaeghe, John (D002902) 86,66666667 290,4883721 Verhaeghe, John (D002902) 86,66666667 2,333333333 Desired Output: Name Average Talk Time Answered Calls Average ACW Time Answered Calls Van der Haeghen, Wendy (D003983) 116,3953488 290,4883721 Verhaeghe, John (D002902) 86,66666667 2,333333333

Babloo · ‎08-24-2018

I ran the code as follows but I'm not receiving the output as I mentioned in the screenshot below. Appreciate if someone of you guide me here. data test; name='Van der Haeghen, Wendy (D003983)';output; Average_Talk_Time_Answered_Calls='116,3953488';output; name='Van der Haeghen, Wendy (D003983)';output; Average_Talk_Time_Answered_Calls='86,66666667';output; name='Verhaeghe, John (D002902)';output; Average_ACW_Time_Answered_Calls='290,4883721';output; name='Verhaeghe, John (D002902)';output; Average_ACW_Time_AnsweredCalls='2,333333333';output; ; run; Disired Output: Name Average Talk Time Answered Calls Average ACW Time Answered Calls Van der Haeghen, Wendy (D003983) 116,3953488 290,4883721 Verhaeghe, John (D002902) 86,66666667 2,333333333

Babloo · ‎08-24-2018

I want to create a dataset per the below data. I tried to wrote a program to read the data but it is not reading the data as I except. Could someone of you guide me with the program create a dataset per the following data? Name Average Talk Time Answered Calls Average ACW Time Answered Calls Van der Haeghe, Wendy (A000028) 116,3953488 290,4883721 Verhaegh, John (F002902) 86,66666667 2,333333333 data DVV_Automatic_Schedule; input @1 name $ @40 'Average Talk Time Answered Calls'n commax18. @60 'Average ACW Time Answered Calls'n commax18.; datalines; Van der Haeghe,Wendy(A000028) 116,395348837209 290,4883721 Verhaegh,John(F002902) 86,66666667 2,333333333 ; run;

Babloo · ‎08-23-2018

Is there anyway to deal this with only formats?

Babloo · ‎08-23-2018

No, I no need to convert comma to dot. I have values in my file like -0,01259870

Babloo · ‎08-23-2018

I ran the following code and end up with error as follows. Could you please help me with the format which translate comma values to percent? I don't wish to do any data manipulation here. data foo; format y percent7.1; y=-0,01259870; run; proc print data=foo; run; Log: 26 data foo; 27 format y percent7.1; 28 y=-0,01259870; _ 388 200 ERROR 388-185: Expecting an arithmetic operator. ERROR 200-322: The symbol is not recognized and will be ignored. Desired output: 1.3%

Babloo · ‎08-21-2018

I ran the following code and got too many missing values (.) for the variable 'PSI'. There is no missing values in D_PTY_PARTY.PARTY_ID, F_CLM_CLAIM_EOM.CUSTOMER_SK and D_PTY_PARTY.PARTY_SK. Could you please help me understand how would I've got missing values? proc sql; create table work.W6ZVHVL0 as select distinct input(D_PTY_PARTY.PARTY_ID ,9.) as PSI length = 8 format = 9. informat = 9. label = 'Customer Identifier', F_CLM_CLAIM_EOM.AMT length = 8 label = 'Amount' from udmtcom.F_CLM_CLAIM_EOM, udmtcom.D_PTY_PARTY where F_CLM_CLAIM_EOM.CUSTOMER_SK = D_PTY_PARTY.PARTY_SK and F_CLM_CLAIM_EOM.REPORTING_DATE_SK = 20180630 ; quit; Example data: CUSTOMER_SK -1 578704 578704 1997938 PARTY_SK -1 1 2 3 4 PARTY_ID 1 100 1000 10000 100000 1000000

Babloo · ‎08-14-2018

Appreciate if someone of you guide me to derive the expression with the following condition. I'm using DI Studio 4.21. I want to derive the new variable KNDATL and mapping is to take the policy issue date from POLICY dataset. If this policy issue date is empty than check if the knkatd (it's a another variable) of current run month <> knkatd of previous month. If there is difference then take end of month as KNDATL; if no difference, take the same value for KNDATL as previous month. Data for knkatd looks like 1 to 12 (Jan as 1 to Dec as 12)

Online Status	Offline
Date Last Visited	‎06-03-2024 06:10 PM

SQL help on transpose logic

Re: Unexpected select error in Update statement

Re: Unexpected select error in Update statement

Unexpected select error in Update statement

Update statement based on Join condition not working

Select top 1 record based on conditions

Re: Substr with max function

Re: Substr with max function

Re: Substr with max function

Substr with max function

Re: Unexpected select error in Update statement

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Handling Missing and Null Values

Re: Case when to handle blank and NULL values

datetime format for dd.mm.yyyy hh:mm?

Re: datetime format for dd.mm.yyyy hh:mm?

Re: Error in Macro Variable

SAS 9.4 installation documents

Understanding of code submission to Grid nodes

Mapping to compare the values from two datasets

Re: Bar Chart

Re: Bar Chart

Re: Bar Chart

Re: Bar Chart

Re: Bar Chart

Bar Chart

Re: Data Step

Data Step

How to read the data values with space and comma?

Re: Percent format for comma values

Re: Percent format for comma values

Percent format for comma values

Missing values understanding

Expression for mapping the new variable