Hello all;   The data in one excel cell looks like below, it should be four records but if I import the cell in SAS, they become one single record "ABC661204/38120440/39661204/3024". but I want them be seperated as four records or there will be a delimer ammong them(such as : "ABC***661204/38***120440/39***661204/3024". ) ,what should I do?       The data in ONE cell:   "ABC 661204/38 120440/39 661204/3024"       Thanks! ... View more

Hello all,   I want extract the number after the last '/', how to do it?   below is the character, I want '9245',:   'Kwstala/416544/95ewS661204/9245'       Thank you! ... View more

Hello all;   Can anyone tell me how to read a txt file with multiple column names combined in different record with data step? the raw txt filelook like this:   var1 var2 var3 var4 var5 1 2 3 4 5 6 7 8 9 0 var1 var2 var3 var4 var5 11 12 13 14 15 16 17 18 19 10 var1 var2 var3 var4 var5 21 22 23 24 25 26 27 28 29 30   data need; infile 'c:\rawdata.txt'; input var1 var2 var3 var4 var5; run;   Thank you very much!     ... View more

hello everyone, Our SAS use work folder as default, if we create a data set such as : data ONE; x=1; run; then the one data set will be created in WORK folder. My question is if I have another folder named mylib(libname mylib "c:\myfolder1";), Is there any SAS code that I can do to make this folder to default  folder as WORK? and if it works ,when I create the data set named ONE use the code above it will be created in mylib folder by default. Thanks ... View more

Hello everyone, How I can remove variable y's format in proc sql? proc sql noprint; create table two as select x,  y format=_null_ from one; quit; Thanks ... View more

Hello everyone, Is there any SAS code(not in command line ,but just in SAS program code,it should be interactively,such as call a macro that can run  'SAVE AS' ) that can operate SAS menu? Give an example: I want write a row of SAS code(e.g:"%sysfunc(SaveAs))" ,after I run that code, it will show me "SAVE AS menu"(just as if I click with my mouse on : file-->save as) Thanks ... View more

Hello everyone, How to read a htm(not html) file into SAS? and then export it to another htm file(keep same)? Thanks ... View more

Hello everyone,how to change a whole data set from column to row?is there any matrix method like SAS IML or any other method can do this?(please use sashelp.class as input data) I have a data set like: name ID score1 score2 A        1      80       60 B         2     36       85 C        3      16       28 I want the data set convert to this: name   A   B   C   ID       1   2   3 scoe1  80 36 16 score2 60 85 28 which means change from  row to column for whole data, you can use SAS help.class as an date set input, and for the  result all variables are character will still be ok. Thanks ... View more

Hello everyone, if I want know the location of  a variable 's format what can I do? please look the example code below. Image two people A and B. people A create a dataset one use the code below. and people B don't know how data set one was created by A, but B want know its variable 'age 's format location(c:\mylib). how to do it? can we use information from sashelp.vformat? or any other method? Thanks libname mylib "c:\mylib"; proc format library=mylib; value fmt_age 0-13 = 'AAA' other ='BBB'; run; option fmtsearch=(mylib); data one; set sashelp.class; format age fmt_age.; run; ---------- Thank you Jagadishkatam and  Hai.kuo: I summarized it: method 1: proc sql; create table need1 as select a.libname, a.fmtname, b.path from dictionary.formats a, dictionary.libnames b where UPCASE(FMTNAME)='FMT_AGE' AND A.LIBNAME=B.LIBNAME;quit; method2 proc sql; create table need2 as select a.libname, a.fmtname, b.path from sashelp.vformat a, sashelp.vlibnam b where UPCASE(FMTNAME)='FMT_AGE' AND A.LIBNAME=B.LIBNAME;quit; ... View more

Hello everyone, I want copy all data sets from work to another SAS folder. how to do it? Thanks proc datasets; copy out=sasuser in=work; select _all_; run; ... View more

Hello everyone, If i want keep name start with 'D'. the code below works,but how if I want keep the name end with "y"?or second letter is "o"? Is there any similar operator like "=: "to do this in data step?(data step only) data test;   input name $;   cards;   John   Diana   Diane   Sally   Doug   David   ;   run;   data test;   set test;   if name =: 'D';   run;   proc print;   run; Thanks ... View more

Hello everyone, when I use proc print in SAS,the result doesn't show as I want, the column go the another row because the width limit of output screen. I wonder is that possible there was a scroll bar under bottom of the output so we can drag the button to see the whole obs Here is example:(I want them in only one row for each obs,and there was a scroll button under the screen for the view ) ods _all_ close; ods listing; proc print data=sashelp.zipcode(obs=1); run; Thanks ... View more