Thursday, 6 October 2011

Capture the data from external files: (txt).

Data ae;
Infile '\\sasserver\sas\source\dlm\ae.txt';  /*( path)*/
Input  pid visit aetype $;
Run;

Data customers;
Infile '\\sasserver\sas\source\dlm\ae.txt'; /*( path)*/
Input custno $ bcode $ pcode $ month goods;
Run;

Data process (data pro):
Source -------> extract ------> data cleaning -------> transformation -------> 
target(DW)  -------> analysis -------> report

Reporting:  SAS generates 3 types of reports.
               1. Detail report.
               2. Summarized report. 
               3.Customized report.
Detail Report: Generate report without analytical process (in pharma this can be called listing) .

1.Summarized Report: Run analytical process and generates reports (in  pharma can be called tables) .

2.Customized Report: To do modification and generate report in more efficient  format (in pharma can be called figures).

Generate Detail Report:
Print Procedure: Generates reports in output window. Procedure Block must be closed with run or quit  statement.

proc print data=customers;
Run;

No comments:

Post a Comment