Interested to Buy Any Domain ? << Click Here >> for more details...
How would you remove a format that has been permanently
associated with a variable?
________________
- 5 Answers
- 22140 Views
- Quintiles, TCS, I also Faced
- E-Mail Answers
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 |
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
what is syntax of proc merge ?
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
Where do you use proc means over proc freq?
how does sas handle missing values in formats? : Sas programming
If a variable contains letters or special characters, can it be numeric data type?
what is broad cast agent? : Sas-bi
which features do you use to check the data validations and errors? : Sas-administrator
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
for whom is sas data integration studio designed? : Sas-di
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
Describe a time when you were really stuck on a problem and how you solved it?
Teradata 
