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 is the difference between an informat and a format. Name three informats or formats.
if x=round(26.3,10)-1 then x= how much and how explain?
Give e an example of..
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
What are the ways in which macro variables can be created in sas programming?
what is the difference between nodup and nodupkey options? : Sas programming
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
how to delete the duplicate columns permanently in SQL
How do you debug and test your SAS programs?
What is the difference between INPUT and INFILE ?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,