How would you remove a format that has been permanently
associated with a variable?
________________
Answers were Sorted based on User's Feedback
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;
| Is This Answer Correct ? | 22 Yes | 2 No |
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;
| Is This Answer Correct ? | 6 Yes | 2 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sonu
proc datasets library=<library name where the dataset has been stored>;
modify <dataset name>;
format <variable name>;
run;
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / bhimanagouda
Use the previous format...So u can delete the new one
| Is This Answer Correct ? | 0 Yes | 8 No |
what can you learn from the sas log when debugging? : Sas programming
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
What is proc sort?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
what are the types of interactive display types? : Sas-bi
how can u extract,transform and loading?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
where to use sas business intelligence? : Sas-bi
AE datasets names? how many types?
How to convert .xls file into CSV format?
What are the difference between sas functions and procedures?
what is the use of sas management console? : Sas-di