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 |
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
At compile time when a SAS data set is read, what items are created?
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
% let A=3+4 what is result
what is p-value
3 Answers Accenture, Quintiles, Sristek,
How do you add a number to a macro variable?
How would you delete duplicate observations?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
What is proc sort?
What are the table names in oracle database...?
What are the uses of sas?