DATA Step, Macro, Functions and more

Output in excel

Reply
New Contributor
Posts: 3

Output in excel

I have a intranet link where I login to view my reports. The code wriiten picks up data from csv files and the output my reports in normal text. I want a piece of code that will pick data from the csv files and gives the output in excel format.
Valued Guide
Posts: 2,177

Re: Output in excel

why not just use excel?
SAS Super FREQ
Posts: 8,868

Re: Output in excel

Hi:
I have annotated your question with my questions about your question. You asked:
"I have a intranet {Company intranet? SharePoint location? SAS Intr/Net? Information Delivery Portal} link where I login to view my reports{What kind of reports? Static HTML files? Reports that are prepared every night and are ready for you every morning? Reports that are produced on demand?}. The code [What kind of code? SAS code (implying SAS/IntrNet is involved)? HTML with JavaScript? PHP? JSP? C++?? .NET??}wriiten picks up data from csv files and the output my reports{What does the output? Is there any transformation from the DATA in CSV form to the REPORT??} in normal text{I don't know what you mean by "normal" text?? An ASCII text file?? A CSV file is an ASCII text file?? A Word document? An HTML page??}. I want a piece of code {Presumably SAS code??} that will pick data from the csv files and gives the output in excel format. {As Peter suggests -- this is what Excel knows how to do very well -- it will take a CSV file as input and display that CSV file in a spreadsheet/workbook form.}"

As you can see, I have question about almost everything. I'm not even sure this is a SAS question except that you have posted it on the SAS forum. Perhaps you could post some of the code that picks up the csv files and outputs the report in normal text. That would at least give us some idea of the current syntax in the program that you are looking to change.

cynthia
Ask a Question
Discussion stats
  • 2 replies
  • 129 views
  • 0 likes
  • 3 in conversation