About Sathiskumar_D

Sathiskumar_D · ‎04-25-2019

data dsn; infile datalines missover dsd; length Acct_ID 4 Name$ 7 Birthday 8 Sex$ 3 State$ 3 Cust_Type$ 7 Product$ 9 Balance 4 Last_Tran_Date 8; input Acct_ID 1-4 Name $ 6-11 Birthday mmddyy10. Sex $ 21-23 State $ 24-26 Cust_Type $ 28-33 Product $ 35-43 Balance 4. Last_Tran_Date mmddyy12.; datalines; 1001 John 1/1/1962 M CA Gold Checking 1000 9/1/2015 1002 Mary 2/1/1972 F CA Silver Saving 2000 10/1/2015 1003 Peter 3/1/1982 M NY Gold Loan 3000 10/3/2016 1004 mary 4/1/1992 F NY Silver Checking 4000 9/17/2016 1005 Linda 5/1/1994 F WA Gold Saving 5000 1006 Susan 6/1/1997 F WA Gold Loan 1000 9/15/2016 1007 Sam 7/1/1999 M CA Gold Checking 2000 2/1/2016 1008 Thomas 8/1/1962 M CA Silver Checking 3000 7/1/2016 1009 Linda 9/1/1982 F NY Silver Saving 4000 ; run; proc print data=dsn; format last_Tran_Date year4.; run; This is my data in datalinesMy expected result in the format is attached above.my code which is working but expecting in the format options symbolgen mprint; %macro dsn(title=, vars= ); proc report data=profile3; title "&title"; column Acct_ID Name Balance Last_Tran_Date; define Acct_ID / display; define Name / display; define Balance / analysis sum; define Last_Tran_Date / display; rbreak after / summarize; run; %mend dsn;

Sathiskumar_D · ‎04-24-2019

options symbolgen mlogic; %macro accountreport (State=,Age=,Last_Tran_Date=); %let title=Detail Listing of Account; data profile3; set myprj2.profile2 (keep=Acct_ID Name Birthday State Balance Last_Tran_Date); /*Age=((int(today()-birthday)/365.25));*/ Age=intck('Year',birthday,today()); /*birthdate=input(birthday,mmddyy10.);*/ format Last_Tran_Date year4. Age 3.0 Birthday best.;/*stored in numeric format*/ run; options symbolgen mprint; %macro dsn(title=, vars= ); proc report data=profile3; title "&title"; column Acct_ID Name Balance Last_Tran_Date; define Acct_ID / display; define Name / display; define Balance / analysis sum; define Last_Tran_Date / display; rbreak after / summarize; run; %mend sat; options mprint; %dsn (vars=Acct_ID Name Balance Last_Tran_Date); I am trying to create a report based on this format.Will this code work ?I am not sure how the title and the row followed by title will be achieved

Sathiskumar_D · ‎04-23-2019

options symbolgen mlogic; %macro accountreport (State=,Age=,Last_Tran_Date=); %let title=Detail Listing of Account; data profile3; set myprj2.profile2 (keep=Acct_ID Name Birthday State Balance Last_Tran_Date); Age=((int(today()-birthday)/365.25)); /*birthdate=input(birthday,mmddyy10.);*/ format Last_Tran_Date year4. Age 3.0 Birthday best.;/*stored in numeric format*/ run; /*proc print data=profile3; run;*/ /*proc contents data=profile3; run;*/ proc print data=profile3; var Acct_ID Name Age Balance Last_Tran_Date; sum Balance; where Age=&Age and year(Last_Tran_Date)=&Last_Tran_Date; title &title; run; %mend accountreport; options mprint; %accountreport(Last_Tran_Date=2015); It is still showing ERROR!

Sathiskumar_D · ‎04-22-2019

I need the sum for balance not for any character variable..

Sathiskumar_D · ‎04-22-2019

Yes..I did..It is still showing error

Sathiskumar_D · ‎04-22-2019

variable name in the list does not match type prescribed in this list.. Does it mean var statement will not accept any char variable???

Sathiskumar_D · ‎04-22-2019

it is still showing error.

Sathiskumar_D · ‎04-22-2019

options symbolgen mlogic; %macro accountreport (State=,Age=,Last_Tran_Date=); %let title=Detail Listing of Account; data profile3; set myprj2.profile2 (Keep=Acct_ID Name birthday State Balance Last_Tran_Date); Age=((int(today()-birthday)/365.25)); format Last_Tran_Date year4.; run; /*proc contents data=profile3; run;*/ proc summary data=profile3; where Age="&Age" and Last_Tran_Date="&Last_Tran_Date"; var Acct_ID Name Age Balance Last_Tran_Date; output out=summarized_data sum=Balance; run; proc print data=summarized_data; title "&title"; run; %mend accountreport; %accountreport(Last_Tran_Date=2015); I don't understand the error message.I checked the proc contents too..

Sathiskumar_D · ‎04-19-2019

%macro accountreport(State=); proc sql; title "&title"; create table mydata as select Acct_ID,Name,birthday format ddmmyy8.0,Sex,State format $char8.,Cust_Type,Product,Balance,Last_Tran_Date=symget('tran_date') from myprj2.profile2; quit; %mend accountreport; ERROR: Expression using equals (=) has components that are of different data types. proc content of the data is attached..

Sathiskumar_D · ‎05-08-2017

Thanks mr.KurtBremser.I am still in the learning curve.

Sathiskumar_D · ‎05-08-2017

data WORK.LOOP; X = 0; do Index = 1 to 5 by 2; X = Index; end; run; Upon completion of execution, what are the values of the variables X and Index in the SAS data set named WORK.LOOP? X = 3, Index = 5 X = 5, Index = 5 X = 5, Index = 6 X = 5, Index = 7 I knew the answer was X=5 and index=7; Question is : When the index =5, isn't the program stop executing DO loop and gives the answer of index=5 and x=5.However, the answer was X=5 and index=.How??????

Sathiskumar_D · ‎05-07-2017

It is Third Edition (Page # 608 and Chapter 20).They had provided an example where '@' pointer control was NOT used.However, the caveat, that was mentioned, is for double trailing '@@'.

Sathiskumar_D · ‎05-07-2017

SAS prep Guide says that '@' or '@@' cannot be used with @pointer control, with column input, nor with the MISSOVER option.In my question, however, there is '@'pointer control.

Sathiskumar_D · ‎05-07-2017

When I posted the question first time, it didn't aacept the question.I am not aware of the fact that my previous question was posted.My apologies.

Sathiskumar_D · ‎05-07-2017

I found out the answer by creating the color.txt file and submitting in the SAS Univ Edn. However,I couldn't figure out the reason for the answer. The question is : Given the text file COLORS.TXT: ----+----1----+----2----+---- RED ORANGE YELLOW GREEN BLUE INDIGO PURPLE VIOLET CYAN WHITE FUCSIA BLACK GRAY BROWN PINK MAGENTA The following SAS program is submitted: data WORK.COLORS; infile 'COLORS.TXT'; input @1 Var1 $ @8 Var2 $ @; input @1 Var3 $ @8 Var4 $ @; run; What will the data set WORK.COLORS contain? options are: Var1 Var2 Var3 Var4 ------ ------ ------ ------ RED ORANGE RED ORANGE BLUE INDIGO BLUE INDIGO CYAN WHITE CYAN WHITE GRAY BROWN GRAY BROWN Var1 Var2 Var3 Var4 ------ ------ ------ ------ RED ORANGE BLUE INDIGO CYAN WHITE GRAY BROWN Var1 Var2 Var3 Var4 ------ ------ ------ ------ RED ORANGE YELLOW GREEN BLUE INDIGO PURPLE VIOLET Var1 Var2 Var3 Var4 ------ ------ ------ ------ RED ORANGE YELLOW GREEN BLUE INDIGO PURPLE VIOLET CYAN WHITE FUCSIA BLACK GRAY BROWN PINK MAGENTA

Online Status	Offline
Date Last Visited	‎04-30-2019 07:57 PM

Re: Will this code give me an expected result?

Will this code give me an expected result?

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

where clause operator incompatible variables

how to solve this problem?

Re: DO loop basics

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: Will this code give me an expected result?

Re: Using SAS University, Cannot use "PROC GPLOT"

Re: Basics

Re: Will this code give me an expected result?

Will this code give me an expected result?

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

Re: where clause operator incompatible variables

where clause operator incompatible variables

how to solve this problem?

Re: DO loop basics

DO loop basics

Re: input with '@' informat

Re: input with '@' informat

Re: Logic for getting this answer

Logic for getting this answer