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 the one statement to set the criteria of data that can be coded in any step?
What do the PUT and INPUT functions do?
what are _numeric_ and _character_ and what do they do? : Sas programming
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
For what purposes have you used sas macros? : sas-macro
What makes sas stand out to be the best over other data analytics tools?
which stats created by proc means that are not created by proc summary or vice versa?
is QUALCOMM using SAS ?
Give some examples where proc report’s defaults are same as proc print’s defaults?
explain the concepts and capabilities of business object? : Sas-bi
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
For what purpose(s) would use the RETURN statement?