About buckeyefisher

buckeyefisher · ‎05-28-2015

My year field has been stored in character field of 25 length. I want to convert this to date field with years. I tried this code but the output is empty data want; set have; date_sas=input(put(dateinchar, 4.), yymmdd8.); format date_sas date 9.; run;

buckeyefisher · ‎04-27-2015

Two solutions worked perfectly. One with including a text file and other with calling a macro (and yes making all small caps and saving it as .SAS file). data want; set have; %include "s:\temp\rob\tmp.txt"; run; data want; set have; %prxmatch run; Thanks you very much !!!

buckeyefisher · ‎04-27-2015

RW9, My input file has strings on which I want to run PRXmatch command and there are more than 500 Proxmatch commands that I want to run. The 500+ commands are used in multiple programs hence I want to use a macro. Required output - Extract the 500+ strings into the output file. Hope this helps. ----------------------- options sasautos=(sasautos "\\C:\Users\Macro"); * this has my macro - PRXmatch Data want; set have; call execute('%PRXmatch'); run; this is the macro %macro Prxmatch; if prxmatch("m/XXX/oi",Partner1) > 0 then Principal= 'X'; .. %mend PRXmatch; -----------------------

buckeyefisher · ‎04-27-2015

PaigeMiller, I followed the step and following is the code. options sasautos=(sasautos "\\C:\Users\Macro"); * this has my macro - PRXmatch Data want; set have; call execute('%PRXmatch'); run; this is the macro %macro Prxmatch; if prxmatch("m/XXX/oi",Partner1) > 0 then Principal= 'X'; .. %mend PRXmatch; It gives me this error - Apparent invocation of macro PRXMATCH not resolved.

buckeyefisher · ‎04-24-2015

I use following code in multiple programs. My problem is that if I change any code here then , I need to make same changes in multiple programs to keep it synchronized. Is there a way to write a macro, insert the following code in that macro and call that macro in all programs? In that way I just if I need to make updates then I just need to makes changes to one macro and need not worry about keeping all programs synched up. Data A; set B; if prxmatch("m/XXX/oi",Partner1) > 0 then Principa = 'X'; if prxmatch("m/YYYY/oi",Partner1) > 0 then Principal_SDC= 'Y'; if prxmatch("m/ZZ/oi",Partner1) > 0 then Principal_SDC= 'Z'; if prxmatch..... if prxmatch.. . . . . run; Thanks,

buckeyefisher · ‎04-06-2015

that's clever!!! Perfect, it works in the current scenario. Thanks

buckeyefisher · ‎04-06-2015

Thanks Astounding, but I forgot to mention that my master file should not get overwritten by the transaction file if the record exists in the master file. So SAS update command may not help.

buckeyefisher · ‎04-06-2015

It is not necessary to have a SQL ,but I thought SQL could be cleaner and simpler.

buckeyefisher · ‎04-06-2015

I want to append a master file with update file based on index (Company Year) File Master Company Year Revenue A 1991 100 A 1992 200 A 1993 300 C 1991 100 File update Company Year Revenue A 1991 100 A 1993 300 B 1991 50 B 1992 100 C 1991 100 Output Company Year Revenue A 1991 100 A 1992 200 A 1993 300 B 1991 50 B 1992 100 C 1991 100 I am using this code - but it does not remove duplicates proc sql; create table want as select * from Master union all corr ( select * from update except all select * from master) ; run;

buckeyefisher · ‎03-21-2015

Xia, This works seamlessly. Prc SQL is much cleaner than Lag in loop. Thanks a lot.

buckeyefisher · ‎03-21-2015

Hi Xia, I want to count Development in 5 years for each Year. For example for Year = 1998 the window is from 1996 to 1991 (Year - 2 to Year - 7) input : Company Year Development A 1990 1 A 1992 1 A 1993 0 A 1994 1 A 1995 0 A 1996 1 A 1998 0 B 1991 1 B . . output needed Company Year Development Window Count A 1990 1 1988-1983 0 A 1992 1 1990-1985 1 A 1993 0 1991-1986 1 A 1994 1 1992-1987 2 A 1995 0 1993-1988 2 A 1996 1 1994-1989 3 A 1998 0 1996-1991 3 B 1991 1 1989-1984 0 B . . Thanks

buckeyefisher · ‎03-20-2015

Hi, I want to sum the lagged values for a given window of years. For example if the Year = 1990 then window is between 1983 to 1988. I want to add values of a field in this window. I wrote the following code. The system is not giving any errors but not calculating values. There can be some missing years so I can not put an exact counter of 7 /*** first step to calculate window data A; set B; wind2 = Year-2; wind1 = Year-7; /****lag in loop %macro test; data C; set B; %do n=1 %to 20; if wind1 le lag&n.(Year) and wind2 ge lag&n.(Year) then CoDevelopment_cnt = sum(CoDevelopment_cnt,lag&n.(CoDevelopment)); %end; run; %mend; %test;

buckeyefisher · ‎02-10-2015

I am wondering why SAS is not recognizing the date even when I set the column property in excel as date format. I am importing excel using this proc import datafile='input.xls' dbms=xls out=output replace; sheet="Profile"; run; I have 4000 rows, so can you please give me code?

buckeyefisher · ‎02-10-2015

log doesn't give that information. Here is the log PROC SQL noprint; 107 CREATE TABLE want AS 108 SELECT *, input('Established Date'n,ANYDTDTE22.) as new_date format=mmddyy12. 109 FROM input; NOTE: Table WORK.WANT created, with 4263 rows and 10 columns. 110 QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.05 seconds cpu time 0.04 seconds

buckeyefisher · ‎02-10-2015

Although my excel has a field in date format, SAS is importing it in Character format. For example date in excel is 12/31/2008 but its imported in SAS as 39813. So I tried following code to correct it but not getting correct date. PROC SQL noprint; CREATE TABLE want AS SELECT *, input('Established Date'n,ANYDTDTE22.) as new_date format=mmddyy12. FROM input; QUIT; Can someone help? Thanks

Online Status	Offline
Date Last Visited	‎02-10-2023 03:15 AM

Filling missing values with group and subgroup

Re: Importing multiple Excel files

Importing multiple Excel files

Re: Changing variables from upper to lower case

Re: Changing variables from upper to lower case

Changing variables from upper to lower case

Re: Looping using 2 files

Looping using 2 files

Re: How to extract specific 4 digits from large string where the locat...

How to extract specific 4 digits from large string where the location ...

Re: Importing multiple Excel files

Re: Importing multiple Excel files

Re: Importing multiple Excel files

Re: Looping using 2 files

Re: data truncation while importing and merging excel sheet

character to date

Re: Fequently used code in a macro

Re: Fequently used code in a macro

Re: Fequently used code in a macro

Fequently used code in a macro

Re: Append two files on a index without duplicates

Re: Append two files on a index without duplicates

Re: Append two files on a index without duplicates

Append two files on a index without duplicates

Re: using Lag in loop

Re: using Lag in loop

using Lag in loop

Re: Importing a date

Re: Importing a date

Importing a date