Help using Base SAS procedures

need to find Formats

Reply
N/A
Posts: 0

need to find Formats

Hi Friends,

Good Morning !!!

In my program already predefined user formats are writtern.I need to find out the location of that formats to view that values.
Eg:
proc sql;
create table members as
select mlstnam label='Last Name',Mfstnam label='First Name' ,mmidnam label='Middle Name',langcd as Language_Code, put(langcd,$lang.) as Language_Descr
from hosp;
quit;

Is there any procedure to find out that user defined formats?

Thanks in Advance !!!!
Super Contributor
Super Contributor
Posts: 365

Re: need to find Formats

Hello Sudcha,

Look at SASHELP.VFORMAT and SASHELP.VCFORMAT.

Sincerely,
SPR
SAS Employee
Posts: 11

Re: need to find Formats

Hi,

You'll need more than the location if you want to find out the values in the format.

Try something like:

proc format lib=???? cntlout=work.andy;
select @lang ;
run;

fmtsearch lists your search path for formats.

Replace ???? with the library where your fomat catalog lives. This will create a dataset with all the values within the lang format you are after.

Hope this helps.

Cheers
Ask a Question
Discussion stats
  • 2 replies
  • 178 views
  • 0 likes
  • 3 in conversation