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

What is substr function?

0 Answers  

To what type of programms have you used scratch macros?

0 Answers   Novartis,

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  

how can you sort the dataset having millions of OBS(instead of sort procedure?

4 Answers   EXL,

what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,

What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

0 Answers  

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  

why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

What is SAS? What are the functions does it performs?

0 Answers  

What do you know about symput and symget?

0 Answers