About apple

apple · ‎02-05-2016

Hi Thank you for the reply. But I don't think you looked at the file. Example Dataset Name Date Amount Spent John 20160521 6 John 20160101 50 John 20150526 X John 20150329 23 John 20150215 X John 20141212 10 Peter 20151203 150 Peter 20150321 X Peter 20141123 20 Albert 20150408 X The output that I want Name Date Amount Spent John 20160521 6 John 20160101 50 John 20150526 X Peter 20151203 150 Peter 20150321 X Albert 20150408 X The code you provided will only extract the observations with X, and after X. Thank you

apple · ‎02-05-2016

Using SAS 7. I am quite new to SAS. Please see attached file. I have a similar dateset. For each unique name I want to extract all the records from the latest Amount Spent=X onwards, inclusive of the observation with the latest Amount Spent=X Eg John 20160521 6 John 20160101 50 John 20150526 X How do I do so? Thank you

apple · ‎12-29-2015

Hi ballardw, Thank you for the reply. But I read https://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#p12zqzvwx4dv6kn1p9crijxswolk.htm that PUTN Function Enables you to specify a numeric format at run time. Hence does it change a numeric variable to a character variable? Thank you

apple · ‎12-28-2015

Hi LinusH, Please be polite. I am trying to ask why I have to put month %let month = %sysfunc(putn(&month,z2.)); If you look at the year variable, we don't have to do that. Thank you

apple · ‎12-28-2015

Hi Using SAS 7.1. A beginner in SAS. For the below solution, why do we need " %let month = %sysfunc(putn(&month,z2.));"? I understand that it is to convert the format to 2 length: 01, 02,...,12. But why can't we do "%do month = 01 %to 12;" Thank you %macro iterate; %do year = 2010 %to 2015; %do month = 1 %to 12; /* assuming you want to zero fill the month */ %let month = %sysfunc(putn(&month,z2.)); %filecr(DE&YEAR.&MONTH.,&YEAR.,&MONTH.); %end; %end; %mend; %iterate

apple · ‎12-22-2015

Hi JoshB, Thank you once again. But if instead I want to list out the specific MONTHs that I want . I modified as below. But it doesn't work. Can you assist again? Thank you %macro iterate; %do year = 2010 %to 2015; %do month = 03, 06, 12; /* I only want for specific months*/ %let month = %sysfunc(putn(&month,z2.)); %filecr(DE&YEAR.&MONTH.,&YEAR.,&MONTH.); %end; %end; %mend; %iterate

apple · ‎12-22-2015

Hi JoshB, Thank you for the reply. However the Do-Loop for the MONTH (I slightly modified the month) doesn't work. Some advice will be appreciated . THank you I get the following errors: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 12 by 06 ERROR: The %TO value of the %DO MONTH loop is invalid. ERROR: The macro LOOP will stop executing. %macro iterate; %do year = 2010 %to 2015; %do month = 6 %to 12 by 6; /* I only want the months for June & Dec*/ %let month = %sysfunc(putn(&month,z2.)); %filecr(DE&YEAR.&MONTH.,&YEAR.,&MONTH.); %end; %end; %mend; %iterate

apple · ‎12-22-2015

Hi Using SAS 7.1. I am still a beginner. I alreasy have a macro that will create the files for the different years and months. %FILECR(DE&YEAR.&MONTH,&YEAR,&MONTH); However it becomes tedious if I have to create many files for the different years and months. Hence I would a simpler way to do it. Eg by a Do-loop, However, the below don't work. Any advice? Thank you Do I=2010 to 2015; %LET MONTH = 06; %LET YEAR = I; %FILECR(DE&YEAR.&MONTH,&YEAR,&MONTH); End;

apple · ‎12-21-2015

Hi Using SAS 7.1, what is the difference between "Else" and "Else Do" Thank you

apple · ‎12-20-2015

Hi Using SAS 7.1. I don't understand how the below loop works. Does the "Leave" indicate the loop will be exited once a missing TYP is found? For Eg if I=14 --> TYP(14)=missing, then IK=15. It won't continue to see if TYP(13), TYP(12), ...TYP(1), has missing values. Thank you DO I = 15 TO 1 BY -1; IF MISSING(TYP{I}) THEN DO; IK = I + 1; LEAVE; END; END;

apple · ‎12-01-2015

Hi, THank you for the reply. I have attached a sample. I could do a transpose paste in excel, but as I have many tables it becomes tedious. Hence would prefer that SAS generate the tables as ROWS. THank you

apple · ‎12-01-2015

Hi Using SAS 7.1. I only have 1 variable, but instead of presenting in column, I want in ROWS. How do I do that? Thanks!

apple · ‎11-22-2015

Hi Iam using SAS 7.1 I am quite new to SAS, so pardon if my question sounds basic. i have a range of character variable. EG: Food_Type '24', '30' , '31', '32', '33', '34' I only want to select the data for Food_Type = '30' - '33' SAS Code 1: data test; set test; where Food_Type in ('30' -'33'); run; SAS Code 2: data test; set test; where Food_Type in ('30') or Food_Type in ('31') or Food_Type in ('32') or Food_Type in ('33') ; run; SAS Code 1 doesn't work but SAS code 2 does. However, it is very tedious to type out all the Food_Type values I want. Is there a faster way I could select '30' - '33'? Thank you

apple · ‎10-25-2015

Hi, I got the below code from someone else. It is supposed to account for leap year. So during a 1) leap year: 183<=A<366 2) non-leap year: 183<= A<365 %LET Year= 183<= A < 365+(4*INT(&Year/4)=&Year) Can someone explain to me what this does -- (4*INT(&Year/4)=&Year)? As far as I know INT truncates a number to its integer. Thank you

apple · ‎10-18-2015

Hi PAtrick, Thanks for the reply. It's format. Eg, I may have under the variable Name: 'Tan Peter' 'Tan John' 'Mike Tan', .... I could have many names containing Tan. I would like to format all Names containing Tan into 'the Tans' without listing out all the Names. How can i do so? Thank you

Online Status	Offline
Date Last Visited	‎10-28-2018 01:15 AM

Proc Format: preserve the order

Select 3 rows for each unique ID

Position of %END;

Write Out same file to different locations

Merge datasets and control output records with IN

Re: ERROR: A character operand was found in the %EVAL function or %IF ...

SAS Macro: Merge only existing datasets

ERROR: A character operand was found in the %EVAL function or %IF cond...

Put Function

Re: SAS Macro %Do %To with 2 variables

Re: Extract all Observations after Latest Amount Spent=X (inclusive)

Extract all Observations after Latest Amount Spent=X (inclusive)

Re: %sysfunc for iterate variable in Do-Loop Macro

Re: %sysfunc for iterate variable in Do-Loop Macro

%sysfunc for iterate variable in Do-Loop Macro

Re: Using a Do-Loop with a Macro

Re: Using a Do-Loop with a Macro

Using a Do-Loop with a Macro

Else-Do vs Else

LOOP & LEAVE;

Re: Proc Tabulate: 1 Variable and Present as Row

Proc Tabulate: 1 Variable and Present as Row

Subset '30'-'33' (character variable)

How do I account for leap year in a formula?

Re: Proc Format & Format Char Variables that starts with certain chara...