About subhrajitcet0

subhrajitcet0 · ‎12-12-2017

Hi RW9, thanks for the solution. I used PROC MEANS for the same on dummy table i.e. sashelp.cars for the 'Cylinders' variable. Please find code below: ods exclude all; proc means data=sashelp.cars Mean Median stddev min max stackodsoutput; var Cylinders; ods output summary=MeansSummary; run; ods exclude none; proc transpose data=MeansSummary out=meanssummary_transposed(drop=_label_ rename=(_name_=Variable Col1=value)); run; proc sql; alter table meanssummary_transposed add ColName char(30); quit; proc sql; update meanssummary_transposed set Colname='Cylinders'; quit; But I am unable to get Summary statistics as Negative count, two_SD_away,two_SD_below,three_SD_Away,three_SD_below through PROC MEANS. Could you please help?

subhrajitcet0 · ‎12-12-2017

I have a dataset in which 'Actual.balance' is a numeric column. How do I get these below summary attributes for the variable 'Actual.Balance' printed in a column with their values adjacent to it. ColName variable value Actual.Balance Mean 94590150 Actual.Balance Median 107436 Actual.Balance SD 1020714752 Actual.Balance NegativeCount 14 Actual.Balance Lowest -8742115 Actual.Balance Highest 18800512187 Actual.Balance Two_SD_Away 4 Actual.Balance Two_SD_Below 0 Actual.Balance Three_SD_Away 3 Actual.Balance Three_SD_Below 0 Any help would be really beneficial for me.

subhrajitcet0 · ‎12-12-2017

That's perfect RW9. This is the exact solution I wanted. Thanks a lot.

subhrajitcet0 · ‎12-11-2017

Thanks for your response RW9, but PROC FREQ gives me a detailed frequency of each variable's value rather than giving me a result on the different variables. I have used the code: ods exclude all; proc means data=sashelp.cars N Nmiss stackodsoutput; ods output summary=MeansSummary; run; ods exclude none; I get the output as: Variable Label N Nmiss MSRP 428 0 Invoice 428 0 EngineSize Engine Size (L) 428 0 Cylinders 426 2 Horsepower 428 0 MPG_City MPG (City) 428 0 MPG_Highway MPG (Highway) 428 0 Weight Weight (LBS) 428 0 Wheelbase Wheelbase (IN) 428 0 Length Length (IN) 428 0 Along with N and Nmiss I want the variable type and no of unique values for each Variable in the dataset. How do I get the variable type and no of unique values in PROC MEANS?

subhrajitcet0 · ‎12-11-2017

Hello PaideMiller, What i require is the variable type, no of non missing observations, no of missing observations and no of unique values for each variable in a dataset. All the above options should be printed against each variable with the variable names in the first column.

subhrajitcet0 · ‎12-11-2017

How do I output the summary values of a dataset column wise as below? ColName type n NAs NonNAs UniqueValues SBL_BB.Loans. character 398 0 398 3 Unique.Id integer 398 0 398 NA Scenario character 398 0 398 1 Entity character 398 0 398 4 Business character 398 0 398 9 Issuer Category character 398 0 398 8 I am trying to use Proc SQL for the same but am unable to understand how to get the 'type' of each variable using PROC SQL. Can anyone please help?

Online Status	Offline
Date Last Visited	‎12-19-2017 11:40 AM

Re: How do I get the summary statistics of a variable printed in a col...

How do I get the summary statistics of a variable printed in a column

Re: How do i get the summary statistics of a dataset for all variables...

Re: How do i get the summary statistics of a dataset for all variables...

Re: How do i get the summary statistics of a dataset for all variables...

How do i get the summary statistics of a dataset for all variables col...

Re: How do i get the summary statistics of a dataset for all variables...

Re: How do I get the summary statistics of a variable printed in a col...

How do I get the summary statistics of a variable printed in a column

Re: How do i get the summary statistics of a dataset for all variables...

Re: How do i get the summary statistics of a dataset for all variables...

Re: How do i get the summary statistics of a dataset for all variables...

How do i get the summary statistics of a dataset for all variables col...