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: 
KK_QQ
‎10-15-2018
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: can't get data from Excel file

by Calcite | Level 5 in SAS Programming
‎01-24-2017 11:39 PM
‎01-24-2017 11:39 PM
No, I can't. After I use libname, there have libref created, but it empty, there is no data. ... View more

Re: can't get data from Excel file

by Calcite | Level 5 in SAS Programming
‎01-23-2017 11:09 PM
‎01-23-2017 11:09 PM
Sorry, I mean infile ... View more

Re: can't get data from Excel file

by Calcite | Level 5 in SAS Programming
‎01-23-2017 11:07 PM
‎01-23-2017 11:07 PM
Import is working. But I feel it works more like input, create new dataset. Not like libname create a link to file.  ... View more

Re: can't get data from Excel file

by Calcite | Level 5 in SAS Programming
‎01-23-2017 10:59 PM
‎01-23-2017 10:59 PM
 libname prod xlsx "/folders/myfolders/SAS/book1.xlsx"; Log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 libname prod xlsx "/folders/myfolders/SAS/book1.xlsx"; NOTE: Libref PROD was successfully assigned as follows: Engine: XLSX Physical Name: /folders/myfolders/SAS/book1.xlsx 57 58 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 ... View more

can't get data from Excel file

by Calcite | Level 5 in SAS Programming
‎01-23-2017 12:12 AM
‎01-23-2017 12:12 AM
I am using SAS University Edition. I tried to using below statment to access excel file libname prod xlsx "/folders/myfolders/SAS/book1.xlsx"; Actually there is no error in log. But I can only see the prod libref is created but there is no way to access the data in the Excel file.    I attach the book1 file, from sheet2 you can see the result from proc contents, there is connection, but can't read data.  ... View more

Re: proc format can't create format catalog under libref using univers...

by Calcite | Level 5 in SAS Programming
‎12-28-2016 09:43 PM
‎12-28-2016 09:43 PM
Actually, it does create the format catalog, when using below code   proc format library=orion.MyFmts fmtlib; select $country; run;   proc format library=orion.MyFmts fmtlib; select $country; run; you can see the results. And when you used the format, it works. But just can't show up under the liberary.  ... View more

Re: proc format can't create format catalog under libref using univers...

by Calcite | Level 5 in SAS Programming
‎12-28-2016 09:24 PM
‎12-28-2016 09:24 PM
It's not working either if only including Orion. It suppose create format catalog. ... View more

proc format can't create format catalog under libref using university ...

by Calcite | Level 5 in SAS Programming
‎12-28-2016 09:08 PM
‎12-28-2016 09:08 PM
I used the below code to create permanent format using university edition, the log has no problem.  proc format library=orion.MyFmts cntlin=country; run;   But I can't see the catalog create under the orion, I deleted the library=orion.MyFmts, it still doesn't create format catalog uner work.   I don't know whehter it's because of university editon. can anyone help? Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-15-2018 11:20 AM
Quick links