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: 
Tal
‎06-01-2024
  • 505 Posts
  • 186 Likes Given
  • 1 Solutions
  • 18 Likes Received

Re: pie charts

by Pyrite | Level 9 in Graphics Programming
‎01-30-2013 04:31 PM
‎01-30-2013 04:31 PM
sorry but how do i output the data to the named range,i mean how do i link proc export to the named  range? ... View more

SAS ACCESS to OLE DB

by Pyrite | Level 9 in SAS Procedures
‎01-30-2013 04:23 PM
‎01-30-2013 04:23 PM
hi guys, trying to access excel through ole db as i dont have the access to pc files   libname test oledb provider="ORAOLEDB.ORACLE.1"   properties=("data source"='C:\Users\xy\Desktop\zd.xls')     provider_string=" Excel 8.0"; the error message is : tns:could not resolve the connect specifier specified Any idea  what should be changed here? ... View more

Re: pie charts

by Pyrite | Level 9 in Graphics Programming
‎01-30-2013 03:26 PM
‎01-30-2013 03:26 PM
so probably linking the charts to the data coming from sas can be done with excel macro? ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 08:48 PM
‎01-29-2013 08:48 PM
we dont have sas access to pc files  but we have to ole db.Is there a way i can import/export excel files through it? ... View more

Re: pie charts

by Pyrite | Level 9 in Graphics Programming
‎01-29-2013 08:34 PM
‎01-29-2013 08:34 PM
but then i wont be able to feed those  tabs with new data from SAS if i already have charts on them,right? ... View more

Re: pie charts

by Pyrite | Level 9 in Graphics Programming
‎01-29-2013 08:30 PM
‎01-29-2013 08:30 PM
The sheet has  tables which automatically populate from the data imported  into excel from SAS.Next to each table i am supposed to have  a chart designed based on the data coming from SAS.So i have 5 tabs,one with the tables and 4 tabs with data coming from SAS.So,as data  would be coming from SAS those charts will be updated in each of the tabs and  then i manually move them in the first tab next to the tables.Is there a way maybe i can link the  charts from the 1st tab to the charts in each of the other 4 tabs so the ones in the 1st tab get updated along with the ones in the other 4  tabs? Probably SAS cant do this as you yourself said it.  ... View more

pie charts

by Pyrite | Level 9 in Graphics Programming
‎01-29-2013 04:57 PM
‎01-29-2013 04:57 PM
hi guys, i need to export pie charts from SAS into an excel file.Can anyone please share a nice code for resizing charts and exporting them to excel? Is there also a  macro code that would export the charts to a certain spot of the excel worksheet? Thanks, ... View more

Re: sql with group by

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 02:29 PM
‎01-29-2013 02:29 PM
actually today() worked from work did not work at home,..Weird but thanks  ,thank you! ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 10:42 AM
‎01-29-2013 10:42 AM
yeaa  but that works too Thanks  for all your  help Anca and team, ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 10:29 AM
‎01-29-2013 10:29 AM
but i cant export an excel file.I tried it before.We dont have sas access here ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 10:14 AM
‎01-29-2013 10:14 AM
thank  you guys, i do need all the query outputs to be on different worksheets of one excel file so i can have my  table populated easily but i guess ODS TAGSETS.EXCELXP would be the only way to do so? ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 10:09 AM
‎01-29-2013 10:09 AM
yea  i did,still the same error.Probably "sheet" cant be used with csv as DBailey said ... View more

Re: proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 10:06 AM
‎01-29-2013 10:06 AM
hmm, so any idea how to export csv  files except through  the wizard? ... View more

proc export

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 09:53 AM
‎01-29-2013 09:53 AM
they dont have sas access at work so i have to convert the file to csv before  export it but i get errors this is the code  i am writing: proc export data=mylib.susp_reasons_previous outfile=  'C:\Users\tiliev\Desktop\report.csv' replace;      sheet='susp_reasons_previous';run; and this is the error  i am  getting: 1259  proc export data=mylib.susp_reasons_previous outfile=  'C:\Users\tiliev\Desktop\report.csv' 1259!  replace; NOTE: The previous statement has been deleted. 1260  sheet='susp_reasons_previous';       -----       180 ERROR 180-322: Statement is not valid or it is used out of proper order. Does anyone see what i am  doing wrong here,pleasE? ... View more

Re: sql with group by

by Pyrite | Level 9 in SAS Procedures
‎01-29-2013 09:46 AM
1 Like
‎01-29-2013 09:46 AM
1 Like
thanks Jagadish will check it again when i get a moment ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-01-2024 03:49 PM
Likes given to
Likes from
View All
Quick links