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 are the difference between ceil and floor functions in sas?
what versions of sas have you used (on which platforms)? : Sas programming
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Mention what is the difference between nodupkey and nodup options?
what is fact table and factless table?
how can you import .csv file in to sas? : Sas programming
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
How to do user inputs and command line arguments in SAS? D&B
What is substr function?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.