Advanced Search

Return to Snippet

Revision: 13629
at April 29, 2009 17:42 by statsplank
Initial Code 
/* Import from Excel */
PROC IMPORT OUT= test  
            DATAFILE= "D:\May08\Final.xls" 
            DBMS=EXCEL REPLACE; 
            SHEET="Final Data$"; 
            GETNAMES=YES; 
            MIXED=Yes; 
            SCANTEXT=YES; 
            USEDATE=YES; 
            SCANTIME=YES;
RUN;


/* Export to Excel */
PROC EXPORT DATA= P.FINAL_CALC 
            OUTFILE= "D:\Feb09\sas\Final.xls" 
            DBMS=EXCEL REPLACE;
RUN;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Import from and Export to Excel

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
excel

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SAS