Answer / name is no need

we can remove the format by using procdatasets:


Procdatasets;
modify <data set name>;
format <variable name>(which variable format needs to
modify>;
run;
quit;

Answer / lakshmi

1. To remove formats permenantly then use this code in data
step,

data data2;
set data1;
format _all_; /* To remove format */
informat _all_; /* To remove informat */
run;

2. To remove formats permenantly then use this code in proc,
proc sort data=data1;
by subject;
format _all_;
run;

Answer / neel

There is also an another way.

data a;
attrib var1 label='Desired Label' format=desiredformat.;
set b;
run;

In this case the format associated with variable var1 in
dataatset b will be changed permanently in dataset a.

Answer / sonu

proc datasets library=<library name where the dataset has been stored>;
modify <dataset name>;
format <variable name>;
run;

Answer / bhimanagouda

Use the previous format...So u can delete the new one

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.

7 Answers   Accenture,

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

0 Answers  

How would you remove a format that has been permanently associated with a variables?

3 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.

1 Answers  

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

Describe the ways in which you can create a macro variable?

0 Answers  

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,

What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,

how can u create zero observation dataset?

11 Answers   CitiGroup,

What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,

how do u identify a macro variable

5 Answers  

what is sas enterprise intelligence architecture? : Sas-bi

0 Answers