Why not do both?  You have, to begin, demographics data, which is usually connecting one ID to one or more personal traits.  Such a dataset would have one row per ID.    Next you have historical data pertaining to "visits"  your data will have columns  where by the data is a specific measurement which is connected to both an individual ID and a individual visit.    Separate it, divide and conquer it.  There no need to convert the whole file is there?  It's kind of overkill, at least it seems that way from an observer's perspective whom does not know the data very well. ... View more

Categorical and ordinal variables should be converted to dichotomous variables.   Why.  There are more intricate explanations, so long story short:  Grade level, e.g. in the US: K, 1 through 12,  is an ordinal variable.  It can't be used as a analysis variables because there is no sense in taking the difference in grade nor the mean of grade.  K, 1 through 12 are categories, they would work equally well if they were labeled A,B..M.  being ordinal, there is only the set mathematical relationships that begin  grade K is less than grade 1 through 12, 1 less than grade 2, etc.   Look at page 13 of this pdf to see how Gender can be coded with a dichotomous variable scheme.  Mind you this is not the only way to do it.   referring to:  SD-29.pdf (lexjansen.com) ... View more

OK, I'm sorry, I am out of my depth.  Your system's encoding may come in to play on this.  I naively suspect that the solution I linked to on Stack Overflow may have been using wlatin encoding but we have not established what encoding your system or DI uses, if it is different.      did you try the other suggestion? options missing="%sysfunc(byte(0))"; ... View more

according to this: Solved: PROC EXPORT produces "0" for blank or null values - SAS Support Communities   "file writer transformation" is a "PROC EXPORT" and OPTIONS MISSING sets the character.   I didn't test this but if you can set this before you run the "file writer transformation": options missing=%sysfunc(byte(255)); I got this from Joe: how to set missing values to NULL in SAS - Stack Overflow ... View more

The content sharing access permissions for Google Docs can be set to not require authentication.  My memory, you can set (paraphrasing) "Share to whom ever has the link".  I don't use it often, and I have to stumble through their security access menus re-re-learning it every time.  Something to consider, HTH. ... View more

You can play with some of the ideals here.  This creates an HTML5 document, but if you replace the extension with dot-"DOC" MS word will open the HTML as  a document.   ODS HTML5 FILE="EGHTML.doc"; ODS HTML5 text="<Table border=1><TR><TD>"; proc ODSTEXT; p "Additional text"/ style={font_weight=bold}; p "[name of the variable-column in the dataset]"; run; ODS HTML5 text="</TD><TD>"; proc ODSTEXT; p "Label of the variable"/ style={fontweight=bold}; p; proc freq data=sashelp.cars; table cylinders; proc ODSTEXT; p; p "Additional text"; run; ODS HTML5 text="</TD></TR></Table>"; Basically I've written HTML code. wrapped around ODS output.  This was easier than I thought it would be.   I've done similar things with RTF,  but that was much more involved, as I remember. ... View more

Because you say you are new to Boolean expressions, I'd say I think you did well enough.  Does the instruction imply using ANDs or ORs?  I think I would have picked ANDs based on the instructions as well.  One thing that could go wrong is if AUDITOR_FKEY was a string variable type rather than numeric, as Tom said.  In that case the if statement would look like: if auditor_fkey ="1" and auditor_fkey ="2" /*...*/ then BIGN = 1; else BIGN = 0; ... View more

Wait, wait, wait! result =Log10(90*20*10**dilution); /* ... =Log10(90*20) + Log10(10**dilution); ... =Log10(90*20) + dilution * Log10(10); ... =Log10(90*20) + dilution * 1; */ result =Log10(90*20) + dilution ; List of logarithmic identities - Wikipedia   This is better for numerical precision purposes, I believe. ... View more

  You can use the SET option INDSNAME:   %let lastyear = 2020; data new_data; set data18.file_name data19.file_name data20.file_name indsname=_dsname; dsname=_dsname;*optional. Do this or else it will not be added to the output; run;     ... View more