Hello,   I'm looking to create a number count based on the different IDs and Dataset.  My sample dataset and my pursuing result are listed below. Thanks.   data datain; infile datalines delimiter='/'; input ID : $10. Class : 2.0; datalines; THY/1/ THY/1/ THY/3/ THY/3/ THY/3/ THY/3/ THY/5/ OUW/2/ OUW/3/ OUW/3/ OUW/4/ OUW/4/ OUW/4/ OUW/4/ OUW/4/ ; run; data dataout; infile datalines delimiter='/'; input ID : $10. Class : 2.0 Count : 2.0; datalines; THY/1/2/ THY/3/4/ THY/5/1/ OUW/2/1/ OUW/3/2/ OUW/4/5/ ; run; ... View more

Hello,  I have a sample dataset list below.  I'm looking to list the SINGLE symbols in my final result.  Is there a way to accomplish that? data Charge_Details; length Charge $200; infile datalines delimiter='$'; input Charge; datalines; HB ACETAMINOPHEN 160MG/5ML TYLEN ADULT/PED > 4.0$ HB ALBUTEROL 0.83MG/ML INH SOL(P$ HB 5%DEXTROSE/1/2NS+KCL 10MEQ/L 1$ HB SUPERVISED COUGH & SUCTION - 1/2 HR$ ; data Symbol; set Charge_Details; symbol=compress(strip(upcase(Charge)), ' ' ,'A'); run; data Want; length Symbols $200; infile datalines delimiter='$'; input Symbols; datalines; />(%+&-$ ; ... View more

Hello,  I could like to get the total amount by multiplying 'Charge_Amount' and 'Charge_Quantity.'  The 'Charge_Amount' is DOLLAR21.2 and the 'Charge_Quantity' is Best12.  My code is shown below.  However, I didn't see any total_cost.  Please help. Format Total_Cost DOLLAR30.2; Total_Cost=Charge_Amount*Charge_Quantity; ... View more