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?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between INPUT and INFILE ?
How sas treats the dsd delimiters?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What is run-group processing?
What do you code to create a macro? : sas-macro
Explain what is data step?
Differentiate between proc means and proc summary.
what type of graphs we will create(for 2+years candidates)?
Explain proc sort?
How do you specify the number of iterations and specific condition within a single do loop?
Compare sas with other data analytics tools.
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What function CATX syntax does?
what is change analysis in sas di ? : Sas-di
What do the SAS log messages "numeric values have been converted to character" mean?