About CTorres

CTorres · ‎08-22-2014

Eric, You can use the follwing macro to solve steps 1 and 2: data have; input col1 col2 col3 col4 col5 col6 col7; cards; 1 2 3 4 5 6 7 1 3 5 7 9 11 13 ; run; %macro absolute; %let six=6; %let seven=7; data want; set have; %do i=1 %to &six; %let k=%eval(&i+1); %do j=&k %to &seven; col&i._&j = abs(col&i - col&j); %end; %end; run; %mend absolute; %absolute For Step 3 you can create the flag variables using the following instruction just after calculating the col&i._&j variable: flag&i._&j = col&i._&j < &trigger; &trigger should the value of six months in seconds: 6*30*24*60*60: %let trigger=15552000; Regards,

CTorres · ‎07-09-2014

Try the ROUND function.

CTorres · ‎07-09-2014

Try this macro (untested): %macro libnames; %let root='C:\Users\desktop\folder'; data _null_; set list_of_folders(keep=folder_name) nobs=nobs; /* SAS Dataset containing the names of the folders */ if _N_=1 then call symput("N_Libs",nobs); folder=cats("Folder",_N_); library=cats("Lib",_N_); lib_name=cats('L',substr(folder_name,1,4),substr(folder_name,7,2)); call symput(folder,folder_name); call symput(library,lib_name); run; %let i=1; %do %while (&i <= &N_Libs) libname &&Lib&i "&root.\&&Folder&i"; %let i= %eval(&i+1); %end; %mend libnames; %libnames The Data _null_ step creates the 80+ macrovariables containing the librefs (i.e. L032113, L050513, etc) and folder_names. Hope this helps,

CTorres · ‎06-27-2014

Hi loredana, According to the SAS Documentation, the MISSING system option does not replace missing values in numeric variables but instead "Specifies the character to print for missing numeric values." so I think that the correct solution for this request would be to use the same approach used to replace the character variables with the coalesce function: data "database name"; /*for missing character variables, write this code as it is except the "database name" thing */ set "database name"; array ch(*) _character_; array nm(*) _numeric_ ; do _n_ = 1 to dim(ch); ch(_n_) = coalescec(ch(_n_), '0'); end; do _n_ = 1 to dim(nm); nm(_n_) = coalesce(nm(_n_),0); end; run; CTorres

CTorres · ‎06-25-2014

You can find the documentation to restrict system options in: http://support.sas.com/documentation/installcenter/en/ikfdtnwincg/64431/PDF/default/config.pdf

CTorres · ‎06-13-2014

Complete the solution with Proc TRANSPOSE: proc transpose data=almostwant out=want(drop=_name_) prefix=QTY; by part; id year; var quantity; quit; Regards,

CTorres · ‎06-11-2014

I think you do not need a macro and what you need is the following program: Data have; input var1 var2 var3; cards; 1 2 3 4 5 6 2 8 2 4 6 3 2 3 5 ; run; data want; set have; var1_new=var1+var2; var2_new=var2+var3; run; Regards,

CTorres · ‎05-23-2014

You are rigth. I did not see the words "all occurrences of zeros"

CTorres · ‎05-22-2014

Try this: data have; input ACCT FLAG; cards; 14710 1 14710 0 14710 1 49730 1 49730 0 49730 1 15293 1 15293 1 1147 1 1147 0 1147 0 13664 1 13664 1 13664 1 ; run; data want (drop=save); set have (rename=(flag=save)); retain FLAG; by acct notsorted; if first.acct then flag=save; flag=save and flag; if last.acct then output ; run; Regards,

CTorres · ‎05-21-2014

data have; length ID $ 2 Type $ 8 Provider $ 2; input id type provider; cards; 01 CBE A 01 Mam A 01 US B 01 Biopsy B ; run; proc transpose data=have out=want(drop=_name_); by ID; id type; var provider; run; Regards,

CTorres · ‎02-26-2014

1. Define the LIBNAME 2. Use PROC CONTENTS.

CTorres · ‎02-25-2014

You can do this in only one step using functions COUNTW and SCAN specifing the blank as separator of words. data want ; length word $ 20; set m01; do i = 1 to countw(a,' '); word=(scan(a,i,' ')); output; end; run; Regards,

CTorres · ‎02-14-2014

I would use multiple OR conditions in only one IF statement: data Clean Dirty; set SourceData; if PRXMATCH("/\d/", address) = 0 and PRXMATCH("/\d/", address) = 0 OR City = '' or PRXMATCH("/\d/", City) ne 0 OR length(State) ne 2 or PRXMATCH("/\d/", State) ne 0 OR country='US' and length(Zip) < 5 OR country='CA' and length(Zip) > 7 OR missing(Name) OR Location=. OR (index(Email,'@') = 0 and index(Email,'.') = 0 and Email ne '') then output Dirty; else output Clean; run; Regards,

CTorres · ‎02-14-2014

Well, I dont know much about SCD Type 1 Loader but the Warning seems to be produced by a Proc Append with Force. The following small SAS program generates the same Warning message: data base; length flag 3; do flag=1 to 5; output; end; run; data data; length flag 8; do flag=6 to 8; output; end; run; proc append base=base data=data force; run; 17 data base; 18 length flag 3; 19 do flag=1 to 5; 20 output; 21 end; 22 run; NOTE: The data set WORK.BASE has 5 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 23 data data; 24 length flag 8; 25 do flag=6 to 8; 26 output; 27 end; 28 run; NOTE: The data set WORK.DATA has 3 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 29 proc append base=base data=data force; 30 run; NOTE: Appending WORK.DATA to WORK.BASE. WARNING: Variable flag has different lengths on BASE and DATA files (BASE 3 DATA 8). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 3 observations read from the data set WORK.DATA. NOTE: 3 observations added. NOTE: The data set WORK.BASE has 8 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds look at the code generated by the transformation and If this is the case then you should follow the suggestion given by data_null_; Regards,

CTorres · ‎02-14-2014

Please provide more information: What transformation are you using? Are you using SAS Tables? Oracle?

Online Status	Offline
Date Last Visited	‎09-22-2015 01:35 PM

Re: Time Conversion

Re: re: email attachments

Re: Import zip csv file to SAS, Date variable values missing

Re: re: email attachments

Re: insert rows based on output from subtracting two rows in the same ...

Re: Read Hierarchical Files in SAS DI Studio

Re: Macro to Combine Municipal Proc SQL Statements Based on Date Crite...

Re: Creating Last First Mi from a single variable

Re: Removing Character Value from String at Specific Position in Strin...

Re: Removing Character Value from String at Specific Position in Strin...

Re: Slicing a SAS datset

Re: how to calculate differences from a baseline value

Re: A thought about making the forum even more useful

Add BATCH SUBMIT button to EG

Re: DI Studio 4.7, work table question

Re: create distribution of all the variables of a dataset using macro

Re: Warning in DI Studio

Re: Parse text data into individual words

Re: how to select observations with certain values

Re: Using the best of delta updated DW tables and snapshot retrieval o...

Re: Calculate absolute value of difference of every possible pair of a...

Re: Proc Expand

Re: How do I iteratively create multiple libnames using a do loop?

Re: Replace missing values with 0

Re: How to specify the emailid option in the cfg-file

Re: proc sql sumation

Re: Macros

Re: keep and delete records

Re: keep and delete records

Re: Transposing (?) Data

Re: How to get a list of the names of all SAS data files in my folder?

Re: Which word appears at most

Re: Conditionally output to Datasets across multiple conditions

Re: Warning in DI Studio

Re: Warning in DI Studio