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 |
Describe 5 ways to do a “table lookup” in SAS?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
what has been your most common programming mistake? : Sas programming
What are the different versions of sas that you have used until now? : sas-grid-administration
what is snowflake schema? : Sas-di
what is treatment emergent events and treatment emregent adverse event
In ARRAY processing, what does the DIM function do?
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?
How can you create a macro variable with in data step? : sas-macro
diff between nodup rec and ondup key???
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Name some categories in sas 9? : sas-grid-administration