in this picture  i have to find the values of which one is rounded that variable in sas..i am getting confusion this is  the requirement    ... View more

835 proc sql; 836 create table cadd as select 'ARVIND CHATURVEDI Total' as SH_NAME,sum(INWARDDAY)as INWARDDAY, 837 sum(INWARDLMON) as INWARDLMON,sum(d1) as d1, sum(NCADAY) as NCADAY,sum(NCAMON) as NCAMON, 837! sum(NCALMON) as NCALMON, 838 sum(d2) as d2, 5 as sno from work.c where team=1 839 union all 840 select 'SAROJ SAMAL Total' as TM_NAME,sum(sum(INWARDDAY))as INWARDDAY,sum(sum(INWARDLMON)) as 840! INWARDLMON, 841 sum(sum(d1)) as d1, sum(sum(NCADAY)) as NCADAY,sum(sum(NCAMON)) as NCAMON, sum(sum(NCALMON)) as 841! NCALMON,sum(sum(d2)) as d2 ,5 as sno 842 from work.c where team=1; ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. ERROR: Summary functions nested in this way are not supported. 843 run;     it showing error    ... View more

data ds; a=33.48 ; b=285; c=153.78 ; d=102; e=a+c; run; proc print data=ds; run;   my requirement like this f=13.98%; what is the logic for this value? plz tell me logic.   ... View more

I am looking for salary total. What can I do for that? Please rectify my query.   proc import datafile="C:\Users\user\Desktop\result of sas\Assignments\EMPLOYEE.csv" out=work.employee dbms=csv replace; run; data emp; FORMAT salary dollar8.; set work.employee; run;         ... View more

i am looking like this total in all observations but i am trying ...plz try to find me. ... View more

data ds; infile datalines; input id$ name$ age sex$; datalines; 101 vinod 22 m 102 kumar 23 m 103 suresh 24 m 104 kalesh 25 m 105 firek 26 f 109 haiek 24 f ; run; proc sql; create table work.ds1 as SELECT 'Total' AS id,count(name) AS name, count(age) as age, count(sex) as sex FROM work.ds GROUP BY age; run; data ds2; set ds ds1; run;   223 data ds; 224 infile datalines; 225 input id$ name$ age sex$; 226 datalines; NOTE: The data set WORK.DS has 6 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 233 ; 234 run; 235 236 proc sql; 237 create table work.ds1 as SELECT 'Total' AS id,count(name) AS name, count(age) as age, count(sex) 237! as sex FROM work.ds 238 239 GROUP BY age; NOTE: Table WORK.DS1 created, with 5 rows and 4 columns. 240 run; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 241 NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 242 data ds2; 243 set ds ds1; ERROR: Variable name has been defined as both character and numeric. ERROR: Variable sex has been defined as both character and numeric. 244 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DS2 may be incomplete. When this step was stopped there were 0 observations and 4 variables. WARNING: Data set WORK.DS2 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds       i want to addup the two datasets of subgroups and grand total also plz rectify ... View more

Name Score A 2B 3A 1B 3 I want a query which give the following output. Name Score A 2A 1Subtotal 3B 3B 3Subtotal 6 Please help me with an procSQL code ... View more