my problem is to export my report to xsl.i can do that.but
the problem is my report has 3 headings first heading
should be printed with the merging of (1-5)cells and
heading 2 should be of merge(2-4)cells?how to do this
condition?
Answers were Sorted based on User's Feedback
Answer / ankit
may be it is possible in macros when we use index function and compress function
data value;
infile 'val.txt' DSD delimiter='09'x MISSOVER lrecl=5000 ;
informat No :best. ;
informat Name:$75. ;
format Sl :best. ;
format Name :$75. ;
input
Sl_No :best.
Name_Of_Salon :$75. @;
if index (Name_Of_Salon,'"') gt 0 then do;
input / Name_Of_Salon_a :$75. @;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vk
i think we can export the report only to III party files
like html,rtf and pdf only. But not to xls(excel).
| Is This Answer Correct ? | 2 Yes | 10 No |
What is the role of administrative users? : sas-grid-administration
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 it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
This entry was posted in General. Bookmark the permalink. Post a comment or leave
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
Can you excute a macro within a macro? Describe.
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What is the difference between an informat and a format. Name three informats or formats.
name several ways to achieve efficiency in your program? : Sas programming
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
Name statements that are recognized at compile time only?
explain the difference between proc means and proc summary?