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
- 21910 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 |
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
How does the internal authentication work in sas? : sas-grid-administration
explain the main difference between the nodup and nodupkey options? : Sas-administrator
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
What is Linear Regression?
What is SAS?
What are Dashboard reports?And significance of these in analysis?
What is the difference between proportion and average?
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
What is a macro routine?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Name and describe few sas character functions that are used for data cleaning in brief.
Teradata 
