About BrahmanandaRao

BrahmanandaRao · ‎11-02-2023

Thank you s_Lassen

BrahmanandaRao · ‎11-01-2023

data firstlast; input string $60.; First_Word=scan(string,1, 1,); Last_Word=scan(string, -1,1); if _n_ = ' ' then last_word =' ' ; datalines; Jack and Jill & Bob & Carol & Ted & Alice & Leonardo Gates ! $ % & ( ) * + , - . / ;;;; proc print data=firstlast; run; i want output below like 1 Jack Jill 2 & & 3 Leonardo 4 Gates 5 ! /

BrahmanandaRao · ‎10-30-2023

data ds; array x[10] ( 1, 2, 3, 4, 5, 6, 7, 8, 9,10); do i = 1 to dim(x); if mod(x[i], 2) = 0 then do; even_number = x[i]; output; end; end; drop i; proc print noobs; run; i want output like below x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 even_numbers 0 2 0 0 0 0 0 0 0 0 2 0 0 0 4 0 0 0 0 0 0 4 0 0 0 0 0 6 0 0 0 0 6 0 0 0 0 0 0 0 8 0 0 8 0 0 0 0 0 0 0 0 0 10 10

BrahmanandaRao · ‎10-11-2023

Hi Kurt I want to find 2nd occurrence position ' is' in that text

BrahmanandaRao · ‎10-11-2023

Hi Guys, Good Moring data nth_occurance; c='who is this' ; run; in the above string how to find 'is' 2nd occurrence position with out using any regex

BrahmanandaRao · ‎10-08-2023

it is interview question how to create a macro variable for date input -'12-01-2023' ?

BrahmanandaRao · ‎10-08-2023

Hi Guys, How to create date macro for below date date='12-01-2023' (dd-mm-yyyy) format /*i tried this way is it correct ? or any other method is there like using %sysfunc and putN and inputN functions please suggest */ %let input_date = 12-01-2023; %put &input_date;

BrahmanandaRao · ‎10-07-2023

Data Prdsales; input prdcode $ Jan_sale Feb_sale; cards; P101 230 450 P102 340 320 P103 210 250 ; run; proc sort data=prdsales ; by prdcode; run; data sales_cum; set prdsales; by prdcode; if first.prdcode=1 then cumsale=0; cumsale+jan_sale; run; /*QUESTION1:-How to calculate cumulative sales for each month in the above code i i want to caluculate jan_sale and f_sale for each month cumulative sales?

BrahmanandaRao · ‎10-06-2023

data YourDataSet; /* Replace YourDataSet with your actual dataset name */ set sashelp.class; if age < 11 or age > 15; /* Keep only observations where age is not between 12 and 14 */ run; Hi Guys , I want delete range of observations using Between operator in data step between operator can works with IF and WHERE please suppose i want to delete age between 11 to 15 in sashelp.class dataset

BrahmanandaRao · ‎10-05-2023

Hi Peter, I want get only positive values only A1 to A5 variables

BrahmanandaRao · ‎10-05-2023

data test; infile cards; input A1 A2 A3 A4 A5; cards; -2 2 5 1 0 1 -2 5 1 2 ; run; how to get only positive values ?

BrahmanandaRao · ‎09-12-2023

Hi Experts, Good Morning, Of course it is repeated question could you please give solution interviewer question Q1). Points wise difference between Libname (implicit pass thur query) and sql pass thru query (Explicit pass thru) which one can work functions and which is best ?

BrahmanandaRao · ‎08-29-2023

data MyData; input Var1 Var2 Var3; datalines; 10 20 30 15 25 35 5 15 10 ; run; how to columns sum in data step method

BrahmanandaRao · ‎08-26-2023

data ds_missing_values; infile datalines dlm=','; input group $ var1 var2 var3; datalines; A, 1, 2, 3 A, ., 2, 5 A, 3, 4, . A, 8, ., . B, ., ., . B, ., 2, 6 B, 3, 1, 8 C, 9, 4, 8 ; run; How to replace missing values with next values for repective variables missings output like below A 1 2 3 A 3 2 5 A 8 4 6 A 3 2 6 B 3 2 6 B 3 2 8 C 9 1 8

BrahmanandaRao · ‎08-23-2023

data special; input var1$ 1-12 var2$ 14-22 var3$ 24-35 var4$ 37-52 var5$ 54-67 var6$ 69-76 var7$ 78-84; datalines; */=464aa_!@# 12AAP@!$% RAL%&*()!!54 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj78 yyaa778 */=464aa_!@# 12AAP@!$% RAL%&*()!!55 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj79 yyaa779 */=464aa_!@# 12AAP@!$% RAL%&*()!!56 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj80 yyaa780 */=464aa_!@# 12AAP@!$% RAL%&*()!!57 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj81 yyaa781 */=464aa_!@# 12AAP@!$% RAL%&*()!!58 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj82 yyaa782 */=464aa_!@# 12AAP@!$% RAL%&*()!!59 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj83 yyaa783 */=464aa_!@# 12AAP@!$% RAL%&*()!!60 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj84 yyaa784 */=464aa_!@# 12AAP@!$% RAL%&*()!!61 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj85 yyaa785 */=464aa_!@# 12AAP@!$% RAL%&*()!!62 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj86 yyaa786 */=464aa_!@# 12AAP@!$% RAL%&*()!!63 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj87 yyaa787 */=464aa_!@# 12AAP@!$% RAL%&*()!!64 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj88 yyaa788 */=464aa_!@# 12AAP@!$% RAL%&*()!!65 8711UURR##!!*()) ZKQL+_))&%#%## lsjkfj89 yyaa789 ; run; data rspl; set special; array v[*] _character_; do i= 1 to dim(v); v[i]=compress(v[i],,'kad'); end; drop i; proc print noobs; run;

Re: swap rows based on name column

Re: swap rows based on name column

Re: swap rows based on name column

swap rows based on name column

compress space while import excel file

nth occurrence substring in a string

extract N obs in proc sql

Date related

Re: Find min and max salary for each dept_id using proc sql and datast...

Find min and max salary for each dept_id using proc sql and datastep

Re: extract only last number in a text with out regex method

Re: extract only last number in a text with out regex method

Re: Dataset Transformation Problem

Re: PROC SQL QUESTION. How to add a row number to a table observation ...

Re: UPCASE ALL VARIABLES IN DATASET

SAS to Python

infile statement with filter

keep required email address in observations

Re: if then do else if do

Print all datasets

Re: how to extract first and last names if last word is space

how to extract first and last names if last word is space

replace zeros even numbers row wise

Re: Nth Occurance as word in a string without regex

Nth Occurance as word in a string without regex

Re: how to create data using macros

how to create data using macros

cumulative sales for two months

Between operator to delted range of observations in datastep

Re: How to get only positive values

How to get only positive values

Points wise difference between Libname statement (implicit pass thru q...

columnns total in sas datastep

how to replace missings values with nextvalues

Re: How to identified special characters variables in dataset