Actually, I should have looked at the SAS Studio interface for more than a few seconds.  There are buttons to download in html, rtf, and pdf. ... View more

Thanks Art!  That does indeed expose the details I was looking for in the file.  On the off chance that anyone else is working with the CMS HCC risk models and stumbles on this question here is the full code snippet I used,   filename inf "/folders/myfolders/sasuser.v94/2017/F221690P"; libname cmshccfm "/folders/myfolders/sasuser.v94/2017"; proc cimport library=cmshccfm infile=inf; run; proc catalog catalog = cmshccfm.formats; contents stat; run; proc format lib=cmshccfm.formats; select a-zzzzzzzz $a-$zzzzzzzz; run; The output of that last "proc format" statement looks like this in SAS Studio,   ---------------------------------------------------------------------------- | FORMAT NAME: $AGEL LENGTH: 2 NUMBER OF VALUES: 5 | | MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH: 2 FUZZ: 0 | |--------------------------------------------------------------------------| |START |END |LABEL (VER. V7|V8 04SEP2015:15:45:46)| |----------------+----------------+----------------------------------------| |0 |0 |0 | |1 |1 |0 | |2 |2 |12 | |3 |3 |15 | |**OTHER** |**OTHER** |-1 | ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- | FORMAT NAME: $AGEU LENGTH: 3 NUMBER OF VALUES: 5 | | MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH: 3 FUZZ: 0 | |--------------------------------------------------------------------------| |START |END |LABEL (VER. V7|V8 04SEP2015:15:45:46)| |----------------+----------------+----------------------------------------| |0 |0 |0 | |1 |1 |17 | |2 |2 |55 | |3 |3 |999 | |**OTHER** |**OTHER** |-1 | ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- | FORMAT NAME: $AGE_EDITS LENGTH: 23 | | MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH: 23 FUZZ: 0 | |--------------------------------------------------------------------------| |START |END |LABEL (VER. 9.4 04SEP2015:15:45:46)| |----------------+----------------+----------------------------------------| |0 |0 |0 newborn (age 0) | |1 |1 |1 pediatric (age 0 -17) | |2 |2 |2 maternity (age 12-55) | |3 |3 |3 adult (age 14+) | |**OTHER** |**OTHER** | | ---------------------------------------------------------------------------- Follow up question, would it be possible to dump this to some form of human readable file (csv perhaps)?  Actually I suppose I could simply copy and paste this plain text from the SAS Studio "Results" page, but would be geat to have it dumped to a file. ... View more

ahhh ha!  that seems to have done the trick.  thank you sas ninja.  the comments at the tops of these files are a kind of fascinating look into the history of computing. ... View more

Thanks for the input folks.  I think I'll just start putting the variables in quotes with the file extension as that it the only thing thats worked so far.  I'm attempting to port this to Python and just need a baseline to see if a small sample produces the same results.  Still curious as to why the warning prints the correct file name but then cant include it, but hey, that's life. Appreciate the help! ... View more

the trimmed version doesn't seem to help.  thanks for the code snippet to list the files in the directory.  it failed when it encountered directories in the directory it was searching, but I'm pretty sure the files are named correctly   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 %put |&LABELMAC|; |V22H79L1| 63 %INCLUDE IN0(&LABELMAC) /SOURCE2; %* hcc labels; WARNING: Physical file does not exist, /folders/myfolders/sasuser.v94/cms_hcc_2017/V22H79L1.sas. ERROR: Cannot %INCLUDE member V22H79L1 in the aggregate IN0. 64 65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 78 ... View more

the previous image looked pretty small on my screen, here's a zoom in. ... View more

dont know.  I'm probably more of a SAS newb than you 🙂  I just did a little pattern recognition on your code.  In some places the variable had quotes around it and in others it didn't.  seemed reasonable to assume that was where the problem was. ... View more

The full code ... Main program file LIBNAME LIBRARY "/folders/myfolders/sasuser.v94/cms_hcc_2017"; FILENAME IN0 "/folders/myfolders/sasuser.v94/cms_hcc_2017"; LIBNAME IN1 "/folders/myfolders/sasuser.v94/cms_hcc_2017/input"; LIBNAME IN2 "/folders/myfolders/sasuser.v94/cms_hcc_2017/input"; LIBNAME INCOEF "/folders/myfolders/sasuser.v94/cms_hcc_2017"; LIBNAME OUT "/folders/myfolders/sasuser.v94/cms_hcc_2017/output"; %* include main macro; %INCLUDE IN0('V2216O2M.sas')/SOURCE2; %V2216O2M(INP =IN1.PERSON, IND =IN2.DIAG, OUTDATA =OUT.PERSON, IDVAR =HICNO, KEEPVAR =HICNO &INPUTVARS &SCOREVARS &DEMVARS &HCCV22_list79 &CCV22_list79, SEDITS =1, DATE_ASOF="1FEB2016"D); Main macro file %MACRO V2216O2M(INP=, IND=, OUTDATA=, IDVAR=, KEEPVAR=, SEDITS=, DATE_ASOF=, DATE_ASOF_EDIT=, FMNAME9=V22Y15RC, FMNAME0=V22Y16RC, AGEFMT9=I9AGEY15MCE, SEXFMT9=I9SEXY15MCE, AGEFMT0=I0AGEY16MCE, SEXFMT0=I0SEXY16MCE, DF=1, AGESEXMAC=AGESEXV2, EDITMAC9=V22I9ED1, EDITMAC0=V22I0ED1, LABELMAC=V22H79L1, HIERMAC=V22H79H1, SCOREMAC=SCOREVAR); %********************************************************************** * step1: include external macros **********************************************************************; %IF "&AGESEXMAC" ne "" %THEN %DO; %INCLUDE IN0(&AGESEXMAC) /SOURCE2; %* create demographic variables; %END; %IF "&EDITMAC9" ne "" %THEN %DO; %INCLUDE IN0(&EDITMAC9) /SOURCE2; %* perform edits on ICD9; %END; %IF "&EDITMAC0" ne "" %THEN %DO; %INCLUDE IN0(&EDITMAC0) /SOURCE2; %* perform edits on ICD10; %END; %IF "&LABELMAC" ne "" %THEN %DO; %INCLUDE IN0(&LABELMAC) /SOURCE2; %* hcc labels; %END; %IF "&HIERMAC" ne "" %THEN %DO; %INCLUDE IN0(&HIERMAC) /SOURCE2; %* hierarchies; %END; %IF "&SCOREMAC" ne "" %THEN %DO; %INCLUDE IN0(&SCOREMAC) /SOURCE2; %* calculate score variable; %END; ... View more

that does work, but (according to the error message) we shouldn't have to add the quotes right? It seems like SAS is performing some kind of search in the error below and appending the ".sas" characters to the LABELMAC variable and not finding the file that does exist.  I'm hoping for a solution that doesn't involve me editing all of the SAS code that uses this pattern 🙂 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 %LET LABELMAC=V22H79L1; 63 %INCLUDE IN0(&LABELMAC) /SOURCE2; %* hcc labels; WARNING: Physical file does not exist, /folders/myfolders/sasuser.v94/cms_hcc_2017/V22H79L1.sas. ERROR: Cannot %INCLUDE member V22H79L1 in the aggregate IN0. 64 65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 78 ... View more

Thanks for the reply Art.  Adding the double quotes seems to prevent SAS from appending the extension ".sas",   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 %LET LABELMAC=V22H79L1; 63 %INCLUDE IN0("&LABELMAC") /SOURCE2; %* hcc labels; WARNING: Physical file does not exist, /folders/myfolders/sasuser.v94/cms_hcc_2017/V22H79L1. ERROR: Cannot %INCLUDE member V22H79L1 in the aggregate IN0. 64 65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 78 ... View more