BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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 !!!!
2 REPLIES 2
SPR
Quartz | Level 8 SPR
Quartz | Level 8
Hello Sudcha,

Look at SASHELP.VFORMAT and SASHELP.VCFORMAT.

Sincerely,
SPR
mgst170
SAS Employee
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 849 views
  • 0 likes
  • 3 in conversation