topic std function in SAS Procedures

std function

bronco — Tue, 19 Jan 2016 22:32:51 GMT

Please help. I'm trying to calculate the std deviation of a variable and output as a new variable.

used: sales_dev = std(sales);

got this error message;

ERROR 71-185: The STD function call does not have enough arguments.

Thanks

Re: std function

Jagadishkatam — Tue, 19 Jan 2016 23:11:52 GMT

std function requires atleast two variables, since you mentioned only one it is giving this error. Also i believe you are using this std in data step, if you have only one variable then please use group by statement

Re: std function

Reeza — Wed, 20 Jan 2016 01:45:15 GMT

Since SAS processes data row by row, thats not quite how it works. The STD() function in a data step is intended to compute the STD of a set of values in the same row.

Proc means is the way to calculate it for a column.

Proc means data=sashelp.class;
Var weight;
Output out=want;
Run;

To get it merged back into the data step merge it back in.

You can also use SQL where the function behaves as expected but SQL does not and will merge it in directly 😀 You do get a note in the log which many places frown upon.

Proc sql;
Create table want2 as
Select *, std(weight) as std_var
From sashelp.class;
Quit;

Re: std function

Reeza — Sat, 30 Jan 2016 01:47:26 GMT

If you want to calculate the std for specific groups, add them into a GROUP BY clause.