About kenjichan1212

kenjichan1212 · ‎09-05-2019

Hi I have two tables as follows: Table1 Year Category Admissions 2011 Category 1 0 2011 Category 2 0 2012 Category 1 0 2012 Category 2 0 2013 Category 1 0 2013 Category 2 20 Table2 Year Category Admissions 2013 Category 2 20 How do I get a table looking as follows: 2013 Category 1 0 2013 Category 2 20 I tried left joining them by Year but it gets rid of the zeros for 2013 Category 1. Sorry any help is appreciated

kenjichan1212 · ‎07-31-2019

Thank you so mcuh!

kenjichan1212 · ‎07-31-2019

Hi all I'm new to SAS and I'm just wondering why I am getting the error below: ERROR: Result of WHEN clause 3 is not the same data type as the preceding results Here is my code case WHEN Year = 1617 and state in ('NSW') and Surgical_Specialty = '12' then Surgical_Specialty = '11' WHEN Year = 1617 and t1.state in ('NT') and Surgical_Specialty in ('01','1') then Surgical_Specialty = '11' ELSE Surgical_Specialty end as Surgical_Specialty, The Year column is in Numeric The Surgical_Specialty and STATE is in Character Not sure why I cannot use year and STATE and surgical specialty in one when statement Thankyou

kenjichan1212 · ‎07-17-2019

Hi I have a column called ' Decimal' which has the required decimal places stored (It is in numeric) eg Decimal Data 0 2.222 1 3.322 So I want the data to look like; Data 2 3.3 I know the round function can achieve this easily but how do you use the variable 'Decimal' to convert the Data into its actual decimal places. I tries this so far on Proc SQL round(Data,Decimal) as NewData also tried strip(put(Data,8.Decimal)) as NewData It seems like I cannot use a variable to manipulate the decimal places of another variable. Any help is appreciated! Thanks

kenjichan1212 · ‎07-17-2019

Hospital Cancer Data Albany Hospital Bowel cancer . 2 Albany Hospital Bowel cancer . 5 Albany Hospital Bowel cancer 6 Albany Hospital Breast cancer 7 Albany Hospital Breast cancer 5 Hi I'm just wondering how to convert the above output to the following in SAS or Proc SQL; Hospital Bowel Cancer Breast Cancer Albany Hospital 2 7 Albany Hospital 5. 5 Albany Hospital 6 Thank you!

kenjichan1212 · ‎07-08-2019

Hi I'm just wondering how to convert this SQL statement into PROC SQL. I'm using SAS version 7.15 case when pdi.Value2 is not null then CONCAT(CAST(pdi.Value as decimal(18,3)), '-', CAST(pdi.Value2 as decimal(18,3))) else CONVERT(varchar(20), pdi.Value) end as PeerDataValue This is what I have so far and it doesn't seem to work; any help is appreciated case when pdi.Value2 is not null then CAT((put(pdi.Value,18,3)), '-', (put(pdi.Value2,18,3))) else put(pdi.Value, $20) as pdi.Value end as PeerDataValue,

Online Status	Offline
Date Last Visited	‎09-17-2019 03:11 AM

SQL NULL JOINs

Re: WHEN clause with multiple conditions

WHEN clause with multiple conditions

Using a number stored in a variable to convert another varibale into t...

How to convert groups in rows to seperate columns?

PROC SQL CAST for converting decimals

Re: PROC SQL CAST for converting decimals