what is picture format? give any one example?
Answers were Sorted based on User's Feedback
Answer / bitla
picture format writes a template for numerics
proc format ;
picture sno
low - -1 = '00.00'
0-9='9.999'
10-99='99.99'
100-999='999.9'
;
When you specify zero as the digit selector, any leading
zeros in the number to be displayed are shown as
blanks. When nine is specified as the digit selector, the
leading zeros are displayed in the output.
Is This Answer Correct ? | 13 Yes | 0 No |
picture format is used to Create a template for printing
numbers.
ex:
proc format ;
picture nozeros low - -1 = '00.00' (prefix='-')
-1< - < 0 = '99' (prefix='-.' mult=100)
0 - < 1 = '99' (prefix='.' mult=100)
1 - high = '00.00';
run;
Is This Answer Correct ? | 5 Yes | 0 No |
proc format;
picture pctfmt low-high='009.90%';
run;
proc tabulate data=xyz;
class name gender;
var rbc wbc;
table (name all)*(genderb all),
rbc*(mean*f=9. pct*f=pctfmt7.2)
wbc*(mean*f=8. pct*f=pctfmt7.2);
keylabel rbc='red blood cell'
wbc='white blood cell'
pct='percent';
run;
Is This Answer Correct ? | 0 Yes | 0 No |
what is syntax of proc merge ?
If money were no object, what would you like to do?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
What system options would you use to help debug a macro? : sas-macro
What SAS statements would you code to read an external raw data file to a DATA step?
Which command is used to perform sorting in sas program?
Briefly describe 5 ways to do a "table lookup" in sas.
what are the different ways of merging two datasets.name atleast 4.
I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?
What is the difference between informat and format statement?
how we can call macros with in data step?
Mention the difference between ceil and floor functions in sas?