how to use string function to choose rows whose variable including special letters? Thanks Mike Example: want keep rows whose name including'Jo' or 'Ro'; data need ; set sashelp.class; if find(name,'Jo','Ro'); run; ... View more

Hello everyone, How to make the popup windows stay on the toppest(on the top of any other windows,so no other windows will cover this window). Thanks. Mike example:   data _null_;     window login irow=5 icolumn=5 rows=16 color=cyan columns=60     #1 "This is alway on the top."         ;     display login blank;     stop;   run; ... View more

Hello everyone, In a dataset, I want to copy some rows base on condition, such as in SAShelp.class,i want make copy of rows whose age is 15, that means in the following dataset,I want rows 8,14,17,19(Janet,Mary,Ronald,William) ocurr twice(and maybe three times).  Thanks! Mike Original dataset: Obs Name Sex Age Height Weight 1 Alfred M 14 69.0 112.5 2 Alice F 13 56.5 84.0 3 Barbara F 13 65.3 98.0 4 Carol F 14 62.8 102.5 5 Henry M 14 63.5 102.5 6 James M 12 57.3 83.0 7 Jane F 12 59.8 84.5 8 Janet F 15 62.5 112.5 9 Jeffrey M 13 62.5 84.0 10 John M 12 59.0 99.5 11 Joyce F 11 51.3 50.5 12 Judy F 14 64.3 90.0 13 Louise F 12 56.3 77.0 14 Mary F 15 66.5 112.0 15 Philip M 16 72.0 150.0 16 Robert M 12 64.8 128.0 17 Ronald M 15 67.0 133.0 18 Thomas M 11 57.5 85.0 19 William M 15 66.5 112.0 dataset needed: Obs Name Sex Age Height Weight Alfred M 14 69.0 112.5 Alice F 13 56.5 84.0 Barbara F 13 65.3 98.0 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 James M 12 57.3 83.0 Jane F 12 59.8 84.5 Janet F 15 62.5 112.5 Janet F 15 62.5 112.5 Jeffrey M 13 62.5 84.0 John M 12 59.0 99.5 Joyce F 11 51.3 50.5 Judy F 14 64.3 90.0 Louise F 12 56.3 77.0 Mary F 15 66.5 112.0 Mary F 15 66.5 112.0 Philip M 16 72.0 150.0 Robert M 12 64.8 128.0 Ronald M 15 67.0 133.0 Ronald M 15 67.0 133.0 Thomas M 11 57.5 85.0 William M 15 66.5 112.0 William M 15 66.5 112.0 ... View more

Hello everyone, Why if I use (5 or 6 )to replace (3 and 4) will NOT get 'a' in the SAS log? Thanks! Mike /*1.*/%let g=2; /*2.*/%let cc3=a; /*3.*/%let k= %eval(&g+1); /*4. */%put &&cc&k; /*5.*/%put &&cc%eval(&g+1); /*6.*/%put &cc%eval(&g+1); ... View more

hello everyone, How i can read excel file into SAS only from special col and row to special col and row? if the excel file I want read from E 10 to  K20. Thanks Mike the code like: proc import out=one datafile=''c:\temp\a.xls" DBMS=excel replace; sheet="aa$"; StartRow=10, StartCol=E, EndRow=20, EndCol=K, ..... ... View more

Hello everyone, I want ask SAS to read content of a website,at first I use the example as below: filename foo url     'http://support.sas.com/techsup/service_intro.html';      data _null_;    infile foo length=len;    input record $varying200. len;    put record $varying200. len;    if _n_=15 then stop; run; this is an example of SAS,but when I run the code ,error happened as the log show: ERROR: Hostname support.sas.com not found. please advise. Thanks! Mike ... View more

Hello everyone, when I use proc import excel file(.xls) into SAS ,some cells with very long character will be trimed after they come to SAS dataset. how to fix it? Thanks! Mike PROC IMPORT OUT= one DATAFILE= "c:\new\process.xls" DBMS=EXCEL REPLACE; SHEET="detail$"; GETNAMES=YES; MIXED=YES; USEDATE=YES; SCANTIME=YES; RUN; ... View more

Hello everyone, why It will cause an error in the first data step while the second data step is ok? Thanks! Mike data _null_; set sashelp.class; call execute('%global zzz'name';'); run; %put _user_; data _null_; set sashelp.class; call execute('%global zzz'||name||';'); run; %put _user_; ... View more

Hello everyone, I am curious about whether SAS has the ablility to put some special symbols to SAS log,(not into graph,but into SAS log). those special symbols such as star,triangel ,circle or any other symbols not in the keybard. Thanks. Mike ... View more