Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6841 Views
- Dr Reddys, Oracle, I also Faced
- E-Mail Answers
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 |
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.
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 set to a second data set, and the non-matches of the right-most data set to a third data set?
How would you include common or reuse to be processed along with your statements?
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
in which companies SAS openings are there? List of companies using SAS technology.
In SAS explain which statement does not perform automatic conversions in comparisons?
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
how do the in= variables improve the capability of a merge? : Sas programming
What are the 3 components in sas programming?
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.
is there any differnce between proc means and proc summary?
What is the difference between nodupkey and nodup options?
Teradata 
