06-13-2016
HashimBasheer
Fluorite | Level 6
Member since
07-03-2012
- 30 Posts
- 4 Likes Given
- 0 Solutions
- 4 Likes Received
-
Latest posts by HashimBasheer
Subject Views Posted 3183 04-14-2016 05:24 AM 3205 04-14-2016 02:47 AM 1260 01-14-2015 09:41 PM 1260 01-14-2015 09:33 PM 6292 01-14-2015 04:53 AM 12143 01-03-2014 07:03 AM 12143 12-30-2013 03:39 AM 12143 12-29-2013 11:54 PM 12143 12-27-2013 05:12 AM 15858 12-27-2013 05:12 AM -
Activity Feed for HashimBasheer
- Liked Re: Migration from Mainframe SAS to Linux for Kurt_Bremser. 04-14-2016 06:16 AM
- Posted Re: Migration from Mainframe SAS to Linux on Administration and Deployment. 04-14-2016 05:24 AM
- Liked Re: Migration from Mainframe SAS to Linux for Kurt_Bremser. 04-14-2016 03:10 AM
- Posted Migration from Mainframe SAS to Linux on Administration and Deployment. 04-14-2016 02:47 AM
- Got a Like for Re: SAS EG 4.2 sql error. 09-01-2015 04:24 AM
- Posted Re: Query regarding Cross tab report on SAS Web Report Studio. 01-14-2015 09:41 PM
- Posted Re: Query regarding Cross tab report on SAS Web Report Studio. 01-14-2015 09:33 PM
- Posted Query regarding Cross tab report on SAS Web Report Studio. 01-14-2015 04:53 AM
- Got a Like for How to email SAS log through code in a Scheduled EG project?. 10-10-2014 11:59 AM
- Posted Re: Issue in SAS integration with Hadoop on SAS Data Management. 01-03-2014 07:03 AM
- Posted Re: Issue in SAS integration with Hadoop on SAS Data Management. 12-30-2013 03:39 AM
- Posted Re: Issue in SAS integration with Hadoop on SAS Data Management. 12-29-2013 11:54 PM
- Posted Re: Issue in SAS integration with Hadoop on SAS Data Management. 12-27-2013 05:12 AM
- Posted Re: Hadoop connectivity issues on SAS Data Management. 12-27-2013 05:12 AM
- Posted Re: Issue in SAS integration with Hadoop on SAS Data Management. 12-26-2013 07:10 AM
- Posted Issue in SAS integration with Hadoop on SAS Data Management. 12-26-2013 03:30 AM
- Posted Re: To stop the sas code if the condition fail on SAS Programming. 08-20-2013 04:50 AM
- Posted Re: To stop the sas code if the condition fail on SAS Programming. 08-20-2013 03:35 AM
- Posted To stop the sas code if the condition fail on SAS Programming. 08-20-2013 03:25 AM
- Posted Re: How to get the SAS Usage Report? on SAS Enterprise Guide. 07-16-2013 11:58 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 2 1 4 -
My Liked Posts
Subject Likes Posted 3 01-04-2013 08:18 AM 1 07-03-2013 05:35 AM
08-13-2017
04:23 PM
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.
... View more
07-21-2017
09:40 AM
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
... View more
04-14-2016
06:01 AM
1 Like
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).
... View more
10-27-2015
05:58 PM
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
... View more
01-15-2015
10:13 AM
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.
... View more
08-20-2013
04:50 AM
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;
... View more
07-17-2013
10:24 PM
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
... View more
07-15-2013
12:05 PM
Hi, You can use the golbal macoparameter called _CLIENTPROJECTPATH, it gives the project path
... View more
03-08-2013
01:59 PM
What makes you think FAST EXPORT is causing that error? Why would SAS even call FAST EXPORT to return a single number?
... View more
01-04-2013
03:00 PM
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
... View more
10-03-2012
08:18 AM
4 Likes
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
... View more
09-27-2012
11:39 AM
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
... View more