About Shmuel

Shmuel · ‎02-25-2021

To simplify the code I used 365 days as a year, neglecting a leap year: data have; infile datalines delimiter=','; length uniqueid $5 trimgroupid $7; format dob mmddyy10.; input uniqueid $ trimgroupid $ dob mmddyy10. case; datalines; X0131,XX01491,03/10/2000,1 X1831,XX01491,12/05/2002,0 X3691,XX01491,06/02/2000,0 X1971,XX04997,02/05/2010,1 X2611,XX04997,03/13/2011,0 X4371,XX04997,06/25/2009,0 X4621,XX04997,01/01/2009,0 ; run; proc sort data=have; by trimgroupid dob; run; data want; set have; by trimgroupid dob; if dif(dob) ge 365; run;

Shmuel · ‎02-25-2021

Please post the exact code you run, or even better the full log of the run showing the code and the messages.

Shmuel · ‎02-25-2021

Hi @Tom , you are right for the 1st part and I'm right for the 2nd part, as shown in next log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 %macro test(x); 74 %if &x=1 %then %do; 75 %global glb; 76 %end; 77 %let glb=AAA; 78 %mend; 79 %put GLB=&glb; WARNING: Apparent symbolic reference GLB not resolved. GLB=&glb 80 %test(3); 81 %put GLB=&glb; WARNING: Apparent symbolic reference GLB not resolved. GLB=&glb 82 83 %test(1); 84 %put GLB=&glb; GLB=AAA 85 86 %test(2); 87 %put GLB=&glb; GLB=AAA 88

Shmuel · ‎02-25-2021

@Tom , I believe you are right, but as the code is doing a loop, then first time the %GLOBAL macro is executed then it will be present even for the following iterations. (I hope I expressed myself clearly) - Therefore it seems to behave as declarative. Am I not right?

Shmuel · ‎02-25-2021

1) %GLOABAL is a declarative and not executable statement; It is not affected by %IF statement. 2) The usage of SELECT ... INTO needs be followed by a name of a macro variable. Your code: INTO WORK.FRMLST:&OutStr - defines an invalid name. 3) You defined macros GETLIAT and PX but there is no invoking of those macros: %getlist(...);, %px; 4) In your code: %LET FORMS = &FrmLst; - but there is no assignment of value to a macro variable: %LET frmlist = ????; nor argument called FRMLIST=<value> in PX macro. I suggest to explain/clarify what you want to do and the forum will suggest you methods and solutions.

Shmuel · ‎02-25-2021

Can original column contain non numeric value? IF negative better read this column as numeric and you can use format to do the create the new column. I understand you have two tables - (1) defines the transformation/replacement (2) data to deal with: proc format lib=work; value replace 1 = '4' 2 = '5' 3 = '7' 4 = '6' 5 = '14' 6 = '13' 7 = '10' 8 = '15' 9-11 = '9' ; run; data want; set work.DM2_BRANDENBURG; new_var = put(org_var,replace.); run; Pay attention, if original column is char type then you may have issues as '1 ' ne ' 1' for excmaple.

Shmuel · ‎02-25-2021

@Shradha1 wrote: Yes some values will fall into two snaps. The ranges will be overlapping. So the entry for 10APR2020 will be duplicated, against one entry the value will be 30Apr2020 and 31may2020 against other. Similarly for other values Use next coed: data want; set have; if date between '01Mar2020'd and '22Apr2020'd then do; snap='30Apr2020'd; output; end; if date between '01Apr2020'd and '23May2020'd then do; snap='31May2020'd; output; end; if date between '01May2020'd and '22Jun2020'd then do; snap='30Jun2020'd; output; end; if date between '01Jun2020'd and '23Jul2020'd then do; snap='31Jul2020'd; output; end; if date between '01Jul2020'd and '31Jul2020'd then do; snap='31Aug2020'd; output; end; run; Thus you will get the wanted duplicates.

Shmuel · ‎02-25-2021

You don't need a macro but define a format to "translate" range into SNAP. BUT - what would be the snap for 10APR2020? - according to first range it should be 30Apr2020 while according to second range it needs be 31May2020 ???

Shmuel · ‎02-24-2021

data have; input org rep $; cards; 1 A 2 B 3 C 4 D ; run; %let dim=4; /* adapt to your input = 45 */ data want; length rep1-rep&dim $3; /* adapt to max length of REP */ set have end=eof; array or {*} org1-org&dim; array rp {*} $ rep1-rep&dim; or(_N_) = org; rp(_N_) = rep; if eof then output; run;

Shmuel · ‎02-24-2021

I understand that you have 24 numeric variables each is two digits. The minimum length of a record is 24x2=48. I assume max length is about 72. Check next code: data want; infile "<path and file name>.txt" truncover; input code 5. a_line $char72.; a_line = compress(a_line,' '||'09'x); /* remove spaces and tabs */ array varx {*} x1-x24; do i=1 to length(a_line) by 2; varx(i) = input(substr(a_line,i,2),2.); end; drop i; run;

Shmuel · ‎02-24-2021

Please post some sample of your input text file and the list of expected variables with their max length. Without that it is difficult to explain how to do what you want. One of possibilities is to read the whole record as one variable, compress it to remove spaces and then read by position. It needs to take in account string variables (text) - can a variable contain a space/s in between?

Shmuel · ‎02-24-2021

You mentioned "Both of them have say two variables in common:". The only common variables I see are zipcode and year. You mentioned "name is correct" - there is no variable named NAME. In general you can use sql to join data from the two tables: proc sql; create table want as select b.* /* all BASE variables */ ,r.<var1> .r.<var2> /* add as many REFERENCE variables as need */ from BASE as b left join REFERENCE as r on (b.<common var-1> = r.<common var-1> and b.<common var-2> = r.<common var-2> /* compete any more conditions if need */ ) sort by b.<common var-1> , b.<common var-2>; quit;

Shmuel · ‎02-22-2021

You have just 4 variables per array. You don't need sql to create the list. data want; set have; arraiy a {4} q1_2018_units q1_2018_stdunits q2_2018_stdunits q3_2018_stdunits q4_2018_stdunits; array b {4) q1_2018_computed q2_2018_computed q3_2018_computed q4_2018_computed; do i=1 to 4; b(i) = a(i) *100/val/365; end; drop i; run;

Shmuel · ‎02-21-2021

You can check delimiters using notepad++ or msword and brows with view-all symbols.

Shmuel · ‎02-21-2021

The delimiter in your data is sometimes space '20'x and sometimes tab '09'x or both. To read the the data ceorrectly I have added an INFILE statement with appropriate options: Data Longtbl; infile cards dlm='2009'x truncover; input ID field $ labelField $ category $ ; cards; 1 x1 Team a 1 x2 smoker y 1 x3 status 1 2 x1 Team b 2 x2 smoker n 2 x3 status 2 3 x1 Team c 3 x2 smoker n 3 x3 status 2 4 x1 Team a 4 x2 smoker n 4 x3 status 3 5 x1 Team b 5 x2 smoker y 5 x3 status 1 6 x1 Team a 6 x2 smoker y 6 x3 status 1 7 x1 Team c 7 x2 smoker y 7 x3 status 2 8 x1 Team a 8 x2 smoker n 8 x3 status 2 9 x1 Team a 9 x2 smoker y 9 x3 status 3 ; run;

Online Status	Offline
Date Last Visited	‎07-31-2024 01:23 PM

Re: PUTN error. What's the problem with the conversion to 6 characters...

Re: Explanation for calling a macro program in another macro program i...

Re: How to read and import files which sits under multiples folder

Re: SAS options management

Re: Concatenate

Re: Rename Columns Without Knowing The Order & When The Naming Convent...

Re: Rename Columns Without Knowing The Order & When The Naming Convent...

Re: How to use the latest wave's non-missing value to fill missing val...

Re: Multiple PROCs to Single Proc

Re: Multiple PROCs to Single Proc

Re: Macros

Re: "DO OVER" is Undocumented for SAS 9.4, Right?

Re: Convert ddmmmyyyy:hh:mmi:ss to dd-mm-yyyy hh:mm:ss

Re: convert numeric date to another format

Re: Conditionally move the files based on macro variable

Re: Turn Off the SAS Log - How we can do ?

Re: Removing embedded carriage returns

Re: Extract first and last name from character variable

Re: printing result as pdf, al tables same page

Re: ERROR: The SAS System stopped processing this step because of insu...

Re: Differences between Observations By Group

Re: Merging Information From One Dataset To Another But Retaining Orig...

Re: How do I use macros to generate datasets from a list generated fro...

Re: How do I use macros to generate datasets from a list generated fro...

Re: How do I use macros to generate datasets from a list generated fro...

Re: assign data from a column in an array

Re: How to create a macro to create a variable based on value ranges o...

Re: How to create a macro to create a variable based on value ranges o...

Re: assign data from a column in an array

Re: Reading Data That has Missing Spaces

Re: Reading Data That has Missing Spaces

Re: Merging Information From One Dataset To Another But Retaining Orig...

Re: Adding a new group of variables with array

Re: create data set by type raw data

Re: create data set by type raw data

SAS Users Group in Israel