cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ronein
3 hours ago
  • 2,422 Posts
  • 887 Likes Given
  • 22 Solutions
  • 58 Likes Received

export multiple SAS outputs to one excel file and one sheet.

by Onyx | Level 15 in SAS Programming
‎10-09-2017 07:45 AM
‎10-09-2017 07:45 AM
Hello Can someone tell me how to export multiple SAS outputs to one excel file and one sheet. I want that the outputs will be  side by side in one excel sheet.   thanks You   ... View more

export multiple tables to one excel file with one sheet (tables are ...

by Onyx | Level 15 in ODS and Base Reporting
‎10-09-2017 07:16 AM
‎10-09-2017 07:16 AM
Hello I want to export  3 tables  to one excel file with one sheet only where tables are  side by side . When I run my code 3 different excel sheets are created but I want to have only one sheet.     ods path work.temptemp(update) sasuser.templat(update) sashelp.tmplmst(read); ods path show; ods tagsets.excelxp file="/usr/local/SAS/MidulOld/UserDir/Example.xls" style=htmlblue;   ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a1; input x y; cards; 1 10 2 20 3 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a2; input x y; cards; 4 10 5 20 6 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a3; input x y; cards; 7 10 8 20 9 30 ; Run;       ... View more

export multiple tables to one excel file with one sheet (tables are ...

by Onyx | Level 15 in ODS and Base Reporting
‎10-09-2017 07:15 AM
‎10-09-2017 07:15 AM
Hello I want to print 3 tables  side by side in one excel sheet. When I run my code 3 different excel sheets are created but I want to have only one sheet.     ods path work.temptemp(update) sasuser.templat(update) sashelp.tmplmst(read); ods path show; ods tagsets.excelxp file="/usr/local/SAS/MidulOld/UserDir/Example.xls" style=htmlblue;   ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a1; input x y; cards; 1 10 2 20 3 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a2; input x y; cards; 4 10 5 20 6 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a3; input x y; cards; 7 10 8 20 9 30 ; Run;       ... View more

Re: Import Excel file into SAS

by Onyx | Level 15 in SAS Programming
‎10-01-2017 12:51 AM
‎10-01-2017 12:51 AM
Thank you but how your information vam help me to solve the problem? What action is required that the client will the import code in daily base without error that phsical file doesn't exist ... View more

Re: Import Excel file into SAS

by Onyx | Level 15 in SAS Programming
‎10-01-2017 12:48 AM
‎10-01-2017 12:48 AM
The excel file as same name every day and just the data is different every day. The client will upload every day a new file. The excel file is on a shared drive . I didnt understand how IT admin can help me? Please explain what action is required? ... View more

Import Excel file into SAS

by Onyx | Level 15 in SAS Programming
‎09-30-2017 03:17 AM
‎09-30-2017 03:17 AM
Hello I am using SAS Enterprise. I am trying to import  Excel file (Xlsx) into SAS enterprise. The excel File contain only one spreedsheet . The columns headers of excel file are not in Egnlish and the user who created the excel file cannot change it to English.   I use import wizard to import the excel file and SAS print the code in the lof window. I took the code and changed the columns names to English and all is fine and suceesfully imported the excel file.   The problem is that when I use the code again (Next day or when I close SAS and open SAS again)  then it won't work. The error is "physical file does not exist"   It is a big problem because my client should Run the code in daily base and just upload a new excel file with same name everyday.   Can you please suggest a solution? Thanks     ... View more

import date data from excel

by Onyx | Level 15 in SAS Programming
‎09-02-2017 05:59 AM
‎09-02-2017 05:59 AM
Hello I am using data step to import data from excel. I have 1 column with date values that are displayed in excel with "Number " format. (For example : in excel value 42980 represnt  02SEP2017 In sas data step i define the date varaible as a numeric and give a format ddmmyy10. The problem is that the date appears in SAS is not 02SEP2017!   I found a solution to change the format in excel to 3/14/2001 (means  mm/dd/yyyy). The problem is that my client doesn't want to change the format in excel.   Can you offer me a solution ? ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-02-2017 02:23 AM
‎09-02-2017 02:23 AM
Thank you Tom. What is the solution? ... View more

Re: Dates

by Onyx | Level 15 in SAS Programming
‎09-01-2017 04:31 PM
‎09-01-2017 04:31 PM
The orignal data in dates columns in excel is with numeric format. For example 9876 .when i report it from excel into sas i wamt to get numeric value with ddmmyy10. Format ... View more

Dates

by Onyx | Level 15 in SAS Programming
‎09-01-2017 03:20 PM
‎09-01-2017 03:20 PM
Hello I import excel data into sas. In excel there are some dates columns with numeric format. When i import it into sas i define format ddmmyy10. And get error dates that were not conerted correctly. When i change format of dates in excel to mmddyy then all is fine in sas import. The problem is that my client doesn't want to convert excel format into mmddyy and want to leave it with numeric format. My question-How can I import into sas excel date fields with numeric format in excel?? ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-01-2017 02:54 PM
‎09-01-2017 02:54 PM
I will be at work on Sunday and will explain more. As I said excel file is located on a shared network. ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-01-2017 12:15 PM
‎09-01-2017 12:15 PM
As I understand you recommended to save the excel files as csv comma delimited files (csv) and use data step to import them into sas. There is still problem with path on infile statement. Why each time i use import wizard (that create import code in data step version) i get different paths?? Is it because sas run in linux and not windows? ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-01-2017 09:23 AM
‎09-01-2017 09:23 AM
Is it another way to import excel files? What should be the path on the libname statement? ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-01-2017 09:22 AM
‎09-01-2017 09:22 AM
Thank you so much. It is first time i hear about excel libname. What is the purose and advantage of it? ... View more

Re: Import excel (Excel workbook type) File into SAS

by Onyx | Level 15 in SAS Programming
‎09-01-2017 08:53 AM
‎09-01-2017 08:53 AM
Excel workbook type (I think it is xlsx type) ... View more
Contact Me
Online Status
Offline
Date Last Visited
3 hours ago
Group Hubs for Ronein
View All
Likes given to
Likes from
Quick links