About Ronein

Ronein · ‎12-11-2018

I succeed to created the 5 dates Now I need to crerate a sas parameter that contain these values with + between them How can I do it please? Data a; last_help=input("&last.",yymmn4.); format last_help yymmn4.; /*SAS date of &last. with format YYMM*/ date1 = intnx('month',last_help,3); format date1 yymmn4.; date_char1=put(date1,yymmn4.); date2 = intnx('month',last_help,6); format date2 yymmn4.; date_char2=put(date2,yymmn4.); date3 = intnx('month',last_help,9); format date3 yymmn4.; date_char3=put(date3,yymmn4.); date4 = intnx('month',last_help,12); format date4 yymmn4.; date_char4=put(date4,yymmn4.); date5 = intnx('month',last_help,15); format date5 yymmn4.; date_char5=put(date5,yymmn4.); call symput("date_char1",trim(left(date_char1))); call symput("date_char2",trim(left(date_char2))); call symput("date_char3",trim(left(date_char3))); call symput("date_char4",trim(left(date_char4))); call symput("date_char5",trim(left(date_char5))); Run; %let vector=&date_char1.+date_char2.+date_char3.+date_char4.+date_char5.; %put &vector.;

Ronein · ‎12-11-2018

Hello I want to ask a question please. I have the following situation: User define a month in macro parameter (for example 1706 which means June 2017) %let last=1706; I want to create a new parameter called vector that will take next 5 months (Each month is end of quarter) so in this example vector parameter will get values 1709+1712+1803+1806+1809 (with + between the values) I can write %let vector=1709+1712+1803+1806+1809; But I want to ask how can it be created automatically ? How can I do it please?

Ronein · ‎12-02-2018

Hello Let's say that there are multiple txt files with different dates. For example: A181127.TXT A181128.TXT A181129.TXT A181130.TXT The task is to tell SAS to import one file only that will be the file with last date. How can I do it please? One option is to find the last file by its file name which has date. Other option is to find the last file by the date it was created (Import the file that was created last) Joe

Ronein · ‎11-28-2018

Hello I have a raw data that contain 6 observations for each customer (during follow up period of 6 months). For each customer there are 3 fields: ID, month, Ind Ind is a binary variable that get value 1 if customer in fail status and 0 otherwise. For all customers the value of var "ind" in first month is 0 (customer start is status with no failure) The task is to create a new binary variable that will receive value 1 in first position where customer is in failure Expected values for customer1 are: 1 1801 0 0 1 1802 0 0 1 1803 1 1 1 1804 1 0 1 1805 0 0 1 1806 1 0 Expected values for customer2 are: 2 1801 0 0 2 1802 1 1 2 1803 1 0 2 1804 1 0 2 1805 1 0 2 1806 1 0 Can anyone suggest a code that create the new field? Data raw_tbl; input ID date Ind; cards; 1 1801 0 1 1802 0 1 1803 1 1 1804 1 1 1805 0 1 1806 1 2 1801 0 2 1802 1 2 1803 1 2 1804 1 2 1805 1 2 1806 1 ; run;

Ronein · ‎11-27-2018

Hello For each customer there are multiple rows. I want to add a new field (binary variable that get value 1 or 0) IF the value of X in last row of customer is equal or greater than 1 then newField=1; else newField=0; Expected values in Newfield for customer 1 are: 1 1 1 1 1 Expected values in Newfield for customer 2 are: 0 0 0 0 0 Why the code below is not giving the wanted result? data c1; input ID x; cards; 1 0 1 0 1 1 1 2 1 3 2 0 2 0 2 0 2 0 2 0 ; run; data c2; set c1; IF last.ID and x>=1 then Newfield=1;else Newfield=0; run;

Ronein · ‎11-26-2018

Hello For each person ID I have multiple observations (multiple rows). Target is to find max weight for each customer over his/her observations. Following code is giving bad results. why? Data rawData; Input ID month weight; cards; 1 1801 70 1 1802 90 1 1803 85 2 1801 90 2 1802 94 2 1803 93 3 1802 78 3 1803 80 ; run; Data tbl1(keep=ID max_weight) ; set rawData; by ID; retain max_weight 0 ; max_weight=max(max_weight,weight); IF last.ID then output; Run;

Ronein · ‎11-26-2018

/*Way2*/ Data tbl1; set rawData; by ID; retain InBaseMon; if first.ID and month eq 1801 then InBaseMon=1; if first.ID and month ne 1801 then InBaseMon=0; Run;

Ronein · ‎11-26-2018

I found solution May anyone explain the code? Data tbl1; set rawData; by ID; retain InBaseMon ; if first.ID then do; InBaseMon=0; if month eq 1801 then InBaseMon=1; end; Run;

Ronein · ‎11-26-2018

Hello In following raw data there are 3 fields: ID ,month, weight. I want to check IF customer was exist in base month (1801) and give him value 1 if yes and 0 if no. I want that value 1 or 0 will appear in all rows for the customer. The task is to create a new column "InBaseMon" . IF first raw of customer has month=1801 then InBaseMon=1. IF first raw of customer has month=1801 then InBaseMon=0. Then I want to retain the value of InBaseMon (from first row of customer to other rows of customer) The expected values for new varaible "InBaseMon" for ID=1 are: 1 1 1 The expected values for new varaible "InBaseMon" for ID=2 are: 1 1 1 The expected values for new varaible "InBaseMon" for ID=3 are: 0 0 Data rawData; Input ID month weight; cards; 1 1801 100 1 1802 90 1 1803 85 2 1801 90 2 1802 94 2 1803 93 3 1802 78 3 1803 80 ; run; Data tbl1; set rawData; by ID; IF (first.ID AND month=1801) then InBaseMon=1; Run;

Ronein · ‎11-21-2018

Hello I found solution but still didn't understand why the error appear. ***Conditional converting veraible type***; ***find out if a variable is character or numeric***; *** If it is character then I need to convert it to Numeric; *** If it is Numeric then converting is not needed***; Data tbl1; input snif; cards; 111 222 333 ; run; Data tbl1_new (drop=snif); set tbl1; type=vtype(snif); IF type ne 'N' then snif_num=input(snif,3.); /*If snif is char then we convert it to numeric*/ else snif_num=snif; run; Data tbl2; input snif $; cards; 111 222 333 ; run; Data tbl2_new (drop=snif); set tbl2; type=vtype(snif); IF type ne 'N' then snif_num=input(snif,3.); /*If snif is char then we convert it to numeric*/ else snif_num=snif; run; /*https://communities.sas.com/t5/SAS-Studio/Check-variable-type-then-convert-it-to-character/td-p/427603*/ ***Conditional converting varaible type***; ***find out if a variable is character or numeric***; *** If it is Numeric then I need to convert it to Char; *** If it is Char then converting is not needed***; ***Here we must use fnunction vvalue,which create a character version of OLDVAR***; Data a; input x; cards; 111 222 333 ; run; Data aa; set a; length xx $3 ; xx=compress(vvalue(x)); drop x ; rename xx=x; run; Data b; input x $; cards; 111 222 333 ; run; Data bb; set b; length xx $3 ; xx=compress(vvalue(x)); drop x ; rename xx=x; run;

Ronein · ‎11-21-2018

Hello What is the reason for getting error in the following code. error 484 NOTE 484-185: Format $BEST was not found or could not be loaded. How can I modify the code i order to fix the error? ***Conditional converting variable type***; ***find out if a variable is character or numeric***; *** If it is Numeric then I need to convert it to Char; *** If it is Char then converting is not needed***; Data a; input x; cards; 111 222 333 ; run; Data aa; set a; type=vtype(x); IF type='N' then xx=compress(put(x,best12.)); else xx=compress(x); run; Data b; input x $; cards; 111 222 333 ; run; Data bb; set b; type=vtype(x); IF type='N' then xx=compress(put(x,best12.)); else xx=compress(x); run;

Ronein · ‎11-20-2018

Hello For the following data set I want to add a new column. For first customer ID it will get value 1 For second customer ID it will get value 2 So the new column will get values: 1 1 1 2 2 2 Data tbl1; input ID x; cards; 123456 2 123456 4 123456 6 212321 8 212321 10 212321 12 ; run;

Ronein · ‎11-19-2018

Hello I am using ODS pdf and get a warning message "WARNING: Unsupported device 'ACTIVEX' for PDF destination. Using device 'ACTXIMG'." What does it mean please? What should I do to stop this warning? ODS pdf file= "/path/example1.pdf"; PROC print data=sashelp.class; RUN; ODS pdf CLOSE;

Ronein · ‎11-18-2018

Thank you column1 will get values: '1' for person 1 ,'2' for person 2 ,'3' for person 3 etc. Column2 will get values: '1' for first 3 observations of each person ,'2' for next 3 observations of each person. These is the requirement Joe

Ronein · ‎11-18-2018

Then for each person I need to calculate series of averages. Average of obs 1-3 Average of obs 4-6 etc... So... HelpColumn1 is telling us the ID of the person HelpColumn2 is telling us average series that it belong to for this person

Online Status	Offline
Date Last Visited	Wednesday

Re: create seq number for each ownership structure

Re: create seq number for each ownership structure

create seq number for each ownership structure

Re: Find client number

Find client number

compress and upcase in Merge

send email +attach log file only in case of error or warning

Read Log

calculate seq number within group

check if string contain substring.

Re: calculate seq number within group

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Full Merge

Re: Max per loan in last 7 days

Re: Max per loan in last 7 days

Max per loan in last 7 days

Long to wide

Re: Create a sas parameter with next 5 months of end of quarter

Create a sas parameter with next 5 months of end of quarter

Import file from last date

Create new binary var of first occurrence over multiple rows

Value in last row

maximum over multiple rows per person

Re: spreading values across observations

Re: spreading values across observations

spreading values across observations

Re: Conditional converting variable type from numeric to char

Conditional converting variable type from numeric to char

new column with customer rank

ODS pdf

Re: New columns calculation

Re: New columns calculation

SAS Users Group in Israel