About LeonidBatkhan

LeonidBatkhan · ‎04-28-2021

@Kurt_Bremser, This became available with SAS 9.4 M5 (maintenance release 5) sometime in spring 2018, both %IF-%THEN-%DO and %ELSE-%DO. See this blog post by @ChrisHemedinger Using %IF-%THEN-%ELSE in SAS programs

LeonidBatkhan · ‎04-28-2021

Hi KurtBremser, Actually, you can use %else in open code (I believe, starting SAS 9.4 M5): %let A=0; %if &a=1 %then %do; %put THEN; %end; %else %do; %put ELSE; %end;

LeonidBatkhan · ‎04-15-2021

Remove double quotes in your first data step: data Work.IMPORT; set work.IMPORT; if 1 <=age <=17 then AgeN=1; else if 18 <=age <=39 then AgeN=2; else if 40<=age <=55 then AgeN=3; else if age >=56 then AgeN=4; run; because your format is defined for numeric variables. With the " " you create character variables. Hope this helps.

LeonidBatkhan · ‎04-14-2021

Hi ChrisNZ, Per your advice, I modified the title to be "Solution: How you can conditionally execute SAS global statements". Thank you, Leonid

LeonidBatkhan · ‎04-13-2021

Hi ChrisNZ, That is how the blog post is titled. As for the Community "announcement" title, there are two attributes which make it non-question: 1) no "?" at the end, and 2) "can" stands after "you", in a question it would've been in reverse 😀

LeonidBatkhan · ‎04-13-2021

Try this: proc format; VALUE suppressf . = '0' 1-10 = '*' other = [comma10.] ; run; Or specify default length: proc format; VALUE suppressf (default=10) . = '0' 1-10 = '*' ; run;

LeonidBatkhan · ‎04-13-2021

Everybody is familiar with SAS global statements, such as FILENAME statement LIBNAME statement OPTIONS statement TITLE statement FOOTNOTE statement X statement, etc. They can be used in SAS open code, within SAS macros, as well as within DATA and PROC steps. Global statements are not executable by definition, meaning they are not executed during individual iterations of the DATA step. However, they do "take effect", that is in essence "execute" at some point in a SAS program. To lift the veil of mystery about SAS global statements' habits I recently wrote a blog post How to conditionally execute SAS global statements Take a read and you will never be confused by the global statements' behavior again. Happy programming, Leonid

LeonidBatkhan · ‎04-13-2021

If you want "other" remain the same, that is un-formatted, then remove "other=" from the format definition and specify default width to accommodate un-formatted values : proc format; VALUE suppressf (default=10) . = '0' 1-10 = '*' ; run; Hope this helps.

LeonidBatkhan · ‎04-09-2021

Using compress() function as suggested by Reeza may have unintended consequences. For example, if you have legitimate single quotes in a name, such as ['O'Connor'], compress will remove ' after O as well. A cleaner way would be NAME = transtrn(NAME,"['",trimn('')); NAME = transtrn(NAME,"']",trimn('')); This will selectively remove substring [' and substring '] For more information on this technique, see Deleting a substring from a SAS string. Hope this helps.

LeonidBatkhan · ‎04-09-2021

Hi nickspencer, You can also use the following code to generate SAS internal date value: %let mydate = %sysfunc(inputn(01jan2021,date9.)); The value of &mydate will be an internal SAS date value 22281 (equal to the number of days from 01jan1960). Then you can refer to it in your code as &mydate without quotes and letter d at the end. Hope this helps.

LeonidBatkhan · ‎04-07-2021

SAS documentation for PROC PWENCODE says: The METHOD= option supports the SAS003, SAS004, and SAS005 values, but only if you have SAS/SECURE. SAS002 does not require SAS/SECURE license.

LeonidBatkhan · ‎04-07-2021

I am not sure how you get PROC PWENCODE to provide your pw in quotes. You can run proc pwencode in='your_actual_pw' method=SAS004; run; and get your encrypted pw in the log as {SAS004}78BCBA30084F0A72B401D0DEEC630EF8967005CA77A26DB5 Then assign its value (without quotes): %let userPW={SAS004}78BCBA30084F0A72B401D0DEEC630EF8967005CA77A26DB5; Then use in PROC IMPORT as serverpass="&userPW" . Check out the following track https://communities.sas.com/t5/SAS-Programming/SAS-PC-File-Formats-Error-importing-or-exporting-from-network/m-p/685704#M208004 to see if you have configuration issue. Hope this helps.

LeonidBatkhan · ‎04-07-2021

Hi Linda_V, are you including your encrypted pw in quotes?

LeonidBatkhan · ‎04-05-2021

Hi ARTI1, It's not clear whether you want to split data set based on variable value or sample size. If you want to split based on sample size, please read this blog post: Splitting a data set into smaller data sets . In there, see section "Splitting a data set into smaller data sets randomly". If you want to split data set based on the values of categorical variables, see How to split one data set into many blog post. Hope this helps.

LeonidBatkhan · ‎04-01-2021

Hi SASKiwi, As you suggested, I just deviated into quantum mechanics with this new post: To be and not to be – the uncertainty principle in SAS

Online Status	Offline
Date Last Visited	‎11-30-2023 05:52 PM

Re: Endsas does not cause DI Studio to exit: is it the expected behavi...

Re: How to pass strings beginning with a space or containing commas to...

Re: How to solve EG duplicate librefs detected

Re: Remove Quotes from Character Variable and Reset Length of Variable

Re: Macro: Display Only 1 Level of Resolution. (Advanced Question) :)

Re: removing closing brackets ')' form macro variable

Re: Compare two Strings in Hebrew

Re: Want to remove the first "[" in this clause statement

Re: How to calculate ZCTA radius?

Re: How to calculate ZCTA radius?

Coding for Data Quality in SAS Viya Part 4 – Extracting Data from Mess...

Re: How to schedule a Job from API?

Announcing the SAS Technical Support Code GitHub Project

Re: Library - Extract metadata

Re: Endsas does not cause DI Studio to exit: is it the expected behavi...

Re: Create a Read-Only Excel File from SAS

Re: Date constant in macro

Re: Endsas does not cause DI Studio to exit: is it the expected behavi...

Re: How to pass strings beginning with a space or containing commas to...

Re: Macro: Display Only 1 Level of Resolution. (Advanced Question) :)

Re: Two ways to split bar charts in SAS Visual Analytics

Re: How to export to excel a 0 observation data with a "No Data" note.

Re: How to export to excel a 0 observation data with a "No Data" note.

Re: How to categorize a numeric number

Re: How you can conditionally execute SAS global statements

Re: How you can conditionally execute SAS global statements

Re: proc format for missing and other

Solution: How you can conditionally execute SAS global statements

Re: proc format for missing and other

Re: How to remove brackets and quotes from observations in a dataset

Re: Date constant in macro

Re: Using serverpass=

Re: Using serverpass=

Re: Using serverpass=

Re: Splitting a dataset depending upon a variable value

Re: Theory of relativity in SAS programming