About ZRick

ZRick · ‎04-10-2012

just want to summarize put vs %put, This code I thought can summarize where to use %put or put and what it means to data step variable, macro variable, char string %let x=toyota; %macro m; %put &x; put &x; data _null_; put 'x'; put x; %put "&x"; run; %mend; %m put has to be inside the the data step, %put can be anywhere inside data step or macro am I understanding that correctly?

ZRick · ‎04-10-2012

%let var=city; %let n=6; %put &&&&var&n; after 4 ampersand, and resolve to &var6, why &var? I mean it should be &city6.right?

ZRick · ‎04-08-2012

data combo; if _N_=1 then set a; set b; run;proc print;run; Result is : 1 A F 3 A R 2 A G data combo2; put _n_; if 1 then set a; set b; run; proc print;run; result is: 1 A F 3 T R Why is this different?

ZRick · ‎04-08-2012

Should number of records in combo be 2 rather than 3? Why _N_=1 make the minimal record rule not applicable? data a; input x 1. y $2.; datalines; 1 A 5 T ; data b; input x 1. z $2.; datalines; 1 F 3 R 2 G ; data combo; if _N_=1 then set a; set b; run;

ZRick · ‎04-07-2012

Fantastic, I just sent an email to you, really appreciate your help, Art

ZRick · ‎04-07-2012

Hi, Art297, Can you please share the links you have? I really love to check it out.

ZRick · ‎04-07-2012

Well, it confuses me because I don't know how to tell if it is macro variable or data step variable. The example in my question is from: http://www2.sas.com/proceedings/sugi31/107-31.pdf originally it is written like this: %let c=yes; %macro test; %let d=yes; data _null_; if symlocal('c') then put '**** c a is local'; else put '**** c is global'; if symlocal ('d') then put '**** d is local'; else put '**** d is global'; run; %mend test; %test so, you see, c and d are quoted in the symlocal function, and in the macro, %if %then statement are not used but only if then, it confuses me. Can someone help explain?

ZRick · ‎04-06-2012

In a macro program, if, then statement, you have to use %if %then but following macro program it says: ERROR: Required operator not found in expression: symlocal('c') ERROR: The macro TEST will stop executing. Rather, if, then statement works, I can't wrap my head around it. %let c=yes; %macro test; %let d=yes; data _null_; %if symlocal('c') %then %put '**** c a is local'; %else %put '**** c is global'; if symlocal ('d') then put '**** d is local'; else put '**** d is global'; run; %mend test; %test

ZRick · ‎04-04-2012

Can anyone give an example of %eval that returns a boolean value, true/false? In sas help, it says "If at least one operand cannot be interpreted as numeric, the expression is treated as logical." But it doesn't give an example, I tried following: %eval('0'+1); it returned an error I can't think of one example.

ZRick · ‎04-04-2012

1st time, table is like this: var1 var2 RF01 us fin IR eu tech FX ca svc sprd 2nd time, table is like this var1 var2 var3 RF01 RF02 us fin swp crv01 FX eu corp sptn crv02 sprd gb bnk edotn crv04 ir

ZRick · ‎04-03-2012

I want to write SAS code that can read in csv file every time it is read, number of columns maybe different. In addition, I need to use different variables to look up different values. let's say first time I have 3 columns, it's a look up table, use var1 - var2 to look up RF01 next time when I read in the file, it has 5 columns, use var1 - var3 to look up RF01 and RF02 So, given this situation, the column number is not fixed, and also look up column value is different too. Any ideas?

ZRick · ‎03-28-2012

thank you for pointing me the interesting link, but I am more focused on understanding the logic of the code behind it.

ZRick · ‎03-28-2012

I have couple of questions regarding your code: _dsenom is for updating records using index, should it be _DSEMTR? I don't understand the purpose of "otherwise ;" Also, why do we have two output statments?

ZRick · ‎03-28-2012

still try to understand this _N_ better, so what what contains _N_=1? In addition, under _N_=1, it only loop once, is that it?

ZRick · ‎03-28-2012

Ksharp, you said: "At every data loop, SAS will re-build this hash table" I do not understand, where does the loop come from? I removed the line, nothing happened, I still do not see the magic of this line here.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

Re: set IML matrix name based on the do loop, how do I do that?

set IML matrix name based on the do loop, how do I do that?

need the logic to tell if this value looks like numeric

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

Re: how to generate sas code using recursive join

how to generate sas code using recursive join

How do I combine each row into one big row?

what is the purpose of if _N_=1 then do in this data step?

Can macro variables created in select into be local?

how to convert char var to sas date?

how to find closest match that is less than its date?

%put vs put summary question

why multiple ampersand resolve to this?

Re: Set a; set b; minimal record number, not applicable?

Set a; set b; minimal record number, not applicable?

Re: why %if %then does not work?

Re: why %if %then does not work?

Re: why %if %then does not work?

why %if %then does not work?

%eval return an boolean value, how?

how to read in file with number of columns that is different every tim...

how to read in file with number of columns that is different every tim...

Re: what is the purpose of if _N_=1 then do in this data step?

how to write an accumulation statement so that all the obs in the tran...

Re: what is the purpose of if _N_=1 then do in this data step?

Re: what is the purpose of if _N_=1 then do in this data step?