About HashimBasheer

SASKiwi · ‎08-13-2017

The example code supplied runs on a PC where the email client uses Windows Authentication to access so no user/password is required. If your requirements are different please let us know what they are.

AnnaBrown · ‎07-21-2017

Hi swetawasthisas, While your reply relates to this thread, it is a slightly different problem and this thread is already solved. It's best to open up a New Message on the community to keep the entire topic focused on your scenario. Many thanks, Anna

Kurt_Bremser · ‎04-14-2016

We have no documents any more. You see, this was done here sometime before 2000, with SAS 6.9 on the MF and 6.11 on Reliant UNIX, with a subsequent migration to 6.12 on AIX. What I told you comes from the back of my head and some consulting of wikipedia (regarding peculiarities of the EBCDIC character set).

fatcat · ‎10-27-2015

Hi, i am trying to connect to Hortonworks using SAS/Access for Hadoop. I compared the jar files and they look good (versions slightly different as they were provided by the Hadoop admin). I am able to get a kilist from the SAS Client machine (server) and even ssh to the nodes. But when i run a libname from SAS EG, i am getting this: libname zhdplib hadoop subprotocol='hive2' server='myserver' schema=myschema user='user123' pwd='test123'; ERROR: Unable to connect to the Hive server. ERROR: Error trying to establish connection. ERROR: Error in the LIBNAME statement. thanks, Alex

ballardw · ‎01-15-2015

The method may depend, or be more specific, if you can show how you are generating the crosstab. There are different approaches depending on the procedure used.

HashimBasheer · ‎08-20-2013

I feel like we have 2 options. 1. Bring all the steps into the macro and then use goto/getout to exit the code. %macro validation; %if condition %then %do; %goto getout; %end; % else %do; steps1l steps2; %end; 2. Two macros. one for checking the conditions and then triggering the datasteps which can be saved in another macro ; %macro validation; %if condition %then %do; %goto getout; %end; % else %do; call all the steps as new macro %end;

twocanbazza · ‎07-17-2013

I understand you can request from Tech support (for Free) but always best to check with SAS. We implemented it and there are some sample reports, however we generally do some ad-hocs against the datasets to query what we want - with that said out of the box is a good start You could do it all yourself as it is all SAS code but why re-invent the wheel, install APM and use/modify what you need. I haven't looked at 9.4 and whta is avaliable though someone else may be able to answer that. Barry

kmel56 · ‎07-15-2013

Hi, You can use the golbal macoparameter called _CLIENTPROJECTPATH, it gives the project path

Tom · ‎03-08-2013

What makes you think FAST EXPORT is causing that error? Why would SAS even call FAST EXPORT to return a single number?

TomKari · ‎01-04-2013

OVER is a feature of SQL 2003 that SAS hasn't implemented at this point, that allows for "Determining the partitioning and ordering of a rowset before the associated window function is applied." (I've never used it myself). You'll have to either restructure your query for SAS, or, if your query is to an exernal database, use pass-through to pass the OVER clause to the database. Tom

ChrisHemedinger · ‎10-03-2012

There isn't a built-in method in EG 4.2 for this. If you have the SAS Add-In for Microsoft Office, you can "pull" SAS results into any worksheet and retain your desired layout and formatting. See other code-based methods here: How do I export from SAS to Excel files: Let me count the ways - The SAS Dummy Chris

ChrisHemedinger · ‎09-27-2012

PC Files Server is alive and well, and serves an essential role for bridging 32-bit data providers with 64-bit SAS: Blog post here: How do I export from SAS to Excel files: Let me count the ways - The SAS Dummy Doc here: http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n0x9m8qzgy67xqn12cs2tq3dvpa3.htm Chris

Online Status	Offline
Date Last Visited	‎06-13-2016 04:14 AM

Re: Migration from Mainframe SAS to Linux

Migration from Mainframe SAS to Linux

Re: Query regarding Cross tab report

Re: Query regarding Cross tab report

Query regarding Cross tab report

Re: Issue in SAS integration with Hadoop

Re: Issue in SAS integration with Hadoop

Re: Issue in SAS integration with Hadoop

Re: Issue in SAS integration with Hadoop

Re: Hadoop connectivity issues

Re: Migration from Mainframe SAS to Linux

Re: Migration from Mainframe SAS to Linux

Re: SAS EG 4.2 sql error

Re: Does SAS EG42 have the capability to export to a fixed excel templ...

Re: SAS EG 4.2 sql error

How to email SAS log through code in a Scheduled EG project?

Re: How to email SAS log through code in a Scheduled EG project?

Re: Hadoop connectivity issues

Re: Migration from Mainframe SAS to Linux

Re: Issue in SAS integration with Hadoop

Re: Query regarding Cross tab report

Re: To stop the sas code if the condition fail

Re: How to get the SAS Usage Report?

Re: How to retrieve the folder name of the EG project file?

Re: Is FastExport is a viable option when downloading data from Terada...

Re: SAS EG 4.2 sql error

Re: Does SAS EG42 have the capability to export to a fixed excel templ...

Re: Does EG have the capability of reading CSV files from local drive?