Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

WPS Personal - do i have to explicitly list a SAS FMTLIB?

Hi All:

Been coding SAS since 1975 (yes, 50 years) and am now checking out Altair via SLC Personal.

Did the install of SLC and Workbench, then at the command line typed wps -personal to apply a license for local server.

From Windows Explorer I was able to right-click on an existing SAS program and chose Open with Altair Analytics Workbench 2025 and… voila!! there it was in Workbench.

Choosing Run from the File/Edit/Navigate/Search/Project/Run commands didn't allow me to run the job.

However, choosing run from all the icons did run the job!!

But it errored out b/c it couldn't find certain formats used in the job. Those formats are in my standard FMTLIB which, in SAS, is simply defined by the LIBRARY filename:

libname library "E:\medi-cal" ;

Other formats, stored in a file referenced by a SAS filename and then %inc(luded) worked fine.

So, per the subject line, does WPS recognize default FMTLIBs or do I need to reference it via a filename and the %inc it too?

TIA

Find more posts tagged with

Analytics Workbench

SLC

Auto Tagged

Accepted answers

Roger DeAngelis_21630

Converting sas formats sas7bcats to altair personal slc formats wpccat

too long and too mangled to post here, see gthub

github
https://github.com/rogerjdeangelis/utl-converting-sas-formats-sas7bcats-to-altair-personal-slc-formats-wpccat

community.altair
https://community.altair.com/discussion/64592/wps-personal-do-i-have-to-explicitly-list-a-sas-fmtlib?tab=all

The Altair Personal slc does not support reading sas7bcat formats.
But you can convert many sas formats to equivalent altair personal slc formats
I believe R and Python can both read sas formats

PROCESS

1 Download format catalog, formats.sas7bcat, and crash_hospital,sas7bdat or from this rep
https://stash.utahdcc.org/stash/projects/UTCODES/repos/mi-activities/browse/data

  store in

     a  d:/fmt/formats.sas7bdat

     b  d:/sd1/crash_sas7bdat

2 use proc contents to identify the format and variable position you are interested in

      Number Variable  Type Len  Pos    Format   Label

     ----------------------------------------------------

       7       SEX     Num    8   48    SEXFMT.  Sex

3 use r package haven to load the dataset and format catalog

4 run simple r script to crreate a cntlin dataset and altair personal slc format

5 test format

All comments

Roger DeAngelis_21630

Converting sas formats sas7bcats to altair personal slc formats wpccat

too long and too mangled to post here, see gthub

github
https://github.com/rogerjdeangelis/utl-converting-sas-formats-sas7bcats-to-altair-personal-slc-formats-wpccat

community.altair
https://community.altair.com/discussion/64592/wps-personal-do-i-have-to-explicitly-list-a-sas-fmtlib?tab=all

The Altair Personal slc does not support reading sas7bcat formats.
But you can convert many sas formats to equivalent altair personal slc formats
I believe R and Python can both read sas formats

PROCESS

1 Download format catalog, formats.sas7bcat, and crash_hospital,sas7bdat or from this rep
https://stash.utahdcc.org/stash/projects/UTCODES/repos/mi-activities/browse/data

  store in

     a  d:/fmt/formats.sas7bdat

     b  d:/sd1/crash_sas7bdat

2 use proc contents to identify the format and variable position you are interested in

      Number Variable  Type Len  Pos    Format   Label

     ----------------------------------------------------

       7       SEX     Num    8   48    SEXFMT.  Sex

3 use r package haven to load the dataset and format catalog

4 run simple r script to crreate a cntlin dataset and altair personal slc format

5 test format

wwvierg

Hi Roger:

Thanks for the reply and the github link; I will check it out shortly.

TBH, however, I think it'll be quicker to explicitly point to my fmtlib.sas job then simply %inc it as well

Note-to-self: I will need to see if NOSOURCE2 work to suppress listing all that %included code however :-)

wwvierg

Hey Roger:

re-reading your reply… can i not simply run a proc format job under WPS to create a SLC personal format (lib)? … vs. using R to convert an existing sas7bcat file?

Roger DeAngelis_21630

If you don't have the sas format source code or the cntlout/cntlin sas dataset then there is no way the Altair Personal SLC can use the sex format. Even if you have the SAS format catalog(sas7bcat), the SLC cannot read it. The only way to reconstruct the sas sex format is with R haven read sas. or Python pyreadstat.

Haven read_sas() can read the sas format calalog, fomats,sas7bcat, directly.

The SLC cannot access formats.sas7bcat. You need to convert the formats.sas7bcat to formats.wpccat.

The only caveat is: you need a sas dataset that has at least one column that uses the format.

😀 Roger

wwvierg

First-off: thanks for all the replies Roger, really appreciate the help.

NB. I do have the source code (see attached zip file—as I can't attach .sas files).

If I "run" this as is, will WPS create a wpccat directly?

And if so, do i need to do anything special with respect to how I point to where the wpccat file is supposed to or will this code work as is?

And once I have a wpccat file, how do I reference it in future jobs? Any special libname?

e.g.:

FMTLIB.zip

*******************************************************************************;

FMTLIB: Format lib for misc. Medi-Cal data tapes.

*******************************************************************************;
*-- define options & output file destinations ;
options nocenter ls = 177 ps = 60 noxwait errors = 2 date ;
libname library v9 'E:\medi-cal' ;

*-- let's format all the stuff needed for the Medicaid summary paid claims tapes ;
proc format library = library ;