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: 
Mike_Davis
‎09-01-2015
  • 222 Posts
  • 5 Likes Given
  • 0 Solutions
  • 11 Likes Received

Re: How to convert hexadecimal to character?

by Fluorite | Level 6 in SAS Procedures
‎08-10-2012 03:47 PM
3 Likes
‎08-10-2012 03:47 PM
3 Likes
here is my ugly method: please advise I hope there is a function could be use directly. Thanks data table;       do ascii=0 to 255;             char=byte(ascii);             put ascii= char=;             hex=put(char,$HEX.);    output;       end; run; data have; input hex $; cards; 4D 4F 76 23 20 28 24 47 6B 52 ; run; proc sql noprint; create table want as select a.*,b.char from have as a left join table as b on a.hex=b.hex ; quit; ... View more

How to convert hexadecimal to character?

by Fluorite | Level 6 in SAS Procedures
‎08-10-2012 03:23 PM
‎08-10-2012 03:23 PM
Hello everyone, I have a data set  has a hexadecimal variable,I want to convert it  into character,please advise.(for example 6B should convert to k) for your reference,the following website list the ralationship of hex and character. http://www.asciitable.com/ Thanks Mike. data have; input hex $; cards; 4D 4F 76 20 28 6B ; run; ... View more

Re: How to make use of a variable in array definition

by Fluorite | Level 6 in SAS Procedures
‎08-10-2012 10:29 AM
‎08-10-2012 10:29 AM
Thank you Ksharp! I will be very appreciate if you run the SAS code as follow: data one; a='ABCDE'; LEN=length(a); array aa $ x1-x5; do i=1 to length(a); j=substr(a,i,1); aa=j; end; drop i j len; run; my expect result is I don't want to use " array aa $ x1-x5;" I want to use a variable instead of an exact number to express the up-bond of the array. such as I want use:"array aa $ x1-x||length("ABCDE");" I know hash is a very nice tool for join tables but I don't have any sense of making a connection between this problem with hash, This sounds very interesting to me. Would you like to share your idea with me? I am very appreciate about it! Thanks a lot! Mike ... View more

Re: How to make use of a variable in array definition

by Fluorite | Level 6 in SAS Procedures
‎08-10-2012 10:05 AM
‎08-10-2012 10:05 AM
Thank you Art, Very impressive  method! In my understanding,Does the essence of the call execute is treating these data step parts as strings and doing character operation such as using "||" to connect strings. then execute it? Thanks Mike ... View more

How to make use of a variable in array definition

by Fluorite | Level 6 in SAS Procedures
‎08-09-2012 05:23 PM
‎08-09-2012 05:23 PM
Helo everyone, I have the SAS code: data one; a='ABCDE'; LEN=length(a); array aa $ x1-x5; do i=1 to length(a); j=substr(a,i,1); aa=j; end; drop i j len; run; but I want to change the code to make use of variable LEN as part of definition of array , like:(I don't want to use x1-x5 here) data one; a='ABCDE'; LEN=length(a); array aa $ x1-x||length(a);/***Here is the problem*****/ do i=1 to length(a); j=substr(a,i,1); aa=j; end; drop i j len; run; Please advise me , Thanks! Mike ... View more

Re: How to use x command open Excel at background(invisible)

by Fluorite | Level 6 in SAS Procedures
‎08-09-2012 03:25 PM
‎08-09-2012 03:25 PM
Thank you Art, also I found an option works well ,but just for mininize ,can't run at background or invisible: options noxwait noxsync xmin; ... View more

Re: what format to express SAS date like this Jan012012

by Fluorite | Level 6 in SAS Procedures
‎08-07-2012 11:15 AM
‎08-07-2012 11:15 AM
I believe &sysdate value is the date of the SAS section opened.not the current time.if the SAS section has opened for a long time, this value could not express the current date we need. Thank you Mike ... View more

Re: what format to express SAS date like this Jan012012

by Fluorite | Level 6 in SAS Procedures
‎08-07-2012 11:12 AM
‎08-07-2012 11:12 AM
Thanks Art, 1.%put %sysfunc(compress("abc_%sysfunc(date(),worddate12.)"," ,")); 2.%put abc_%sysfunc(date(),Monname3)%sysfunc(strip(%sysfunc(date(),day)))_%sysfunc(strip(%sysfunc(date(),year))); ... View more

what format to express SAS date like this Jan012012

by Fluorite | Level 6 in SAS Procedures
‎08-07-2012 09:33 AM
‎08-07-2012 09:33 AM
Hello everyone I can use %put %sysfunc(date(),monyy7);     to give a date format like  AUG2012,but this doen't include date what format we can use to express date like  AUG082012?? Thanks Mike ... View more

How to check what data sets locate in a SAS library

by Fluorite | Level 6 in SAS Procedures
‎08-03-2012 05:54 PM
‎08-03-2012 05:54 PM
Hi guys Could anyone tell me how to check what datasets located in a SAS folder such as WORK or sashelp. I want to see the whole list of all dataset's names in sashelp folder Thanks ... View more

Re: Could we change the program title?

by Fluorite | Level 6 in SAS Procedures
‎08-03-2012 04:31 PM
‎08-03-2012 04:31 PM
HI art, I think the code will be work well  in SAS /AF. But I don't the package. Thanks a lot! Mike ... View more

Re: How to use x command open Excel at background(invisible)

by Fluorite | Level 6 in SAS Procedures
‎08-03-2012 12:26 PM
‎08-03-2012 12:26 PM
Thank you Art, The PUT function works well to minimize  a new opened excel file. but how to minimize Excel console before opened an excel file? because if we want to open a excel file ,at first we should open Excel console firstly use one of  the following SAS codes: options noxwait noxsync; x '"C:\Program Files\Microsoft Office\Office12\EXCEL"'; or: OPTIONS NOXWAIT NOXSYNC; DATA _NULL_; RC=SYSTEM('START EXCEL'); RC=SLEEP(5); RUN; what I want to minimize firstly is the Excel console. Thank you! Mike ... View more

How to open Excel at background(invisible)

by Fluorite | Level 6 in SAS Procedures
‎08-03-2012 11:45 AM
‎08-03-2012 11:45 AM
Hello everyone, I know we can use SAS x command to open outside file or application such as Excel using code 1 as follow: Also we can use another method to open excel :see code 2 My question is Could we open Excel in background? I mean open excel at invisible status,,,if this is not available,,, open  excel at its minimized window status will be another alternative solution. Because I don't want the opened excel appear and cover our SAS console. Thanks Mike code1: options noxwait noxsync; x '"C:\Program Files\Microsoft Office\Office12\EXCEL"'; code 2: OPTIONS NOXWAIT NOXSYNC; DATA _NULL_; RC=SYSTEM('START EXCEL'); RC=SLEEP(3); RUN; ... View more

Re: Problem of import a 2003 excel file with password into SAS if use ...

by Fluorite | Level 6 in SAS Procedures
‎08-03-2012 09:58 AM
‎08-03-2012 09:58 AM
Thank you Art,this works ! ... View more

Problem of import a 2003 excel file with password into SAS if use macr...

by Fluorite | Level 6 in SAS Procedures
‎08-02-2012 05:25 PM
‎08-02-2012 05:25 PM
Hello everyone, I try to open a password protected excel file as the following SAS code,,,everything works but only problem will happen when I try to use macro variable denotes the password. Suppose the password of the excel file c:\temp\book1.xls  is abcdefg. Please look into SAS code ,I add my question there at ""s = '[open(' || quote ("c:\temp\book1.xls.") ||',,,,"abcdefg")]';""   (I want use macro variable express abcdefg will cause problem). Thanks Mike options noxwait noxsync;     x '"C:\Program Files\Microsoft Office\Office12\EXCEL"';     data _null_;         x=sleep(3);     run;     filename ExcelCmd dde 'Excel|system';     data _null_;       file ExcelCmd;       length s $200;       s = '[open(' || quote ("c:\temp\book1.xls.") ||',,,,"abcdefg")]'; /*-------------My question is here,the password is "abcdefg",but I want use a macro variable replace the real password,such as  I want use %let pw=abcdefg,and here I use &pw instead of abcdefg,but a problem will happen-----------------------*/       put s;     run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Likes from
View All
Quick links