About nehalsanghvi

nehalsanghvi · ‎03-02-2017

Oh, I see. You had the range in the second statement with IN, which is why you probably got an unexpected result. Frankly, I did not know about that issue. But it can be easily cirucmvented by either specifying IN (1,2,3) or if it is a larger range, using the comparison operators (> and < OR >= and <=).

nehalsanghvi · ‎03-02-2017

The note seems to be specific to this scenario: "If a range is used with the IN operator and the IN operator is used again in the same step, you may receive the following error:" There is no range in the code I sent. A usage of range with 'in' would look like this per the same SAS note: if x in(1:3,5) then y=2;

nehalsanghvi · ‎03-02-2017

in operator works with both numeric and character data. It does not convert anything. Can you give us the cdoe you are using?

nehalsanghvi · ‎03-02-2017

""date" in the base dataset gets changed to datetime20" Which is the base dataset? Can you give us some sample data from all tables you are referencing so we can see what might be going on?

nehalsanghvi · ‎03-02-2017

If walk4rec10 does not contain float values, then you could also do this: IF walk4rec10 = . THEN wcat = .; ELSE IF walk4rec10 in (-1,0) THEN wcat = 0; ELSE IF walk4rec10 in (1,2,3) THEN wcat = 1; ELSE IF walk4rec10 > 3 THEN wcat = 2;

nehalsanghvi · ‎03-02-2017

This should work: IF walk4rec10 = . THEN wcat = .; ELSE IF walk4rec10 >= -1 and walk4rec10 <=0 THEN wcat = 0; ELSE IF walk4rec10 >= 1 and walk4rec10 <= 3 THEN wcat = 1; ELSE IF walk4rec10 > 3 THEN wcat = 2;

nehalsanghvi · ‎03-02-2017

data t2; set t; by ID; DupFlag= ^(first.ID and last.ID); run;

nehalsanghvi · ‎03-02-2017

Try this: data t; input ID$; cards; a010 a010 a011 a012 a012 ; run; data t2; set t; by ID; DupFlag= first.ID ne last.ID; run;

nehalsanghvi · ‎03-02-2017

I gave you the statements you needed to change in your macro portion. But here's the whole code: %let i=1; %let name_list = %str(Ramya Ranjan Sahu); options mprint; %macro Name; data word2; %do i = 1 %to %eval(%sysfunc(countw(&name_list))+1); Word=scan("&name_list",&i); /* write value to a data step variable */ %if &i=4 %then %do; Word="No More Words"; %end; output; %end; format word $15.; run; %mend; %name;

nehalsanghvi · ‎03-02-2017

Are you simply trying to see which observations are in one and and not in the other? If so, then this would work: proc sql; create table differing as select *, 'In A, not in B' as Note from a where schcode not in (select schcode from b) union select *, 'In B, not in A' as Note from b where schcode not in (select schcode from a); quit; If you're trying to column compare values as well, then proc compare is the way to go.

nehalsanghvi · ‎03-02-2017

This statement in your macro code is not the same as a data step statement: %let word=%scan(&name_list,&i); The above statement is assigning the value to a macro variable called 'word' which is not the same as the data step variable 'word'. Macro variables do not get saved out to datasets. You cannot simply add % signs to all your data step code and expect it to behave the same. That is simply not what macros are 🙂 These are the statements you need to change: %let name_list = %str(Ramya Ranjan Sahu); word=scan("&name_list",&i); run; /* there is no statement such as %run */

nehalsanghvi · ‎03-01-2017

I don't think you can specify a margin twice. What you are trying to do is insert spaces between CDE and ABC such that ABC lines up with LINE13 on the next line. This code does that by inserting 127 non-breaking spaces, but this is not a very good way to do it as you have to play around a lot to get the number of spaces just right and if you change the casing on the text or add/remove text before the spaces, you have to adjust the number of spaces again: ods pdf text='^S={leftmargin=.75in}CDE ^{nbspace 127}ABC'; ods pdf text='^S={leftmargin=5.25in}LINE13';

nehalsanghvi · ‎03-01-2017

I am not familiar with the x11 proc but its documentation indicates you can use the Quarterly statement if your input data are quarterly. You do not have to use the Monthly statement. http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_x11_sect005.htm And looking at the date option on the Quarterly statement, it does not say that the date has to be in a specific format. It only has to contain SAS date values. So as long as your date variable contains SAS dates and it is not a character date variable, you should be fine. See details on Quarterly statement here: http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_x11_sect015.htm

nehalsanghvi · ‎03-01-2017

The code RW9 posted above will get you what you're looking for: only those ID/IDs with the highest count. If you also want the count included in the result along with the ID, add 'count(*)' to the select statement, the rest of the query remains the same.

nehalsanghvi · ‎02-28-2017

Oops, please exclude the 'not' from the query I posted. I did the opposite above. This is what you need: Proc sql; Create table want as Select * From have Where acct_name like '%CARD%'; Quit;

Online Status	Offline
Date Last Visited	‎07-19-2018 05:20 PM

Re: How to get a complete date from a partial date by comparing with a...

Re: How to use macro variable in infile statement

Re: how to use sas macro to replace a path

Re: how do I input 4 different variables in the same datalines and onl...

Re: Remove Row by User ID

Re: numeric format help - counting digits from left

Re: Matching addresses to a list and creating a new variable

Re: How do I know what version of SAS I'm using?

Re: How do I know what version of SAS I'm using?

Re: Sorting variables by type

Re: Sorting variables by type

Re: if duplicate, check if var1 has content, if no then flag

Re: IF-THE-ELSE Numeric Range

Re: Proc printto not printing entire log

Re: DO LOOP question

Re: How to get a complete date from a partial date by comparing with a...

Re: Remove Row by User ID

Re: how do I input 4 different variables in the same datalines and onl...

Re: How do I know what version of SAS I'm using?

Re: How do I know what version of SAS I'm using?

Re: IF-THE-ELSE Numeric Range

Re: IF-THE-ELSE Numeric Range

Re: IF-THE-ELSE Numeric Range

Re: Help - Proc SQL is changing the formatting of some date variables

Re: IF-THE-ELSE Numeric Range

Re: IF-THE-ELSE Numeric Range

Re: If duplicate, add flag

Re: If duplicate, add flag

Re: Output statement in macro

Re: Finding differeing observations between two tables

Re: Output statement in macro

Re: ODS PDF TEXT QUERY

Re: Converting Dates for Proc X11

Re: getting a group of observations with maximum count

Re: Sound-LIke in data step / contains in Sql