topic Re: FORMAT function in SAS Programming

FORMAT function

arodriguez — Wed, 18 Dec 2013 10:21:03 GMT

Hi everyone;

I'm trying to do checks over format variables. To do that, I have found a function in SASHelp named FORMAT(format,type) that gives 1 if the format is valid or 0 otherwise.

But when I'm executing the following code SAS don't recognize the FORMAT function

data _NULL_;

rc=format('$char12.','c');

run;

give the next error.

25 rc=format('$char12.','c');

------

ERROR 68-185: The function FORMAT is unknown, or cannot be accessed.

There you know, how solve this error or sugest other way to check if a format is valid?

Any tip or help will be welcome.

Re: FORMAT function

Amir — Wed, 18 Dec 2013 12:24:59 GMT

Hi,

I was unable to find a function called "Format" in the Language Elements documentation. Do you have a link to the documentation for it?

Regards,

Amir.

Re: FORMAT function

Reeza — Wed, 18 Dec 2013 15:38:14 GMT

This is part of the SAS Component Language (SCL) which I don't think is valid in BASE SAS.

SAS Component Language (SCL) is a programming language designed to facilitate the development of interactive applications using the SAS System. For example, you can use SCL with other SAS software to create data entry applications, to display tables and menus, and to generate and submit SAS source code. SCL is the scripting language behind SAS/AF, SAS/FSP, and SAS/EIS software. Applications developed using SCL with SAS/AF software can be run by users who have only licensed Base SAS software. Previous to Version 7, SAS Component Language was known as SAS Screen Control Language.

Re: FORMAT function

Tom — Wed, 18 Dec 2013 16:11:56 GMT

Since SAS did not convert this particular SCL function into a foundation SAS function, you might need to instead query the dictionary table FORMATS (or the view SASHELP.VFORMAT).

Re: FORMAT function

snoopy369 — Wed, 18 Dec 2013 17:06:37 GMT

How do you define 'if a format is valid'? Are you asking if a format simply exists, or if a format can be applied to a variable legally, or if a format makes sense with a variable's contents, or something else?

Re: FORMAT function

Peter_C — Thu, 19 Dec 2013 00:02:10 GMT

Among the user defined formats no min/max widths are defined on SASHELP.VFORMAT. However there will be corresponding limits stored in the format catalog. So all formats and informats have limits to their validity.

Also data might not be "of a valid format" especially where it is collected "manually" like in excel

Re: FORMAT function

arodriguez — Thu, 19 Dec 2013 12:51:06 GMT

I need to know if a given format exist or not. I'm trying to do a macro and one of the parameters is a format, I'm trying to validate if this given format exist before applied. For example, the parameter can be 20 that is not a correct format value, it needs a dot.

Re: FORMAT function

arodriguez — Thu, 19 Dec 2013 12:55:01 GMT

I have found it in the local help, so i only can attach you this

Re: FORMAT function

Peter_C — Thu, 19 Dec 2013 14:00:09 GMT

PROC SQL;

select fmtname into :foundf separated by ' '

from sashelp.vformat

where fmtname = "%upcase(&your_fmt_parm)"

and fmttype ="F"

;

Then the value of &sqlobs will be 0 if there are no formats matching what is in &your_fmt_parm

Of course this crosses the "step-boundary" which might be significant.

It also assumes you have stripped out the length and decimal width from the format parameter and that you want to check for formats rather than informats.

Re: FORMAT function

arodriguez — Fri, 20 Dec 2013 08:26:21 GMT

Thank you, this can be very usefull. I'm gonna try to cut the length and decimals to apply this test.