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

Answers were Sorted based on User's Feedback



How would you remove a format that has been permanently associated with a variable? _____________..

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

How would you remove a format that has been permanently associated with a variable? _____________..

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

How would you remove a format that has been permanently associated with a variable? _____________..

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

How would you remove a format that has been permanently associated with a variable? _____________..

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

How would you remove a format that has been permanently associated with a variable? _____________..

Answer / bhimanagouda

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

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More SAS Interview Questions

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  


if x=round(26.3,10)-1 then x= how much and how explain?

5 Answers   BoA,


Give e an example of..

0 Answers  


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

2 Answers  


How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  






What are the ways in which macro variables can be created in sas programming?

0 Answers  


what is the difference between nodup and nodupkey options? : Sas programming

0 Answers  


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

3 Answers  


how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,


How do you debug and test your SAS programs?

0 Answers   Quintiles,


What is the difference between INPUT and INFILE ?

0 Answers  


Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,


Categories