Hello everyone, I want to count how many specified letter in a string, such as: %let have=123#45#678#9; we need to count how many '#' in the string. in this case there are total three '#' in the string. Thanks data one; a="123#45#678#9"; b=somefunction(a,'#'); run;
... View more
Hello everyone, How to deal with string to keep only numeric and comma? such as %let a=asd1,2,ggg3,678,thy%@#@; I just need b=1,2,3,678 Thanks; data one; a="asd1,2,ggg3,678,thy%@#@;"; b=somefunction(a,'0123456789,'); run;
... View more
Hi, I attached a more clear picture,This is a screen shoot of excel file create by the SAS code. 'Before' part are the orginal output file. 'After ' part are the part used with no fill under excel(which are what I need to be generated directly by SAS). Thanks Mike
... View more
Thank you ! I attached another picture here, After use the code to generate the excel file,I have to open it in excel and I need to change the background color to no fill(please see the picture I attached below). Is there any way to create the same excel file in SAS instead of changing in excel manually? Thanks Mike
... View more
Thank you! This ods tagsets.excelxp output(style=sasweb) is very great, only one thing need to be mentioned: how to get the excel file change to no background color(use the most simple style but only with specialf font) in SAS ? Thanks! Mike
... View more
Hello everyone, Does anyone has idea of creating output excel file without replace but append to original file? usually specify REPLACE in proc export will override the whole excel file. but I want to keep the original rows, just want to add new rows to the excel file. Thanks! Mike Example code: %macro append; %do i=1 %to 5; data have&i; seq=&i; run; PROC EXPORT DATA=have&i OUTFILE = "c:\temp\append.xls" DBMS = EXCEL2002 ; SHEET = "class"; RUN; %end; %mend append; %append;
... View more
Helo everyone, Is that possible we can use proc export to generate an .xls(excel 2003) file with specified font, such as "Calibri"? I want the output excel file use font: "Calibri". the default font of my output file is "MS Sans Serif",looks not good. Thanks Mike PROC EXPORT DATA=sashelp.class OUTFILE = "c:\temp\sashelpclass.xls" DBMS = EXCEL2002 REPLACE; SHEET = "sashelpclass"; RUN;
... View more
Please give me some advise, thanks! Mike data need(keep=date date2 ); set have; month=scan(date,1); year=scan(date,2); temp1=cats('01',substr(month,1,3),year); date2=input(temp1,date9.); format date2 mmddyys10.; run;
... View more
Hello everyone, I have a dataset with a character variable whose name is date,it looks like this: April 2000. I want to convert this variable to a standard numerical SAS date variable like 04/01/2000 or '01Apr2000'd. please advise. Thanks! Mike data have; length date $15.; date='April 2000';output; date='March 2001';output; run;
... View more
Thank you Mike If we have dataset like this:(not numbers but characters),how to do it in this way? Thanks! Mike data have; input a $7.; cards; aaaaaa bbbbb cccc ;
... View more
Hello everyone, I have two questions: Thanks! 1. How to use string function to find the first none 'x' letter? data have; value='xxasdxfg';output; value='xxxxqwerxxt';output; run; data need; value asdxfg qwerxxt 2. how to use string function keep the last N digit? data have; x='123456789'; run; data want; set have; x2=substr(x,-4); /*I need x2=6789,the last four digits of x*/ run;
... View more
Hello everyone, Please advise on create dataset two base on dataset one. finally make all the value with 7 digit, use '0' to fill the left rest part. Thanks! Mike data one; input x $10. y $10.; cards; 35179 31804 35178 31804 0032549 31743 0037096 31743 0036617 31743 0035190 31743 0035190 31743 0032549 31743 0032549 31743 35089 100240 35089 100240 35089 100240 0035009 31747 35056 107240 35089 100240 ; run; data two 0035179 0031804 0035178 0031804 0032549 0031743 0037096 0031743 0036617 0031743 0035190 0031743 0035190 0031743 0032549 0031743 0032549 0031743 0035089 0100240 0035089 0100240 0035089 0100240 0035009 0031747 0035056 0107240 0035089 0100240
... View more
Hello everyone, there is a column A whoes format is $7, I want create a new column B with $10. the rule of create B is fill 'x' on the left side of A. Thanks Mike for example: 1. in column A,a row has value '12345' I want to create B with value 'XXXXX12345' ($10.) 2. in column A,a row has value '1234567' I want to create B with value 'XXX1234567'($10.)
... View more
