About XY7

XY7 · ‎01-13-2019

Thank you very much!

XY7 · ‎01-13-2019

Yes, I am allowed to do so.

XY7 · ‎01-13-2019

Hi, I am trying to accumulate the total amount by purpose for each bank in this data set, however, I am either only able to obtain the amount based on purpose or bank type itself. Could anyone kindly explain? Thank you. Data: My codes on the calculation: data work.purpose2; set work.purpose1; by purpose bank_to; retain cummulative_value; if first.purpose then cummulative_value=amount; else cummulative_value=amount+cummulative_value; drop amount; run; Results output: The results are supposed to show something like this (By the bank type and purpose): bank_to purpose cummulative_value AB Leasing $1234567 AB Insurance $1234567 AB Household $1234567 GH Insurance $1234567 ....

XY7 · ‎01-09-2019

Ohh, thank you very much!

XY7 · ‎01-08-2019

Thank you so much!

XY7 · ‎01-07-2019

The data set wasn't created by me, it was provided, it was purposely created this way to be solved. I didn't realise that it was created wrongly previously. This is the column in Account This is the column in Loan

XY7 · ‎01-06-2019

Alright, thank you!

XY7 · ‎01-06-2019

Thank you, I have found out the problem but it's weird because it was detailed as a character type for both data sets in the data dictionary that was provided. In this case how should I do the conversion? Variables Summary Number of Variables in Common: 1. Number of Variables in WORK.ACCOUNT but not in WORK.LOAN: 3. Number of Variables in WORK.LOAN but not in WORK.ACCOUNT: 6. Number of Variables with Conflicting Types: 1. Listing of Common Variables with Conflicting Types Variable Dataset Type Length Format Informat Label account_id WORK.ACCOUNT Char 5 $CHAR5. $CHAR5. WORK.LOAN Num 8 BEST. account_id

XY7 · ‎01-06-2019

It's weird because all of the data sets that contains the same variable is of character type, thank you, I will try converting the type.

XY7 · ‎01-06-2019

Thank you! :)The details of the variables and type was provided.

XY7 · ‎01-06-2019

Hi, I just started picking up SAS recently and am working on an assignment. I encountered a problem when trying to merge two data sets together using a variable that appears in both data sets, the error says that the variable has been defined as both character and numeric, but when I checked both data sets, the variable is of character type in both. Hence, I am not sure what exactly could the problem be. Could anyone kindly explain? Thank you.

Online Status	Offline
Date Last Visited	‎01-21-2019 09:43 PM

Re: Accumulating Totals by 2 Variables

Re: Accumulating Totals by 2 Variables

Accumulating Totals by 2 Variables

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Error: Variable has been defined as both character and numeric

Re: Accumulating Totals by 2 Variables

Re: Accumulating Totals by 2 Variables

Accumulating Totals by 2 Variables

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Re: Error: Variable has been defined as both character and numeric

Error: Variable has been defined as both character and numeric