Unfortunately you would need to have it enabled to be able to test it out and I don't have it enabled 😞 ... View more

It looks like Office has it's own Sensitivity labels that can be turned on by a company. https://learn.microsoft.com/en-us/purview/sensitivity-labels Assuming this is your reference, I'm not aware of a method to apply the label via ODS. ODS Word is still under development so there is an option to add that in via ballot/suggestion. Other consideration is to post-process the files using PowerShell to add the labels, if possible. ... View more

data have; infile cards truncover dsd; length id 8. var_1-var_3 $20.; input ID Var_1 $ Var_2 $ Var_3 $; cards; 11, None(0%), Nearly all(100%), None(0%) 12, Nearly all(100%), None(0%), None(0%) 13, None(0%), Some (50%) , Nearly all(100%) 14, Some(50%), Nearly all(50%), Some(20%) ; run; data want; set have; array _var(*) var_1-var_3; if find(catx(" | ", of _var(*)), "None") > 0 then flag="1"; else flag = "0"; *probably use better names; run; Here's a tutorial on using Arrays in SAS https://stats.idre.ucla.edu/sas/seminars/sas-arrays/   Seems like a better usage for arrays than macros. ... View more

format _character_ $quote.; ... View more

https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/   It was buried in the post. ... View more

You can easily customize the output format of a variable, even automate it dynamically. However, you'll need to show an example of what you're trying to achieve if you want any examples otherwise, a vague question (is something possible) gets a vague answer(yes, it's possible). ... View more

@JibJam221 wrote: hello! Thanks for letting me know, I didnt know that! and the Source variable is working, its outputting the sources as i'd like to. Im just hoping to find a way for it to stay when I try to further query the table. I'm confused. You said the source variable is working.    So is it working or not? ... View more

Define automatically? What do you mean by output? SAS really only has numeric/character. ... View more

If you don't explicitly keep it, (listing in SQL) then it's implicitly dropped. Add it to the SQL select statement if you want to keep it... ... View more

"use this to only include the variable "SourceTransc" and not "source"" Sounds like you do drop it, but not including it in a KEEP statement maybe. Show the code for further assistance. ... View more

It will stay unless you dropped it. Trace your code to show where it's dropped. Look for Keep/Drop statements and verify that your SET/DATA references are correct. ... View more

data totaltable; set work.totaltable; if source='work.1222872' then SourceTransc='Transaction 2287'; ...... run; This type of coding is known to cause issues so it's a good idea to use a unique data set name between each data step, then you can trace your code for bugs.    Did you check the output of totaltable after the first step to ensure that the source variable is being created correctly and as expected? Usually character variables have a default length of 8 characters and your names are larger so it could be that. You need to add in a length statement for the source variable if that is the case.  Also, it's usually returned as all uppercase I believe and you're using lower case data, SAS is case sensitive for character comparisons.   @JibJam221 wrote: Hello all, im having issues with the INDSNAME column. It outputs as it should... however Im looking to make this column permanent so that I can rename the source names to more understandable terms. I tried using INDSNAME then using IF-THEN statements to rename the sources into a new column, however these sources get automatically removed once further querying the table..  is there any way for me to make INDSNAME a permanent column in the dataset?   data work.totaltable; set work.1222872-work.1222998 indsname=Dsnames; source=Dsnames; run; data totaltable; set work.totaltable; if source='work.1222872' then SourceTransc='Transaction 2287'; ...... run;       ... View more

Historically, I've also created a date dimension and queried the table. https://gist.github.com/statgeek/9606118   EDIT: the holiday portion would need to be updated (clearly very old code)     ... View more

Is -99 coded as missing? If so, proc means won't get you what you need (and neither will this though it can be easily modified).   Assuming this is a SAS data set (since it's a SAS forum) here's how I'd do it in SAS.   data exclusion_list; set have; by id; retain tot_miss; array _vars(*) ex: int: ut:; nmissing = nmiss(of _vars(*)); if first.id then tot_miss=0; tot_miss + nmissing; if last.id then pct_missing = tot_miss / dim(_vars)*3; if pct_missing >= 0.75; keep id; run; proc sql; create table included_records as select * from have where id not in (select id from exclusion_list); quit; ... View more

I like using this macro %dirtree.   https://github.com/sasutils/macros/blob/master/dirtree.sas   %macro dirtree /*--------------------------------------------------------------------------- Build dataset of files in directory tree(s) ----------------------------------------------------------------------------*/ (directory /* Pipe delimited directory list (default=.) */ ,out=dirtree /* Output dataset name */ ,maxdepth=120 /* Maximum tree depth */ ); Not sure anything will do the SPDE request, you'll likely need to wrangle the output yourself for that one.    ... View more