LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 15 Dec 2009 17:33:26 -0500
Reply-To:     saslearn chicago <sasswamy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         saslearn chicago <sasswamy@GMAIL.COM>
Subject:      =?windows-1252?B?UmU6IE1BQ1JPIOKAkyB3aXRoICVJRg==?=
Comments: To: mlhoward@avalon.net
In-Reply-To:  <20091215140418.47DF6790@resin11.mta.everyone.net>
Content-Type: text/plain; charset=windows-1252

That sounds a great idea , thanks again

- swamy On Tue, Dec 15, 2009 at 5:04 PM, Mary <mlhoward@avalon.net> wrote:

> Yea! Someone who actually considers my idea! > > -Mary > > --- sasswamy@GMAIL.COM wrote: > > From: saslearn chicago <sasswamy@GMAIL.COM> > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: MACRO – with %IF > Date: Tue, 15 Dec 2009 16:53:52 -0500 > > Thanks Ronald and everyone for your help. > I do not see any necessary for a Macro , so I am going with the data steps. > > - swamy > On Tue, Dec 15, 2009 at 4:26 PM, Fehd, Ronald J. (CDC/CCHIS/NCPHI) < > rjf2@cdc.gov> wrote: > > > you are still confusing macro and data step comparisons: > > > > from: > > > if &site = 'A' then site_name='Test 1 ; > > > > to > > > > either of data step: > > > > if "&site" = "A" then site_name='Test 1'; > > > > or inside macro statement: > > > > %if &site eq A %then %Let site_name = Test 1; > > > > Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > > > > ________________________________ > > > > From: saslearn chicago [mailto:sasswamy@gmail.com] > > Sent: Tuesday, December 15, 2009 4:21 PM > > To: Fehd, Ronald J. (CDC/CCHIS/NCPHI) > > Cc: SAS-L@listserv.uga.edu > > Subject: Re: MACRO – with %IF > > > > > > I should make sure to give the correct example , sorry about that > > .. > > not necessary it would be company A , company B ...that is only > for > > example , it could be different values , > > > > Overall , > > Step 1 : I would get the macro variable &site ( which would > contain > > either 'A' or 'B' , C . D....etc ) > > Step 2 : I need to put the Site name based on the value > > > > not necessary I need a macro , I thought If successful I would try > > to pass the value as a Macro parameter , so that I can call where ever I > > need in the code. > > > > can I replace with this : > > > > data test1; > > %GLOBAL site_name; > > if &site = 'A' then site_name='Test 1 ; > > else if &site = 'B' then site_name='Abc; > > else if &site = 'C' then site_name='XYZ; > > else if &site = 'D' then site_name='Tst Health ; > > run; > > > > - swamy > > > > > > On Tue, Dec 15, 2009 at 3:57 PM, Fehd, Ronald J. (CDC/CCHIS/NCPHI) > < > > rjf2@cdc.gov> wrote: > > > > > > > From: SAS Swamy > > > Subject: MACRO – with %IF > > > > > > > > Hello, > > > > > > Can someone pleast tell me what's wrong in the following > > code , I am > > > getting the Site details through a Macro variable &site > , > > > from which I am > > > assigning the Site name > > > *****************************************************; > > > %macro site_dtls; > > > %GLOBAL sitename; > > > %if &site = 'A' %then sname='Company A'; > > > %else %if &site = 'B' %then sname=' Company B'; > > > %else %if &site = 'C' %then sname=' Company C'; > > > %else %if &site = 'D' %then sname=' Company D'; > > > CALL SYMPUT("sitename", sname); > > > run; > > > %mend; > > > %site_dtls > > > %put &sitename; > > > *****************************************************; > > > I am getting the following error message : > > > CALL SYMPUT("sitename", sname); > > > ---- > > > 180 > > > ERROR 180-322: Statement is not valid or it is used out > of > > > proper order. > > > > > > this is an associative array. > > > > %Let B = Company B; > > %Let C = Company C; > > %Let D = Company D; > > > > %Let Site = C; > > %Let SiteName = &&&Site.; > > %Put SiteName:&SiteName.; > > > > the fix to your macro is > > you do not have a data step name: > > DATA _Null_; > > which is needed for the data step statement > > call symput > > > > Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc > > dot gov > > > > > > >


Back to: Top of message | Previous page | Main SAS-L page