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 are the statements that are executed only?
In ARRAY processing, what does the DIM function do?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
What is the use of PROC gplot?
What are the data types in sas?
differnce between 8.2 and 9.1.3
Why double trailing @@ is used in input statement?
how can you import .csv file in to sas? : Sas programming
Mention how to limit decimal places for the variable using proc means?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
Can you explain the process of calendar?