About Q1983

Q1983 · ‎05-13-2015

%macro trial(investor,type); ODS TAGSETs.ExcelXP options(sheet_interval='Table' sheet_name="&investor &type" center_horizontal="yes" fittopage="No" blackandwhite="Yes" Embedded_Footnotes='Yes' Embedded_Titles='Yes' autofit_height='Yes' orientation='landscape' absolute_column_width='7' Frozen_Headers='3'); proc report data=trial4 wrap style(column)={JUST=CENTER}; where investor = "&investor" and type = "&type"; columns LN_NO investor LM_TEMPLATE_NM s323_dt; title justify=left "Report as of &rpt_dt"; FOOTNOTE1 justify=Left Height=8pt "&FNote1"; FOOTNOTE2 justify=Left Height=8pt "&FNote2"; RUN; %mend; %trial(FHA,IN TRIAL); %trial(FHA,TRIAL ON STREET); %trial(FHLMC,IN TRIAL); %trial(FHLMC,TRIAL ON STREET); %trial(FNMA,IN TRIAL); %trial(FNMA,TRIAL ON STREET); %trial(PRIVATE / REG AB,IN TRIAL); %trial(PRIVATE / REG AB,TRIAL ON STREET); For this report output the investor represents the example (ie FHA,FHLMC) and the Type is represented by examples (IN TRIAL or TRIAL ON STREET). Since this passes a macro and puts each in a separate tab based on the investor I want to show the s323_dt only if the Investor = ‘FHA’, not the others. I know I could create t separate dataset just for FHA however I want to handle this within the macro

Q1983 · ‎05-08-2015

/*this dataset is to have the following ck letters, CK385,CK386,CK218,CK204 I then will merge this dataset with another as seen below and combine with a comment_code dataset */ data Letter_Codes_l; set letter_codes; run; data ID_After_Activation_CFPB; merge ID_After_Activation_CFPB (in = a) Letter_Codes_l (keep = ln_no CK385 CK386 CK218 CK204 /* The issue is if one of the variables is missing or null, it will generate the error example ERROR: The variable CK218 in the DROP, KEEP, or RENAME list has never been referenced. In This case the CK218 was not present in the letter_codes_l. Is there a way I can still show all Variable regardless. These are to be used in totals later in the code*/ in = b) Comment_Codes_1st (keep = ln_no IP386 CP385 SL385 RS385 TR218 MED218 AD204 in = c) ; by ln_no; if a; run;

Q1983 · ‎04-12-2015

To your knowlege is there a limit on how many veriables you can list in your varlist? I am getting unbalanced quote warning however there are no commas nor unbalanced quotes here SYMBOLGEN: Macro variable VARLIST resolves to sponsor_loan_number Referral_Date Servicer_Name Agency_Name Backlog_Mod_Flag Trial_Mod_Type Trial_Start_Date Mod_Conversion_Date Servicer_Loan_Number ACH_Flag Trial_Mod_Payment_Amount NEXT_Due_Date Last_Payment_Applied_Date UPB Reason_for_Default English_Spanish_Ind Borrower_First_Name Borrower_last_Name Co_Borrower_First_Name Co_Borrower_Last_Name Property_Address_1 Property_Address_2 Property_City Property_State Property_Zip Mailing_Address_1 Mailing_Address_2 Mailing_City Mailing_State Mailing_ZIP Borrower_Phone_Home Borrower_Phone_office1 Borrower_Phone_office2 Borrower_Phone_Other Borrower_Phone_Cell1 Borrower_Phone_Cell2 Borrower_Email_Address CO_Borrower_Phone_Home CO_Borrower_Phone_office1 CO_Borrower_Phone_office2 COBorrower_Phone_Other COBorrower_Phone_Cell1 COBorrower_Phone_Cell2 Co_Borrower_Email_Address WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.

Q1983 · ‎04-09-2015

Proc sql; Create table test as Select ln, region Case when ln ne ‘’ then count(ln) else 0 end as cnt Quit; Sample output Ln region cnt 11 west 4 12 east 4 13 north 4 15 south 4 data _null_; File "/server/file_&cnt..txt" (file__4..txt would be the exported output) lrecl=30000 dsd dlm='|' termstr=crlf ; run; However I do not want to display the header cnt. I want output like this 11|west| 12|east| The reason I chose to address the cnt in the proc statement is because I am not sure if there is a way to do a macro to count the Number of recrods and then use it in the proc export statement

Q1983 · ‎04-07-2015

data test; set sashelp.demographics; run; %let varlist= CONT ID ISO NAME ISONAME region pop popAGR popUrban totalFR AdolescentFPpct ; data _null_; set test ; file "/D5/dors09/dors/sascode/reporting/dev/output/test_&pbd_date..txt" lrecl=30000 dsd dlm='|' termstr=crlf ; if _n_=1 then put "%sysfunc(tranwrd(&varlist,%str( ),|))" ; put &varlist; run; Thanks for your help. i plugged in your example for another sashelp table and it works. Now how can I get the same results with just the data and not the headers too. From this CONT|ID|ISO|NAME|ISONAME|region|pop|popAGR|popUrban|totalFR|AdolescentFPpct 91|180|044|BAHAMAS|BAHAMAS|AMR|323,063|1.34%|90.00%|2.3| 91|227|084|BELIZE|BELIZE|AMR|269,736|2.14%|48.60%|3.1|12.50% To this 91|180|044|BAHAMAS|BAHAMAS|AMR|323,063|1.34%|90.00%|2.3| 91|227|084|BELIZE|BELIZE|AMR|269,736|2.14%|48.60%|3.1|12.50%

Q1983 · ‎03-26-2015

Variables MonthYr is a date variable lbl is a char cnt is a numeric data test; MonthYt=step_compl_dt; if step_cd='111' then do; lbl='Modification';cnt=1;end;else if step_cd='222' then do; lbl='Liquidation';cnt=1;end; format MonthYr monyy7.; drop ln_no; run; Sample Output MonthYr lbl cnt Feb2014 Modification 1 Feb2014 Modifcation 1 Mar2014 Liquidation 1 Mar2014 Modifcation 1 Apr2014 Modification 1 May2014 Liquidation 1 May2014 Modification 1 Jun2014 Modifcation 1 The repeating months are based on the ln_no which has been dropped When I attempt to do an agregate total proc sql; create table tes2 as select MonthYr,lbl,sum(cnt) as cnt1 from test1 group by MonthYr,lbl having sum(cnt); quit; Do you see anything wron with this proc statement. I am getting repeats of the MonthYr and some totals I should be getting something like MonthYr Modification Liquidation Feb2014 2 Mar2014 1 1

Q1983 · ‎03-09-2015

Data my_file Set my_file2; File "/dors09/dors/sascode/reporting/test_post_mod/out/file..txt" LINESIZE=8000 dsd dlm='|';/*missover*/ guessingrows=32767; /*for truncation*/ PUT &Final_VARS ; run; x "unix2dos /dors09/dors/sascode/reporting/test_post_mod/out/file..txt" ; It is supposed to produce a test file without headers separated by a | example here 1744|filename|01/15/2015|Active|||804-111-2255|aqqq@gmail.com|modified 1114|filename|01/15/2015|Active|Western|CQQ1|804-111-2255|aqqq@gmail.com|modified The actual headers are ID|filename|date|Status|Region|ID_Region|Phone|email|loan_status In some cases there may be a blank for the header. In that case then just the | is to show, The problem is, the program code reads the next ID on the same line and does not move to the next line. Here is that same example that produces the problem 1744|filename|01/15/2015|Active|||804-111-2255|aqqq@gmail.com|modified1114|filename |01/15/2015|Active|Western|CQQ1|804-111-2255|aqqq@gmail.com|modified I thought this code here would resolve the issue however it does not. Any ideas

Q1983 · ‎02-26-2015

I am retrieving a directory listing used in ftp upload %let HHF_host=********; /* Machine to connect with ftp */ %let HHF_userid=******; /* ID to use with ftp command */ %let HHF_ftppwd=********; /* Password for the ftp userid */ %let workpath = %sysfunc(pathname(work)); filename dir ftp '' ls cd="/inbound" user=&HHF_userid pass="&HHF_ftppwd" host="&HHF_host" prompt; data folders; infile dir missover truncover; input name $; call symput('F'||trim(left(_N_)),compress(name)); run; I get the following warning WARNING: Apparent symbolic reference DIR not resolved.

Q1983 · ‎02-23-2015

Can you tell me why I am getting error messages saying I cannot post more than once every 60 seconds. I cannot locate anyone in troubleshooting

Q1983 · ‎12-05-2014

I think I figured it out, just use idlabel

Q1983 · ‎12-05-2014

Your solution worked lik a charm. Here is a sample code and output proc transpose data=borrower out=borrower2 (drop = _NAME_ _LABEL_) ; id ln_no by id_no; var ln_no; run; sample output id_no 11111 11112 00000 11111 11112 Is there a way to assign label to the value as a header. What happens is I get the actual data as both a header and in the detail

Q1983 · ‎12-05-2014

Newbie to sas with a question data borrower (keep=ln_no id_no); set table1; run; sample data ln_no id_no 1111 00000 1112 00000 1113 00002 1114 00006 1115 99999 1116 99999 I want to be able to show the data like this id_no first_ln_no second_ln_no 00000 11111 11112 00002 11113 00006 11114 99999 11115 11116 There can be up to 5 scenarios where one id_no could have several ln_no. Would I need some type of do until statement

Q1983 · ‎12-02-2014

data test (keep=ln_no BO_BORR_FST_NM BO_BORR_LAST_NM BO_BORR_MDL_NM BO_BORR_NM YE_BORR_ID_NO); set data1; if ye_borr_id_no in ('9897' '4231' '6240' '3708' '9517');run; Is there an alternative process to include all of the numbers in quotes without having to physically place quotes between all values. For example '9897'. I have about 900 of these to place after the ye_borr_id_no. I know I can do a table using cards like this data test; input id_no $4.; cards: 9897 etc........; run; I just need to perhaps incorporate this into the datastep.

Q1983 · ‎11-04-2014

options missing='' ; worked well. Thanks

Q1983 · ‎11-03-2014

Date 1st HAMP Trial Payment Rece . Here is an example of output when I import a .csv file into sas and then output it. If the value is a numeric or a date and the date is a null it assigns a period or dot.(hard to see here) I want the field to be blank and not show a dot when importing. The file type as an example here is Date/MMDDYY 10 so if there is a date it will something like this 10/15/2014. I am using the Import Data utility here.

Online Status	Offline
Date Last Visited	‎05-08-2023 02:16 PM

Date will not change to Character

Date reading as 1960 after conversion

YYYMMDD where the field reads as a date

Change decimal number to a character

Suppress fields based on dataset in ods output

Proc report conditional fields

Re: Import CSV issue

Import CSV issue

Datetime format question

Date not displaying from database properly

Re: Date will not change to Character

Re: Date reading as 1960 after conversion

Re: YYYMMDD where the field reads as a date

Re: Suppress fields based on dataset in ods output

Re: Headers on first two rows of csv for export

output based on variable in dataset

Defined variable for file extension

Re: Headers on first two rows of csv for export

Conditional display of variables in macro based output ODS

Missing variables cause datastep errors

Re: Carraige return not working during proc export

Displaying count in a proc export statement

Re: Carraige return not working during proc export

Having Clause Aggregate totals

Carraige return not working during proc export

ftp code produces warning

Re: Program Code - Multiple Value Prompt

Re: Possible do while or do until

Re: Possible do while or do until

Possible do while or do until

Process to handle multiple quotes

Re: Importing csv causes a dot if null value

Importing csv causes a dot if null value