About don21

don21 · ‎02-28-2018

Hi Have modified my previous query: data test1(drop = PastDueSince); set Past_Due_Actual_Days2; format _PastDueSince date9.; _PastDueSince = input(trim(PastDueSince),date9.); PastDueSince = PastDueSince; rename _PastDueSince=PastDueSince; run; Works like charm!!!

don21 · ‎02-27-2018

don21 · ‎02-27-2018

data Magellan3; set Magellan2; PastDueSince=input(PastDueSince,mmddyy16.); run; DATA Past_Due_Actual_Days2; /*format PastDueSince date9.;*/ SET Past_Due_Actual_Days; /*PastDueSince = f20;*/ PastDueSince =inputput(F20,f8.0),yymmdd.); /*PastDueSince = PastDueSince - 21916;*/ RUN;

don21 · ‎02-27-2018

Tabl 1 Date (char) 17-Jun-2016 Table 2 Date (Date) 6-Sep-17 I need to merge table 1 and 2 but when I try to conver char to date or date to char the variable is not piking any values.

don21 · ‎02-27-2018

HI, I have 4 data sets containing date variables: Table1 date is in date format (21-Mar-2017) table 2 date is in character (21 Mar 2017) table3 date is in character (21 mar 2017) table4 date is in date format (21-mar-2017) am trying to change the char to date format but it displays nil values. Please help. I need to merge the 4 tables.

don21 · ‎02-14-2018

Hi Tom, Thankyou for the inputs but, still the query fails due to the file names . Error: 11 + proc import datafile= " ." out= RM Deliquent Repayment Exception (label= " ." ); run; _________ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. ERROR 76-322: Syntax error, statement will be ignored.

don21 · ‎02-14-2018

this is part of the original question and is stilll not an answer, I requested for a solution to one of the above points..

don21 · ‎02-14-2018

proc import datafile="C:\Reports\EPD\Countries\Botswana\Input\Finance_Overdue*.xlsx" out=Botswana4 dbms=xlsx replace; run; -----> Works WELL!! proc import datafile="C:\Reports\EPD\Countries\Botswana\Input\excesstrn*.xls" out=Botswana5 dbms=XLS replace; run; ---> Does not work and says - "Too many XF records for Excel ->...." but my files are fine please suggest any other ways to import ".xls files like above using name*.xls

don21 · ‎02-14-2018

actually, we r not thinking of doing this manually as we have 20 folder containing atleast 10 files each like this.. soo..

don21 · ‎02-14-2018

data _null_; set FILENAMES; call execute('proc import datafile="C:\Reports\EPD\Countries\Botswana\Input\'||strip(memname)||'.xls" out='||strip(memname)||'; run;'); run; the problem is , files names are a complete crap, they have spaces, underscores, '-' s braces etc., I am getting error stating invalid filename.. Also, the data does not start from row1 they start from 5 or 6 in some file and there are also empty columns in some excel files which needs to be deleted.. Please advise

don21 · ‎02-14-2018

I have actually written a macro to pick all the file names in the path and it creates a data set with all the file names. No the challenge is to write another macro which opens that data set , reads each file name and imports it. This needs to be done like a loop as I have nearly 200 file names.. Any advuse?

don21 · ‎02-14-2018

Hi Reeza, am afraid that making a table structre for all the inputs and for multiple countries is not a flexible idea as it jus makes the code complex. And yes, I am actually looking for a macro code that picks up the file names. 🙂

don21 · ‎02-13-2018

there is a point 4 4. the data row starts from 4th observation and we are unable to give "namerow" or datarow as these are .xls and .xlsx files. We can not specify range because the end row is not fixed, sometimes there will be 100 rows and sometimes it could be 200 rows.

don21 · ‎02-13-2018

Dear all, I have 3 issues that are bugging me on my current project: We have developed coding for some 20 countries based on the input files they share via common sharepoint. We take those inputs and import them in our coding and do the rest of the process. Problems: 1. The file names of the input files are changing every day. 2. there are empty "COLUMNS" in the input files which we are deleting manually 3. for few variables, the data type is Char one day and is num the other day, however teh data doesnot change. but this is creating a problem in the merge statements later in the code. Please advise.. Thank you!

don21 · ‎02-13-2018

I have ungrouped my sas dataset and used it again for median under ODS proc reports, and it is working now. 🙂

Online Status	Offline
Date Last Visited	‎05-14-2020 01:11 PM

SAS VA

Re: Interactions

Interactions

How to group multiple measure in to one for search view

how to get the list of file names with formats (.PDF or .DOC or .MSG) ...

Re: Issue in picking max amount form same date

Issue in picking max amount form same date

sas Enterprise Guide 7.1 (64 Bit)

Re: LOCAL server could not be connected

LOCAL server could not be connected

Re: file formats

Re: Importing multiple pwd protected xlfiles from a URL at the same ti...

Re: Importing multiple pwd protected xlfiles from a URL at the same ti...

Re: Mapping - Conditions in SAS

Re: Importing multiple pwd protected xlfiles from a URL at the same ti...

Re: Interactions

Re: sas server management

sas server management

Re: count of variable with condition

Re: Base sas

Re: Base sas

Re: Base sas

Re: Base sas

Base sas

Re: base sas

Re: base sas

Re: base sas

Re: base sas

Re: base sas

Re: base sas

Re: base sas

Re: base sas

base sas

Re: Media in sas 9.3

SAS Global Forum 2016