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 |
How do you read in the variables that you need?
Can you excute a macro within a macro? Describe.
How would you identify a macro variable?
how to read the variables in sas? : Sas-administrator
How do you convert basic cube to transaction cube and transaction cube to basic cube?
how many types prompting framework can be broken down to? : Sas-bi
what is data governance? : Sas-di
What is difference between N and n????
how can you sort the dataset having millions of OBS(instead of sort procedure?
What is the maximum length of the macro variable?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
What system options would you use to help debug a macro? : sas-macro