Answer / diya

to use the permanent format catalog the statement is

libname a 'c:\sas\files';
options fmtsearch=(a.treesfmt);
proc print data=a.trees (obs=5) label;
run;

To use your permanent sas data set eith user-defined
fortmat for the future sas sessions you need to

1. assign a sas library to location of the sas format
catalog.
2. specfiy the name of the sas format catalog with the ftm
seacrch option.


for info this website
http://www.umass.edu/statdata/software/handouts/SASLevel2.pd
f

Answer / cutepa1

Hi Diya! Thanks for your valuable answer. I shall start to
work with this.
Thank you.

Answer / chandu

Tanks diya... it works.

What is the use of the %include statement?

0 Answers  

---

What are the new features included in the new version of SAS Programming Language?

0 Answers  

---

Mention what is PROC in SAS?

0 Answers  

---

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.

0 Answers  

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

0 Answers  

---

Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,

---

describe about metadata object? : Sas-di

0 Answers  

---

Explain how you can debug and test your SAS program?

0 Answers  

---

Difference Between Scan and Substr

2 Answers  

---

What do you feel about hardcoding?

3 Answers   Pfizer,

---

What will calendar procedure do?

0 Answers  

---

How are the analysis data sets structured?

3 Answers  

---