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: 
HashimBasheer
‎06-13-2016
  • 30 Posts
  • 4 Likes Given
  • 0 Solutions
  • 4 Likes Received

Re: Migration from Mainframe SAS to Linux

by Fluorite | Level 6 in Administration and Deployment
‎04-14-2016 05:24 AM
‎04-14-2016 05:24 AM
Thanks Kurt. Yes this helps. Do you have any documents which I can use as reference? ... View more

Migration from Mainframe SAS to Linux

by Fluorite | Level 6 in Administration and Deployment
‎04-14-2016 02:47 AM
‎04-14-2016 02:47 AM
Hello,   Trying to do some research on migration from Mainframe to Linux. Can you please help to get some materials on the tips and tricks, best practices on this migration ... View more

Re: Query regarding Cross tab report

by Fluorite | Level 6 in SAS Web Report Studio
‎01-14-2015 09:41 PM
‎01-14-2015 09:41 PM
thanks for the response. Now I have all the period values in one column, how can I apply the different formats? I tried creatting date variables for the variables and for the ytd columns, I gave some future date so that it comes last in the sequence. But the business would like to see the YTD column as YTD_FY13-14. How wecan achieve this? I tried user defined formats. For some reasons its not getting displayed in the infomaps ... View more

Re: Query regarding Cross tab report

by Fluorite | Level 6 in SAS Web Report Studio
‎01-14-2015 09:33 PM
‎01-14-2015 09:33 PM
thanks for the response. Now I have all the period values in one column, how can I apply the different formats? ... View more

Query regarding Cross tab report

by Fluorite | Level 6 in SAS Web Report Studio
‎01-14-2015 04:53 AM
‎01-14-2015 04:53 AM
I have a requirement for a report. The output should be a crosstab report with total 3 columns. 1. Category(loan type,term loan, utlilization etc) 2. Months and yetd value(january14,february14....YTDFy1415) 3. $ amount. The problem is In the crosstab report, if I give month values as character it wont be sorted in the desired order.How can I get the columns in the corrected order? I cant use the list report for this as the Month values wil get changed on a timely basis. Is there any way if we can get the months sorted in the below order (without adding prefixes) Month values shud be sorted as below. Jan - 14 Feb -14 Mar-14 . . . YTDFY1415 ... View more

Re: Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎01-03-2014 07:03 AM
‎01-03-2014 07:03 AM
The issue is fixed. It was because of the wrong JAR files. We used the below Jar files and everything is working fine. guava-11.0.2.jar hadoop-auth-2.0.0-cdh4.3.1.jar hadoop-common-2.0.0-cdh4.3.1.jar hadoop-core-2.0.0-mr1-cdh4.3.1.jar hadoop-hdfs-2.0.0-cdh4.3.1.jar hive-exec-0.10.0-cdh4.3.1.jar hive-jdbc-0.10.0-cdh4.3.1.jar hive-metastore-0.10.0-cdh4.3.1.jar hive-service-0.10.0-cdh4.3.1.jar libfb303-0.9.0.jar pig-0.11.0-cdh4.3.1.jar protobuf-java-2.4.0a.jar ... View more

Re: Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎12-30-2013 03:39 AM
‎12-30-2013 03:39 AM
RMP thanks for your response. Please correct me if I am wrong. In libname approach do we need to point to confifg file? ... View more

Re: Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎12-29-2013 11:54 PM
‎12-29-2013 11:54 PM
Thanks Ahmed. We have the connection established between SAS and Hadoop. libname hdplib hadoop server="CSDFFGF" user="basheerh" password=XXXXXXXXXXXXX port=10001; NOTE: Libref HDPLIB was successfully assigned as follows: It seems its an issue with the configuration ... View more

Re: Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎12-27-2013 05:12 AM
‎12-27-2013 05:12 AM
Also the Jar files being used are The JAR files are guava.jar hadoop-auth-0.23.1.jar hadoop-common.jar hadoop-core.jar hadoop-hdfs-0.23.5.jar hadoop-streaming-2.0.0-mr1-cdh4.3.1.jar hive-exec-0.10.0.jar hive-jdbc-0.10.0.jar hive-metastore-0.10.0.jar hive-service-0.8.1.jar libfb303-0.7.0.jar pig.jar protobuf-java-2.4.1.jar ... View more

Re: Hadoop connectivity issues

by Fluorite | Level 6 in SAS Data Management
‎12-27-2013 05:12 AM
‎12-27-2013 05:12 AM
Hello, I am also facing a similar issue. I have posted it here. https://communities.sas.com/message/192123#192123 Results of proc javainfo picklist 'hadoop/hdoopsasjars.txt'; run; is given below. file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/sas.hadoop.hivehelper_904000.0.0.20130522190000_v940/sas.hadoop.hivehel per.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/Log4J_1.2.15.0_SAS_20121211183158/log4j.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_beanutils_1.8.2.0_SAS_20121211183319/commons-beanutils.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_collections_3.2.1.0_SAS_20121211183225/commons-collections.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_logging_1.1.1.0_SAS_20121211183202/commons-logging.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/jackson_1.9.7.0_SAS_20121211183158/jackson.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/slf4j_1.5.10.0_SAS_20121211183229/slf4j-api.jar The JAR files are guava.jar hadoop-auth-0.23.1.jar hadoop-common.jar hadoop-core.jar hadoop-hdfs-0.23.5.jar hadoop-streaming-2.0.0-mr1-cdh4.3.1.jar hive-exec-0.10.0.jar hive-jdbc-0.10.0.jar hive-metastore-0.10.0.jar hive-service-0.8.1.jar libfb303-0.7.0.jar pig.jar protobuf-java-2.4.1.jar ... View more

Re: Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎12-26-2013 07:10 AM
‎12-26-2013 07:10 AM
Naveen, Here is the result. file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/sas.hadoop.hivehelper_904000.0.0.20130522190000_v940/sas.hadoop.hivehel per.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/Log4J_1.2.15.0_SAS_20121211183158/log4j.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_beanutils_1.8.2.0_SAS_20121211183319/commons-beanutils.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_collections_3.2.1.0_SAS_20121211183225/commons-collections.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/commons_logging_1.1.1.0_SAS_20121211183202/commons-logging.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/jackson_1.9.7.0_SAS_20121211183158/jackson.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/slf4j_1.5.10.0_SAS_20121211183229/slf4j-api.jar file:/home/SASHome/SASVersionedJarRepository/eclipse/plugins/slf4j_1.5.10.0_SAS_20121211183229/slf4j-log4j12.jar Total URLs: 8 Is there anything missing? ... View more

Issue in SAS integration with Hadoop

by Fluorite | Level 6 in SAS Data Management
‎12-26-2013 03:30 AM
‎12-26-2013 03:30 AM
I am trying to integrate SAS with Hadoop. The details are below. SAS interface to Hive 9.4 Linux 2.6.32-358.2.1.el6.x86_64 (LIN X64) platform. When I am trying to create a hive table using SAS I am getting the error below libname hdplib hadoop server="XXXXXX" user="XXX" password="$XXXX" port=10001; data hdplib.class; set sashelp.class(obs=10); run; HADOOP_10: Prepared: on connection 2 37 1387861396 no_name 0 DATASTEP SHOW TABLE EXTENDED LIKE `CLASS` 38 1387861396 no_name 0 DATASTEP 39 1387861396 no_name 0 DATASTEP 40 1387861397 no_name 0 DATASTEP HADOOP_11: Executed: on connection 2 41 1387861397 no_name 0 DATASTEP CREATE TABLE `CLASS` (`Name` STRING,`Sex` STRING,`Age` DOUBLE,`Height` DOUBLE,`Weight` DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE TBLPROPERTIES ('SAS OS Name'='Linux','SAS Version'='9.04.01M0P06192013','SASFMT:Name'='CHAR(8)','SASFMT:Sex'='CHAR(1)') 42 1387861397 no_name 0 DATASTEP 43 1387861397 no_name 0 DATASTEP ERROR: java.lang.NoClassDefFoundError: Could not initialize class org.apache.hadoop.hdfs.DistributedFileSystem NOTE: Validate the contents of the Hadoop configuration file and ensure user permissions are correct. ERROR: Unable to create stream service from /tmp/sasdata-2013-12-24-00-03-17-513-e-00001.dlv. Use the debug option for more information. ERROR: Unable to create stream service from /tmp/sasdata-2013-12-24-00-03-17-513-e-00001.dlv. Use the debug option for more information. Can someone assist in resolving this issue? ... View more

Re: To stop the sas code if the condition fail

by Fluorite | Level 6 in SAS Programming
‎08-20-2013 04:50 AM
‎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

Re: To stop the sas code if the condition fail

by Fluorite | Level 6 in SAS Programming
‎08-20-2013 03:35 AM
‎08-20-2013 03:35 AM
Thanks Murray I have this option. But the issue is I have data steps after the macro. I dont want to run those data steps if the condition fail. Is there a way I can exit them as well? ... View more

To stop the sas code if the condition fail

by Fluorite | Level 6 in SAS Programming
‎08-20-2013 03:25 AM
‎08-20-2013 03:25 AM
I have a sas code which check for the value(true/false). If true continue running the code and if fails exit the sas code without running the steps after. I would like to create a macro so that i can include this as %include in all the codes. macro: check if the value is true/false if true continue the code fail exit the program ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-13-2016 04:14 AM
Likes given to
Likes from
View All
Quick links