About Kalai2008

Kalai2008 · ‎07-25-2017

You are Right, (but it is already created by another user.) Thank you , I will try renaming the variable.

Kalai2008 · ‎07-25-2017

How to convert the variable checkname from character to numeric? Given data Checkname 0-1_check 1-2_check data want ; set have; checkname1=input(checkname,best12.); run; Getting missing value(Period)

Kalai2008 · ‎07-25-2017

Thank you!

Kalai2008 · ‎07-25-2017

I calculated the sum of all the variables using proc means and not sure how to combine them with the main dataset. Given dataset T ID var1 var2 var3 1 20 30 52 2 80 20 65 3 42 95 25 Want dataset: ID var1 var2 var3 1 20 30 52 2 80 20 65 3 42 95 25 Tot 142 145 142 OUTPUT FROM PROC MEANS Obs _TYPE_ _FR VAR1 VAR2 VAR3 1 0 3 142 145 142 I want to join the sum from proc means to the main dataset T.

Kalai2008 · ‎07-19-2017

Getting error like ERROR: Summary functions are restricted to the SELECT and HAVING clauses only. proc sql; select acc, sum(amt) as tot_amt, count(id1) as count1, count(id2) as count2, count(id3) as count3, count(id4) as count4, count(id5) as count5, sum(calculated count1,calculated count2,calculated count3,calculated count4,calculated count5) as tot_id from table group by acc run; Each acct have 5 ids..some are blank.

Kalai2008 · ‎07-17-2017

Thank you! I agree to your point.

Kalai2008 · ‎07-17-2017

Thank you for the reply. Just few more questions, I need to add a new calculated column called Sum , not sure if I can add them in the case statement. Output like: Acct Code A (Less than 200) Code A (More than 200) Code B (less than 200) Code B (More than 200) tot_sum 11 1 0 0 0 195 22 1 0 0 1 255 33 0 1 0 0 300 Can we also replace the code with between ...I am getting error if I use between. case when code like 'a' and amt between 0-200 then 1 end as Code_A_Less_than_200, case when code like 'a' and amt between 201-300 then 1 end as Code_A_More_than_200, or something like this? case when code like 'a' and amt < 200 then 1 end as code_a_less_than_200, case when code like 'a' and 200 >amt<201 then 1 end as code_a_more tha_200,

Kalai2008 · ‎07-17-2017

I am using Proc Sql. I am getting an error while trying to use this case_statement.. proc sql; create table test as select a.*, case when code like 'a' and amt <= 200 then 1 end as Code A (Less than 200) when code like 'a' and amt > 200 then 1 end as Code A (More than 200) when code like 'b' and amt <= 200 then 1 end as Code B (Less than 200) when code like 'b' and amt > 200 then 1 end as Code B (More than 200) from t.test1 a ; run; Given Data: Acct Amt Code 11 195 a 22 205 b 22 50 a 33 300 a Output like: Acct Code A (Less than 200) Code A (More than 200) Code B (less than 200) Code B (More than 200) 11 1 0 0 0 22 1 0 0 1 33 0 1 0 0

Kalai2008 · ‎07-17-2017

Thank you..It worked

Kalai2008 · ‎07-17-2017

Thank you!..It worked!

Kalai2008 · ‎07-17-2017

Thank you I will try it.

Kalai2008 · ‎07-17-2017

I dont want to try it in Proc means or Proc Summary.... Trying to build a new data set ..so I need to do it in data step.

Kalai2008 · ‎07-17-2017

I don't want to try Proc Sql; I am trying to get the aggregated total for the new column. data test.id; set test.data; Total_amt=sum(d_amt); drop d_amt; run; Current Output Actual Output Acct Total amt Acct Total amt 23 400 23 1000 23 600

Kalai2008 · ‎07-17-2017

Thank you!..It worked.I was confused with the proc sql.

Kalai2008 · ‎07-17-2017

I dont want to use Proc SQL in my program. I am trying to calculate a new column (Acc) with the count of all variables. pin_id1 is numeric. data test.id; set test.data ; Acc= count(pin_id1,pin_id1,pin_id3); run; ERROR 72-185: The COUNT function call has too many arguments. NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 25:12 25:20 25:28 25:36 25:44 NOTE: The SAS System stopped processing this step because of errors. Output like: pin_id1 pin_id2 Pin_id3 Acc 235 465 987 3 223 777 2

Online Status	Offline
Date Last Visited	‎09-23-2021 07:56 PM

Help in SCAN function loop

Re: Column Match

Column Match

SAS Function help

Re: Listagg function help

Re: Listagg function help

Listagg function help

Re: Help in Dates

Re: Help in Dates

Help in Dates

Re: SAS Function help

Re: Listagg function help

Re: Listagg function help

Re: Listagg function help

Re: Help with selecting only 2 values in a variable

Re: Input function Help

Input function Help

Re: Proc Means help

Proc Means help

Error in count function

Re: Help in Case Statement

Re: Help in Case Statement

Help in Case Statement

Re: Calculating totals

Re: Calculating totals

Re: Calculating totals

Re: Calculating totals

Calculating totals

Re: Help in count function

Help in count function