About farrukh

farrukh · ‎12-13-2017

THANKS FOR YOUR REPLY, I WILL SURELY TRY THIS.

Astounding · ‎10-24-2016

The simplest possibility of all: remove the VAR statement from PROC MEANS. The default action is to process all numeric variables.

farrukh · ‎09-19-2016

Thanks Kurt .. this works for me !!

Haikuo · ‎09-01-2016

Yeah, syntax seems off a little bit, try below: proc sql; create table anal1 as select cust ,SUM(sum(A,B,C)) AS TOT_ABC ,sum(A)/calculated TOT_ABC as A_tot_abc ,sum(B)/calculated TOT_ABC as B_tot_abc ,sum(C)/calculated TOT_ABC as C_tot_abc from test group by cust ;quit;

Reeza · ‎09-01-2016

Select cust, max(a) as maxA, max(b) as maxB, max(C) as MaxC, max( calculated maxA, calculated maxB, calculated maxC) as overallMax from have group by cust;

Kurt_Bremser · ‎08-25-2016

If you want to check if a certain variable is present in a dataset, read the table metadata from SASHELP.VCOLUMN: %let column=XX; data _null_; set sashelp.vcolumn (where=(libname='SASHELP' and memname = 'CLASS')) end=done; retain flag 1; if upcase(name) = upcase("&column") then flag = 0; if done and flag then put 'Errormessage'; run;

Online Status	Offline
Date Last Visited	‎02-14-2018 05:30 AM

Re: Invoking SAS EG using Excel VBA

Re: Invoking SAS EG using Excel VBA

Invoking SAS EG using Excel VBA

Pass variables from one data set to Proc means

Re: calculating second last date in a table using left join

calculating second last date in a table using left join

Nested aggregate function

Select row based on max value

Re: conditional data output

Re: conditional data output

Re: Invoking SAS EG using Excel VBA

Re: Pass variables from one data set to Proc means

Re: calculating second last date in a table using left join

Re: Nested aggregate function

Re: Select row based on max value

Re: conditional data output