proc sql; select state,qtr,bal_rev,avg(amount) as Avg_amount,sum(amount) as sum_amount from (select *, case when period in (1,2,3) then 'qtr1' when period in (4,5,6) then 'qtr2' end as qtr from have) group by bal_rev,state,qtr; quit;
... View more
proc sql; create table gender_dispurtion as Select count(gender),country from customer_1 where upcase(gender) eq 'F' group by country; quit;
... View more
select outcome_name,outcome_value,outcome_date,outcome_year,outcome_date_days_since from have ; select count(*),outcome_value,outcome_name from have group by outcome_name,outcome_value;
... View more
In your dataset, which are not assigned red color there are missing values. So you can collect easily the red mark data by using proc sql and also data step method also. How is the dataset saved, is it in in csv?
... View more
Hey Aditya1, As you are saying you are having three tables with same variables, then you have to use set statement or use union with PROC SQL.
... View more
I am giving some clues, You can follow this : data have; input adj_code year value treatment $ state $; datalines; 0 2005 12 therap MI 1 2006 20 inpati CA 2 2007 22 inpati MI 1 2005 21 inpati MI 2 2005 22 therap CA 0 2005 10 therap CA 1 2006 19 inpati CA 2 2007 10 inpati MI 2 2006 20 therap CA 1 2006 11 inpati MI 0 2005 90 therap CA 0 2006 11 inpati MI 0 2005 99 therap MI ; run; proc format; value adj_code 0="0-NO ADJUSTMENT OF CLAIMS WAS REQUIRED" 1="1-AT LEAST ONE ORIGINAL CLAIM AND AT LEAST ONE ADJUSTMENT CLAIM" 2="2-NOT POSSIBLE TO COMPLETE THE ADJUSTMENT PROCESS"; value $treatment 'therap'="OTHER THERAPY PERCENTAGES" 'inpati'="INPATIENT PERCENTAGES"; run; ods escapechar='^'; ods pdf; proc report nowd data=have spanrows; title1 "Adjustment code claims 2.2.2, 2.3.2"; title2 "&statename., 0-18 years old"; title3 "2005-2007"; column state (adj_code) treatment,year,value;* year value treatment; define state/group; break after state/page; define adj_code/'Adjustment Code' group format=adj_code.; define treatment/''across order=internal format=$treatment.; define year/' 'across order=internal ; define value/'' sum; rbreak after/ summarize; run; ods pdf close;
... View more
You can connect data into sas dataset and can use above logic. As in proc sql you can use lag() only to bring the previous value and then you have to use join function. But your request is quite difficult to implement by using proc sql.
... View more
According to your requirement you don't require lag function, the following code is perfect for you. data want; set have; by group; retain new_tag ; if missing(tag) and first.group then new_tag=tag; else if not missing(tag) then new_tag=tag; final_tag=new_tag; run;
... View more
data want; set have; retain new_tag ; if missing(tag) and _n_ gt 1 then do; if not missing(lag(tag)) then new_tag=lag(tag); end; else new_tag=tag; final_tag=new_tag;run;
... View more
