How would you remove a format that has been permanently
associated with a variable?
________________
- 5 Answers
- 19912 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 |
What are the functions used for character handling?
what do you mean by data staging area? : Sas-di
How do i read multiple spaces in datasets?
what is SAS/Graph?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
what is sas business intelligence? : Sas-bi
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Name statements that are recognized at compile time only?
for report generation which one you used proc report or data_null_?
3 Answers Accenture, Quintiles,
What would you change about your job?
what is the difference between DUPKEY and NODUPKEY???
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
Teradata 
