About Jcorti

Jcorti · ‎05-05-2017

Thanks Team, I did some adjustment to my code based on all your suggestions: %macro vars; %let outobs=max; %do i=0 %to 24; %let b =&i; %let var1=test1&b; %let var2=test2t&b; %let var3=test3&b; %let var4=test4t&b; %let var5=test5&b; %let var6=test6&b; %let month=period_&b; proc sql; create table &month as select filler5 ,&var1 ,&var2 ,&var3 ,&var4 ,&var5 ,&var6 ,case when &var1<>-16 or &var2<>-16 or &var3<>-16 or &var4<>-16 or &var5 is not null then 1 else 0 end as &month from SAS_Out.&Data_Out WHERE a='x'; ; run; %end; run; %mend vars; %vars; And it worked perfectly. An now can you understand what I am tryng to do?? Thanks Again all JC

Jcorti · ‎05-05-2017

Hi Team, I am getting an issue when I am delcaring macro variables, data test; %let %do i=0 %to 24; %let var1=a&i; %let var2=b&i; %let var3=c&i; %let var4=d&i; %let var5=e&i; %let month=period&i; output; %end; run; This is the error; ERROR: Open code statement recursion detected. Anyone can Help me on this?? Thanks a lot in advance

Jcorti · ‎03-28-2017

Thanks man!! It worked for me !!

Jcorti · ‎03-28-2017

Hi All, I want to see only records with differences included in my output with the structure shown below: _TYPE_ obs var1 var2 var3 var4 BASE 1 34 115003481 1214 48 COMPARE 1 34 115003481 1214 48 DIF 1 34 115003481 1214 48 The program used was: proc compare base=F.&MATCH1 compare=F.&MATCH2 OUT=F.&DIFF outbase outcomp outdif ; id var1 var2 var3 var4 ; run; Number of Observations in Common: 4083722. Number of Observations in F.MATCH1 but not in F.MATCH2: 158. Total Number of Observations Read from F.MATCH1: 4083722. Total Number of Observations Read from F.MATCH2: 4083880. Number of Observations with Some Compared Variables Unequal: 2. Number of Observations with All Compared Variables Equal: 4083720. Values Comparison Summary Number of Variables Compared with All Observations Equal: 173. Number of Variables Compared with Some Observations Unequal: 2. Number of Variables with Missing Value Differences: 2. Total Number of Values which Compare Unequal: 2. Maximum Difference: 0. Why my output file is generating more than 12 millions of observations -including that are exactly equals in both files- ??, I only want on my ouput file with unequals observations, like this: Number of Observations with Some Compared Variables Unequal: 2. Thanks in advance and regards, JC

Jcorti · ‎03-28-2017

Thanks for your solution

Jcorti · ‎03-27-2017

Hi Team, I found a code to get only duplicates using proc sort. But I need to get the duplicates with more variables ..example var1, var2, var3, var4 .. Somebody how to do it?? Thanks, proc sort data = test; by var1; run; data single dup; set test; by var1; if first.var1 and last.var1 then output single; else output dup; run;

Jcorti · ‎02-26-2017

Thanks I really like your solution. Do you know why after execution of this code It generates numeric values? data test ; do i=rank('a') to rank('y') by 1; output; end; run;

Jcorti · ‎02-26-2017

Thanks a lot; I did some adjustement to your code but finally worked. data output.&cons (drop=r1 r2 "Range Start"n "Range End"n j letter) ; retain month_var Range "Current Count"n "Current %"n " Previous Count"n "Previous %"n "% Change"n ; do j=0 to 2499; set output.&cons; r1=put(input("Range Start"n,15.),comma12.); r2=put("Range End"n,comma15.); letter = byte(mod(j,25)+rank('a')) ; Range=CATX(':',letter,(CATX('_',r1,r2))); output; end; this is a sample of the variable generated after execution a:._0 b:1_100 c:101_500 d:501_1,000 e:1,001_1,500 f:1,501_2,000 g:2,001_2,500 h:2,501_5,000 i:5,001_7,500 j:7,501_10,000 k:10,001_15,000 l:15,001_20,000 m:20,001_25,000 n:25,001_30,000 o:30,001_40,000 p:40,001_50,000 q:50,001_100,000 r:100,001_200,000 s:200,001_300,000 t:300,001_500,000 u:500,001_1,000,000 v:1,000,001_5,000,000 w:5,000,001_10,000,000 x:10,000,001_50,000,000 y:50,000,001_100,000,000 a:._0 b:1_100 c:101_500 d:501_1,000 e:1,001_1,500 f:1,501_2,000 g:2,001_2,500 h:2,501_5,000 i:5,001_7,500 j:7,501_10,000 k:10,001_15,000 l:15,001_20,000 m:20,001_25,000 n:25,001_30,000 o:30,001_40,000 p:40,001_50,000 q:50,001_100,000 r:100,001_200,000 s:200,001_300,000 t:300,001_500,000 u:500,001_1,000,000 v:1,000,001_5,000,000 w:5,000,001_10,000,000 x:10,000,001_50,000,000 y:50,000,001_100,000,000 Thanks a lot again!!!!

Jcorti · ‎02-26-2017

What do you mean by %let j=i; in first step ? Iterates 100 times from a: to x: if you add %put J= &j; after first run you'll find in log that J=i as a constant. did you mean: j=i in order to save the sequence number or call symput('j',i) which will keep the last value of i, i.e. 100. the r=&j in your code result in r='i' or if you use call symput you will get r=100. I suppose you didn't mean neither of the two. Please give an example of: r1 = 'Range Start'n = 100; r2 = 'Rabge End'n = 200; what shold be r ? what is the connection between first step and the others ? what result of catx you expect ? This is the example using Range=CATX('_',r1,r2); ._0 1_100 101_500 501_1,000 1,001_1,500 1,501_2,000 .. .. .. 50,000,001_100,000,000 This is the expected results using that I neeed Range=CATX('_',r,r1,r2); a:._0 b:1_100 c:101_500 d:501_1,000 e:1,001_1,500 f:1,501_2,000 .. .. .. x:50,000,001_100,000,000

Jcorti · ‎02-25-2017

Hi All, Someone of you have you ever concatenate a variable from another dataset? I want to concatenate char values like a., b., c. until x. with a range previously defined (combination of r1 and r2 variables) The issue that I am getting is with "r" variable that I want to concatenate with "r1" and "r2". Mu dataset has 2500 observation and variable "range" has 25 ranges --That´s why I am doing this on my code because the range is repeating 100 times do j=1 to 100; Any suggestion on that?? Thanks, %macro concat; data testa (keep=i) ; do j=1 to 100; do i='a.','b.','c.','d.','e.','f.','g.','h.','i.','j.','k.','l.', 'm.','n.','o.','p.','q.','r.','s.','t.','u.','v.','w.','x.','y.'; %let j=i; output; end; end; run; data test (drop=r1 r2 "Range Start"n "Range End"n) ; retain month_var Range "Current Count"n "Current %"n " Previous Count"n "Previous %"n "% Change"n ; set output.&cons; r1=put(input("Range Start"n,15.),comma12.); r2=put("Range End"n,comma15.); r=&j. Range=CATX('_',r,r1,r2); run; %mend concat; %concat;

Jcorti · ‎02-25-2017

This worked properly: data test (keep=jj);; do ii=1 to 100; do jj=1 to 25 ; output; end; end; run; Why this does not work?? data test (keep=jj);; do ii=1 to 100; do jj=1 to 25 ; i = %sysfunc(putn(jj,z2.)); output; end; end; run; ERROR: Argument 1 to function PUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. 43 i = %sysfunc(putn(jj,z2.)); _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT.

Jcorti · ‎02-25-2017

3 times is only an example that I need, actually I need 100 times repetead the same loop in order to create the table required with one column like shown above. I need that table because I will concatenate with another table.

Jcorti · ‎02-25-2017

this is the output that I need: 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Jcorti · ‎02-25-2017

Hi Team, I want to do a "do loops" 3 times with 75 obervations With my example I am getting from 00 to 24 with 25 observations Do you know how to do it? Thanks data test; %do i1=0 %to 24 ; %let i = %sysfunc(putn(&i1,z2.)); %end;

Jcorti · ‎02-24-2017

Thanks Man!! My variable Previous Count I don´t know why had leading spaces values, " Previous Count"n comma15. and it worked properly Thanks again

Online Status	Offline
Date Last Visited	‎01-24-2018 12:29 PM

Re: Issue with macro variables %let

Issue with macro variables %let

Re: Output of Proc Compare get only differences

Output of Proc Compare get only differences

Re: Keeping only duplicates with proc sort with more than one variable

Keeping only duplicates with proc sort with more than one variable

Re: Concatenate with CATX

Re: Concatenate with CATX

Re: Concatenate with CATX

Concatenate with CATX

Re: Issue with macro variables %let

Issue with macro variables %let

Re: Output of Proc Compare get only differences

Output of Proc Compare get only differences

Re: Keeping only duplicates with proc sort with more than one variable

Keeping only duplicates with proc sort with more than one variable

Re: Concatenate with CATX

Re: Concatenate with CATX

Re: Concatenate with CATX

Concatenate with CATX

Re: do loop n times

Re: do loop n times

Re: do loop n times

do loop n times

Re: keep order of data set