About Aexor

Aexor · ‎05-02-2021

I have a table like this: Parent Child A B B C C D I J J K K L i want to write a query which which output values which are parent only having no child. Output A and I

Aexor · ‎05-01-2021

I want to distribute equal amount of bonus from bonus table to all the employee of emp table. data bonus; input deptid $ bonus; datalines; HR 4000 Fin 3000 ; run; data emp; input deptid $ empid; datalines; HR 1 HR 2 HR 3 HR 4 Fin 1 Fin 2 Fin 3 ; run;

Aexor · ‎02-24-2021

Thank you!!

Aexor · ‎02-23-2021

Sure. I have below queries : - 1. I want to replace last 3 character of a long string with a value ( having length 3) 2. I want to replace 3 character (starting from position 15 to next three) of a long string with a value ( having length 3)

Aexor · ‎02-23-2021

Yeah. Will be more careful next time. The code is as below actually: Y = TRANWRD(X,'890,'098') I just wanted to know if we have any others functions or utility for this kind of problem. suppose If X is having length as 500 and I have to replace last three char to "abc" value . wanted a dynamic approach for this. thats all ! Thanks

Aexor · ‎02-23-2021

I need to write to code to change the value of X X=’1234567890’ , write code to get ‘1234567098’ I have TRANWRD function here like below Y = TRANWRD(X,'980',890') though I got the output but this is not the optimal approach for big values. Please help with any other options. Will be much appreciated. Thanks!!

Aexor · ‎02-23-2021

There is a column of DATE with diff formats, I want to write a dynamic code that can read all these dates: DATE 20112017 (DDMMYYYY) 21072017 (DDMMYYYY) 09212017 (MMDDYYYY) 01JAN2017 (DDMONYYYY) Please help.

Aexor · ‎02-23-2021

Can we use PUT, INPUT or any other SAS functions while connecting to DB ?

Aexor · ‎02-23-2021

Thanks 🙂 . I always prefer INFILE . this question is asked by my colleague though i dont know any other ways except INFILE so asked for help 🙂 This community is amazing. Thank you all!!

Aexor · ‎02-20-2021

How to connect to DB is SAS? Can we use SAS function while connecting to DB?

Aexor · ‎02-20-2021

Hello, Any methods to reacd external files in SAS except INFILE ??

Aexor · ‎12-29-2020

We have two two coloumn in input file one contain id and one contain password. I want to print password like ***** by masking actual value . How to do that. Please help.

Aexor · ‎09-18-2020

Can Someone elaborate logs archiving jobs for SAS Viya services.

Aexor · ‎09-08-2020

Thanks !! Yes if we use infile then we can easily specify DSD . I just wanted to confirm that while using default format for char variable we can use '.' or is there any way out for this ?

Aexor · ‎09-08-2020

Hi I have a datasets having numerous variables and want to compare what are the variables having missing values for a subject. id name number results rank 1 Nan . 3 A 2 Ben 10 . want results like with new variable "Comment" id name number results rank Comment 1 Nan . 3 A Number variable is missing 2 Ben 10 . Results and rank variable is missing Please help

Online Status	Offline
Date Last Visited	‎01-22-2025 08:02 AM

Re: ERROR: A name token was expected

ERROR: A name token was expected

Re: Need to store a code in macro variable

Need to store a code in macro variable

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Need to add semicolon in values getting printed

macro variable in title statement is not getting resolved correctly

Re: Getting duplicate value because of do loop

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Re: Need to add semicolon in values getting printed

Re: SAS VIYA : proc fed sql error

Split the non-key columns to separate tables with key column in both t...

Re: read a file delimited by string

query for parent

distribution of equal amount of bonus

Re: Connect to DB in SAS

Re: replacing value

Re: replacing value

replacing value

reading dates

Re: Connect to DB in SAS

Re: Reading external files in SAS

Connect to DB in SAS

Reading external files in SAS

how to mask password

SAS Viya logs archiving

Re: How to input blank char value in dataline

report missing variable with comment