I am unable to see a difference in order between your two screen captures. ... View more

No, the delimiter is actually a comma.    This is a list of active ingredient groups for the same drugs and the producer of the original data chose to join them with slashes.   It originally came in a single variable in the following format (just showing two cells).   DROSPIRENONE / ETHINYL ESTRADIOL / LEVOMEFOLATE CALCIUM ETHINYL ESTRADIOL / NORGESTIMATE ... View more

And if this is some kind of homework, tell your teacher that the purpose of a SAS course is to learn the efficient use of the SAS system, not wasting time with stupid things you'll never do in real life. ... View more

Hi @Tom ,thanks a lot for your question! Here is the further clarification: according to @Jeff_DOC 's description about the time variable, the values such as 1416 and 1950 may have two different meanings:   1) they are standard time values in numeric format (i.e., numbers that we see and use everyday), in this case, any of this kind of numbers can be converted to a standard time format such as 00:00 through apply the time. format to them; and just like what you already clearly described in your previous thread, @Tom , these numbers represent seconds (I did not pay attention to this knowledge before, because I just know that any number in a date/time column can be easily converted to standard date/time format and I did not worry about what they are exactly);   2) 1416 and 1950 means 14:16pm and 19:50pm, in this case, one can convert the number to a character format using cat(substr(put() )) function, and then convert the character time back to numeric time value and use it in calculating time difference.   Also, I think @Tom , your previous thread already well answered and clearly explained your question, and my solution is in accordance with yours (see the screen capture), thanks a lot for your questions, which makes me learnt more!  My answer:   ... View more

I'm not familiar with a dataset called ACCEPTS that comes with SAS Visual Analytics. Are you sure this is a SAS provided table, and if so which product it might be part of? For Visual Analytics, there is a CAS LIbrary called Samples that has several sample tables in it you might be able to use instead. I'm not aware of a data dictionary for any of them though but that might be intuitive enough to understand. They are described here: https://go.documentation.sas.com/doc/en/vacdc/v_031/vareports/n1dj9jn3klf501n1ovpkkahcegot.htm   ... View more

Pretty simplistic, but you could do this.  I wouldn't recommend this with anything much larger than what you have -- in your data, the CROSS JOIN will produce a table with 1M rows (5000*200), which is fine.   data pt; do pt=1 to 20; visited_hosp=rand('integer',1,10); X=rand('erlang',2)*5; Y=rand('erlang',2)*10; output; end; run; data hosp; do hospid=1 to 10; hosp_X=rand('erlang',2)*5; hosp_Y=rand('erlang',2)*10; output; end; run; proc sql; create table pthosp as select a.*, b.hospid, geodist(a.Y, a.X, b.hosp_Y, b.hosp_X) as dist from pt A cross join hosp B order by a.pt, dist; quit; data want; set pthosp; by pt; if first.pt; hosp_match='N'; if visited_hosp=hospid then hosp_match='Y'; run; proc print data=want; run; ... View more

@PaigeMiller wrote: @sas_nutzer wrote: In this case I need the correct order. Why? What bad things happen if your ordering is not correct? Please explain in detail. The dataset is difficult for humans to work with.  You cannot LOOK at the data without having to rearrange the columns.   Example I have seen way too many times.  Someone lazily create a bunch of optional long character variables at the front of the program data vector.   data class; length comment1-comment4 $200; set sashelp.class; run; Then when you try to examine the data the whole first page of data is filled with empty columns.   ... View more

Thank you very much for your help !!! ... View more

My suggestion for second one is using CORRB option,and remove thoese variable have collinearity, not listing these variables in PROC LOGISTIC.   proc logistic data=sashelp.heart; model sex(event='Male')=_numeric_/corrb; run; ... View more

Thank you very very much PaigeMiller. I have tried with this new proc summary and got the required output. Once again thank you very much and I thank Tom and mkeintz and entire community for extending their helping hands. This SAS community is a wonderful community. ... View more

HEY  THANKS ... View more

@Feefee wrote: Hi,    I have dataset that looks like this:    No, you don't. SAS names can't have blanks or linefeeds in them.  Please do ALWAYS post example data as working DATA step code with DATALINES. ... View more

Here is another possible way to do this: data have; input tbl $ field $; cards; tbl1 x tbl1 y tbl1 z tbl2 w tbl2 x tbl2 v tbl2 y ; run; data have; set have; by tbl; if first.tbl then flag=0; flag+1; run; proc sort data=have; by flag tbl; run; proc transpose data=have out=want(drop=flag _name_); by flag; id tbl; var field; run; proc print data=want; run; ... View more

For the sake of security, I would prefer to way2 . ... View more

Thanks. %macro list_vars(dataset); %local rc vars dsid i; %if %sysfunc(indexc(&dataset,())) %then %do; %let rc=%sysfunc(dosubl(%nrstr( options nonotes; %let vars=; %list_vars_step(&dataset,mvar=vars) ))); %end; %else %do; %let dsid = %sysfunc(open(&dataset)); %do i=1 %to %sysfunc(attrn(&dsid, nvar)); %let vars=&vars %sysfunc(varname(&dsid,&i)); %end; %let dsid=%sysfunc(close(&dsid)); %end; &vars. %mend list_vars; Results 199 /* Example */ 200 %let varlist=; 201 %put %list_vars(sashelp.class); Name Sex Age Height Weight 202 %put %list_vars(sashelp.class(drop=sex)); Name Age Height Weight 203 %put %list_vars(sashelp.class(rename=(sex=Gender))); Name Gender Age Height Weight ... View more