How would you remove a format that has been permanently
associated with a variables?
Answers were Sorted based on User's Feedback
Answer / sunymuny
proc datasets;
Modify Employee;/*Dataset name*/
Format lname ;/* Name of variable you want to remove format
from*/
run;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sandeep
proc datasets;
modify <dataset name>;
format <variable name>;
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
why a stop statement is needed for the point= option on a set statement?
How would you code the criteria to restrict the output to be produced?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
I have a dataset concat having variable a b & c. How to rename a b to e & f?
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
What is the function of Stop statement in a SAS Program?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
explain what is factor analysis? : Sas-administrator
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.
Which command is used to save logs in the external file?
How to create an external dataset with sas code?