data test; num=1901012434.0000000; num1=put(num,10); run; If you run this code it correctly ends where the period is displayed. 1901012434 However my dataset provides the entire number as a numeric value from the dataset. 1901012434.0000000 is what is shown. 1. I want to show just the first 10 numbers and 2. Convert it to a character value ... View more

data cars(keep=make model origin weight); set sashelp.cars; run; data cars1(keep=make model); set cars; run; data cars2(keep=make model origin); set cars; run; data cars3(keep=make model origin weight); set cars; run; %let colstyle70 = style(column)={just=left cellwidth=70pt}; %let colstyle90 = style(column)={just=left cellwidth=90pt}; %macro Final(final,sheet_nm); ODS TAGSETS.ExcelXP options(sheet_interval='none' absolute_column_width='8' sheet_name=&sheet_nm. center_horizontal="no" Orientation='Landscape' embedded_titles='No' fittopage="No" blackandwhite="No" auto_filter = "Yes" Embedded_Footnotes='Yes' autofit_height="Yes"); %NoAccountLogic(&final.,&ReportName); PROC REPORT DATA=&final. headskip split='*' wrap nowd ; columns make model origin weight ; Define make / &colstyle90 "Make"; Define model / &colstyle90 "Model"; Define origin / &colstyle90 "Origin"; Define weight / &colstyle90 "Weight"; run; %mend final; %Final(cars1,"Cars1"); %Final(cars2,"Cars2"); %Final(cars3,"Cars3"); I have 3 datasets with the same fields.  I want the output to be conditional based on the dataset contents.  Note the changes in fields per cars1,2 and 3.  Is there a way to do this in ods without repeating each ods output and fields separately?  ... View more

I have a csv file within a share drive with an & %LET MTG = \\p1l-nas-02.dlnet.com\mort\SS&A Folder\mortgage When I run the code it says WARNING: Apparent symbolic reference A not resolved I renamed this way %LET MTG = \\p1l-nas-02.dlnet.com\mort\SS(&)A Folder\mortgage I do not get the error when I add (&) however when I run the following code proc import datafile="&MTG.\REPORT.CSV" out=REPORT dbms=EXCELCS replace; /*EXCELCS*/ server="sas-pcff.mortg-prd.com"; port=9922 ; SERVERUSER="&suserid."; SERVERPASS="&mypass."; run; I get the error It does not exist or it is already opened exclusively by another user, or you need permission I am thinking that I am not actually reading in the sharedrive.  I do not know why the user name the sharedrive with an '&' however is there a fix so I can read in the file?? ... View more

data test; my_date = INTNX('MONTH',&tday,-1,'B') ; format my_date nldatm.; run; The above code returns 01Jan1960:06:19:57 and not the current beginning of last month.  In this case I want 01Jun2022:00:00: etc..........  I need this to use it in a dataset because the field in the dataset uses datetime ... View more

You cannot run this code however I have general question data Month_END_01; set Month_End_END_1; as_of_date = put(as_of_date,datetime.); run;   The data is supposed to display a datetime in a field called as_of_date.  Instead it displays a series of characters ***  I tried converting using as_of_date = put(as_of_date,datetime.);  however it simply converts it to a numeric with no data at all.  Is there a solution?  I cannot replicate this so I cannot display a code example ... View more

proc sql; create table test as select loan.data_date as as_of_date from have ;quit; output looks like this as_of_date ************ In other words the date has a date type variable however its truncated and not showing the actual date.  I tried using to_date(loan.data_date as as_of_date) however I ger t function not present when using this.  How can I get the actual date to avoid truncation?   ... View more

data have; item1 = 'central'; item2 = ''; item3 = 'Pacific'; run; I want to apply a formula that gives me the total number observations by row and displays a field called row_cnt.  So in this case the total would be 2 since there are two observations.  The variables however are character in nature ... View more

data _null_; file "&myopicshare/Loan Rpt1 SCRA2_&mToday..txt" lrecl=119 TERMSTR=crlf; set file22 ; PORT = 3621; SERVERUSER="&euserid."; SERVERPASS="&upass."; label; put @1 ssn $9. @10 dob $8. @18 last_name $26. @44 first_name $20. @64 loan_id $28. @92 duty_date $8. @100 Middle_Name $20. ; run; ERROR: Physical file does not exist, /sasgrid/hall1/sascompute/config94/Lev1/SASApp/ Can someone explain why I am getting a file not found error during export?  I have the correct file path yet the error exists. ... View more

%let rptout = \\remote1; data cars(keep=make drivetrain length); set sashelp.cars; run; data _null_; file "&rptout\test..txt" lrecl=119 TERMSTR=crlf; set cars; put @1 make $9. @10 drivetrain $15. @16 length $5 ; run; When I run the code I am getting an insufficient authorization message.  Yet when I run the code using the following code it runs without issue.  PROC EXPORT OUTFILE = "&rptout\cars..xlsb" DATA= cars DBMS= EXCELCS REPLACE; SHEET='sheet1'; SERVER="sas-pcff.share1-prd.com"; PORT = 9999; SERVERUSER="&suserid."; SERVERPASS="&mypass."; run; The issue is I need this with a txt extension and with columns in tab set up like the first dataset   ... View more

use D_LM go #NAME? declare @medate as datetime select @medate = '09/30/2020' CREATE TABLE #TEMP (ALS_NUM varchar(20), LMID bigint, MOD int, LEV int, RELATED bigint, pri_ssn varchar(9), LOANLINE varchar(4)) DECLARE @i tinyint SELECT @i = 2 #NAME? INSERT #TEMP SELECT ORG_ALS_NUM, LMDB_ID, RECOMMEND, 1, NULL, pri_ssn,LOANLINE FROM d_lm.ALLBooked WHERE MONTH(DATE_BOOKED) = MONTH(@MEDate) AND YEAR(DATE_BOOKED) = YEAR(@MEDate) --Now search these and see if any of these are new acct nubers for a prior 'booked' loan --loop 5 times to find any more iterations of the same loan WHILE @i < 10 BEGIN INSERT #TEMP SELECT v.ORG_ALS_NUM, v.LMDB_ID, v.RECOMMEND, @i, t.LMID , v.pri_ssn, v.LOANLINE FROM d_lm_ALLBooked v JOIN #TEMP t ON (t.ALS_NUM = v.NEW_ALS_NUM or t.als_num = v.org_als_num) AND v.LMDB_ID NOT IN (SELECT LMID FROM #TEMP) SELECT @i = @i + 1 END You cannot run this code however her is my question.  The code came to me in T-SQL format.  I am trying to run each section and produce a dataset so I can get a visual on how to connect the datasets.  Can this be dumped into a third party app like toad or SSRS.  What have some of you utilized in cases like this? ... View more