topic Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)? in Statistical Procedures

how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

sandyming — Wed, 03 Apr 2013 14:58:25 GMT

using Code in a Data step...

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Reeza — Wed, 03 Apr 2013 15:09:27 GMT

vtype function

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Astounding — Wed, 03 Apr 2013 15:17:00 GMT

OK, now here's a harder question. How do you do it in a PROC step? For example, if T is character, it should be printed without a format. But if T is numeric it should be printed in the TIME5 format. Hint: macro language is not needed. All of the necessary code can be hard-coded within the PROC step. If nobody gets the answer, I'll post it tonight.

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 15:23:58 GMT

It this right?

format t-numeric-t time5.;

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Astounding — Wed, 03 Apr 2013 15:25:24 GMT

Bingo! Good job.

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 15:32:16 GMT

The "SAS Variable List" big medicine.

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Haikuo — Wed, 03 Apr 2013 15:32:36 GMT

Confused. Never seen this before. Care to elaborate more? Thanks, Haikuo

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 15:38:43 GMT

It means for all the variables between t and t that are numeric associate format time5. If there are none when t is character nothing happens.

SAS(R) 9.3 Language Reference: Concepts, Second Edition

data class;
   set sashelp.class;
   *t = time();
   t = '8:01'; 
   run; 
proc print; 
   format t-numeric-t time5.; 
   run;

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Haikuo — Wed, 03 Apr 2013 15:46:20 GMT

Thanks for the explanation and specially, the link. Did not know such things existed.

Haikuo

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 16:20:52 GMT

Just to make it more complete we can also format the character name range T, that may or may not exist. The "SAS Variable List" is one of the most powerfull parts of the SAS language.

format t-numeric-t time5. t-character-t $5.;

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

sandyming — Wed, 03 Apr 2013 17:47:21 GMT

If in a macro:

%if "vtype(&time)"="C" %then %do....

is this correct?

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 17:49:46 GMT

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Reeza — Wed, 03 Apr 2013 17:54:51 GMT

What are you trying to do?

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

sandyming — Wed, 03 Apr 2013 18:04:28 GMT

if the time variable is char, then do something;

if it is num, do something else....

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

sandyming — Wed, 03 Apr 2013 18:05:13 GMT

why it is not correct? how about : if vtype(&tm)="N"?

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Reeza — Wed, 03 Apr 2013 18:11:02 GMT

look up sysfunc

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

data_null__ — Wed, 03 Apr 2013 19:43:53 GMT

I don't think VTYPE can be use with SYSFUNC.

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Reeza — Wed, 03 Apr 2013 19:52:45 GMT

Apparently not. Thanks

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

PGStats — Wed, 03 Apr 2013 19:56:58 GMT

Congratulations DN for your new status level, long time due!

Maybe it's time to change your status from "I'm learning SAS" to "I'm teaching SAS"

Re: how to identify a time variable (time5. format) is num or char, not using (Proc Content)?

Linlin — Wed, 03 Apr 2013 20:40:48 GMT

Congratulations DN!!!