About Aexor

Aexor · ‎05-30-2021

Please explain working of proc format. My question is does this user defined format permanently assigned to variables ? Suppose if I used format, created by proc format , we if load/transfer the same variable/data to a different location. will the format applies using Proc format is applicable or something else?

Aexor · ‎05-28-2021

Thanks much for valuable inputs

Aexor · ‎05-27-2021

yes I used Name only in my third query and output came perfect. My doubt is in above 2 query why the length value is coming different : Query 1: For the below data set the value is coming as CAPON data cha; input name $6.; datelines; CAPONE ; run; but when I change the format to name $7. I am getting value as CAPONE what is the reason here for this truncation. Please explain. Query 2. data chg; set cha; y=length(CAPONE); do i =1 to length(CAPONE); z=substr("CAPONE",i,1); output; end; run;

Aexor · ‎05-27-2021

Addition to this : data chg; set cha; y=length(name); do i =1 to length(name); z=substr(name,i,1); output; end; run; Now the length is coming as 6 and looping is also till 6 . So its correct . Can anyone please explain the all the three conditions ?

Aexor · ‎05-27-2021

Query 1: For the below data set the value is coming as CAPON data cha; input name $6.; datelines; CAPONE ; run; but when I change the format to name $7. I am getting value asCAPONE what is the reason here for this trunctaion. Please explain. Query 2. data chg; set cha; y=length(CAPONE); do i =1 to length(CAPONE); z=substr("CAPONE",i,1); output; end; run; here the value of y = 12 . Why its coming like 12 .Please explain. Thanks!

Aexor · ‎05-26-2021

Hi, is there any way to find out the particular variable consist date values ? I know we can run PROC contents , is there any other way to find out ?? Thanks!

Aexor · ‎05-26-2021

Hi, A sas library consists 10 datasets for e.g SASHELP lib, I want to find the variable having maximum number of unique values present in the SASHELP. Please suggest. Thanks!

Aexor · ‎05-23-2021

Thanks. yes I tried with lag function only. just wanted to check is there any other way to compare values in variable? Can we run a loop , array ? please suggest

Aexor · ‎05-23-2021

Hi, I have this table: id 1 0 0 0 1 0 1 I want to set a flag if any value change is there from the previous one. as shown below: id flag 1 N 0 Y 0 N 0 N 1 Y 0 Y 1 Y here i tried using lag function and compare the value to get flag. Please suggest any other ways to do it. Thanks

Aexor · ‎05-19-2021

Thanks much!

Aexor · ‎05-19-2021

Thanks much!! It's very helpful

Aexor · ‎05-19-2021

Few Question in optimization :- 1. how can we achieve Parallel Processing in SAS.? 2. How can be solve space issue after executing a program in sas 3. how can we optimize a process involves in reading sas data set ? Already tried compress, keep,drop, data _null_ 4. Latency in SAS. these are few questions i came across, i am looking for any suggestion or documentation which talks about these topics. Thanks!

Aexor · ‎05-19-2021

Thanks for clarifying my doubts. Though i updated the code to this and it worked too %macro birthmsg(date,i,n); data birth; set birthdate; %do i =&i %to &n; where DOB="&date"d ; z = cats("Happy birthday", name); %end; %mend birthmsg; options symbolgen mprint; %birthmsg(19-Nov-2006,1,5)

Aexor · ‎05-19-2021

Thank you so much! Can we do same thing in data step ? Could you please check what went wrong here : %macro birthmsg(date,i,n); data birth; set birthdate; %do i =&i %to &n; where DOB="&date"d ; %put "Happy birthday" || name; %end; %mend birthmsg; options symbolgen mprint; %birthmsg(19-Nov-2004,1,2) I am having doubt in how can we check for dates in macro variable? Please help

Aexor · ‎05-19-2021

I have below dataset data birthdate; input name $ DoB date9. ; format DoB date9.; datalines; naomi 19-Nov-2004 pixxa 19-Nov-2006 katty 10-Nov-2009 Sneha 19-Nov-2006 Aron 30-Oct-2009 Snaya 19-Feb-2006 Army 19-May-2009 Page 20-Feb-1982 Suze 11-Sep-1993 Taity 30-Oct-2009 Sainaa 19-Feb-2006 ; run; I want to create a macro where for a given date value , it will check for first 5 records and if it matches it sends "happy birthday <person name> ". it means if DOB =19-Nov-2006 then it will send happy bithday to both pixxa and sneha. 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

Proc format

Re: length statement

Re: length statement

Re: length statement

length statement

Date values

checking for specific values

Re: read and compare next observation in sas

read and compare next observation in sas

Re: Parallel Processing in SAS

Re: Parallel Processing in SAS

Parallel Processing in SAS

Re: macros for date

Re: macros for date

macros for date