Help using Base SAS procedures

round problem

Reply
New Contributor
Posts: 3

round problem

Hello, i'm a beginner in SAS, and i have a problem with the function ROUND !

If I create toto table :

data toto;

input Annee Note Bac $; /* JAMAIS d'accent */

cards;

97 12.025 A

98 13.075 A

97 9.045  B

98 8.250  A

97 7.685  C

98 10.554 C

97 14.895 B

;

run;

then i want to print only Note var with rounding !

so :

title "Exemple d'édition de certaines variables";

proc print data=toto noobs round;

var note bac;

run;

it gives a 0.01 default rounding

but what if i want a 0.1 roundinf for example ?

i have so many syntax errors that i'm a bit upset now Smiley Sad

thanks Smiley Happy

Respected Advisor
Posts: 4,935

Re: round problem

Posted in reply to frenchy_robert

You must associate a format to the variable, with the statement :

format note 6.1;

If you insert that statement in your datastep, the format will be permanently associated to the variable. If you put the format statement in the proc print call it will be associated only for the duration of the procedure.

PG

PG
PROC Star
Posts: 1,167

Re: round problem

Posted in reply to frenchy_robert

proc print data=toto noobs round;

format note 4.1;

var note bac;

New Contributor
Posts: 3

Re: round problem

Ok thanks to you two Smiley Happy

Now it works !

Can you explain me the meaning of 4.1 or 6.1 ? Is there a number for each rounding ?

Respected Advisor
Posts: 4,935

Re: round problem

Posted in reply to frenchy_robert

in format 6.1, or more generally w.d, w is the width of the field and d is the number of decimals. Check

http://support.sas.com/documentation/cdl/en/leforinforref/63324/HTML/default/viewer.htm#n1n7bmvs1brl...

there are LOTS of formats available.

PG

PG
New Contributor
Posts: 3

Re: round problem

okay !

thanks for all

hu i have another question, but i guess i have to create another topic instead of asking here because this is about something else :smileygrin:

Ask a Question
Discussion stats
  • 5 replies
  • 216 views
  • 6 likes
  • 3 in conversation