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.

Answer / aravind rangaraj

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;

Answer / gaurav verma

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;

what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,

---

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,

---

What is the purpose of the trailing and How would you use them?

8 Answers  

---

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,

---

How would you compile all macros from a folder in a study, within the autoexec program?

1 Answers  

---

How would you create multiple observations from a single observation?

1 Answers   Quintiles,

---

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

4 Answers   HP, Oracle,

---

Explain the purpose of substr functions in sas programming.

0 Answers  

---

What is the function of output statement in a SAS Program?

0 Answers  

---

For what purposes have you used sas macros? : sas-macro

0 Answers  

---

How to save the log information in a file for future use

2 Answers   HCL,

---

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  

---