cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SAS_usercanada
‎07-06-2024
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Use infile to load large CSV file, but 0 records read from file

by Calcite | Level 5 in SAS Programming
‎07-05-2024 03:40 PM
‎07-05-2024 03:40 PM
It is my typo here. ... View more

Use infile to load large CSV file, but 0 records read from file

by Calcite | Level 5 in SAS Programming
‎07-05-2024 02:54 PM
‎07-05-2024 02:54 PM
%macro infile; %Do Yr .= &strYr %To EndYr;   Filename caseA "&sourcefile.\caseA_&Yr..CSV"; Data temp. caseA_&Yr.;          length                     Filr_number $ 15                    Rtn_cd           $4 ... ;       infile casA Firstobs = 2 DSD Termstr = CRLF DLM =',' LRECL=32767 Missover;           input                    Filr_number $                  Rtn_cd              $ ...;           informat                   Filr_number $CHAR15.                  Rtn_cd           $CHAR1. ...;           format                                Filr_number $CHAR15.                  Rtn_cd           $CHAR1. ...;  run; %END;   %Mend; %infile;   NOTE: The infile CaseA is: Filename=E:\Master file\CaseA_2020.CSV, RECFM=V,LRECL=32767, File Size (bytes)=8571503098, Last Modified=May 29, 2024 14:16:42, Create Time=May 29, 2024 14:16:42 NOTE: 0 records were read from the infile CaseA. NOTE: The data set temp.CaseA_2020 has 0 observations and 120 variables.       ... View more

Re: How to convert a hierarchy file into a flat file in SAS?

by Calcite | Level 5 in New SAS User
‎04-23-2019 12:18 PM
‎04-23-2019 12:18 PM
We are unable to install SAS XML mapper. So I have to use programing to change the data format. ... View more

Re: How to convert a hierarchy file into a flat file in SAS?

by Calcite | Level 5 in New SAS User
‎04-23-2019 11:33 AM
‎04-23-2019 11:33 AM
The source file is XML. When I open it in Excel, the data format is  not easy to read.   IDNumber lastName firstName dateOfBirth gender maritalStatus numberOfDependantChildren taskidID taskTitle taskCode taskStartDate taskEndDate AAAA708             Anderson             Ross             1944-04-30             1             1             99             262234 JobSearch1 111 2019-01-28 2019-01-28        262231 JobSearch1 111 2019-01-31 2019-01-31 BBBB708             Moulton             Ronda             1947-03-04             2             1             99             249335 JobSearch2 102 2018-08-02 2018-08-31        249241 JobSearch2 102 2018-09-02 2018-09-22        249395 JobSearch3 135 2018-08-02 2018-08-31   ... View more

Re: How to convert a hierarchy file into a flat file in SAS?

by Calcite | Level 5 in New SAS User
‎04-23-2019 11:28 AM
‎04-23-2019 11:28 AM
the data should show as a flat file. if there is a new taskid, a new record for the same IDNumber should be created.   IDNumber lastName firstName dateOfBirth gender maritalStatus numberOfDependantChildren taskidID taskTitle taskCode taskStartDate taskEndDate AAAA708  Anderson Ross   1944-04-30 1 1  99    262234   JobSearch1 111 2019-01-28 2019-01-28 AAAA708  Anderson Ross   1944-04-30 1 1  99    262231  JobSearch1 111 2019-01-31 2019-01-31 BBBB708  Moulton Ronda   1947-03-04 2 1  99    249335  JobSearch2 102 2018-08-02 2018-08-31 BBBB708  Moulton Ronda   1947-03-04 2 1  99    249241  JobSearch2 102 2018-09-02 2018-09-22 BBBB708  Moulton Ronda   1947-03-04 2 1  99    249395  JobSearch3 135 2018-08-02 2018-08-31 ... View more

Re: How to convert a hierarchy file into a flat file in SAS?

by Calcite | Level 5 in New SAS User
‎04-23-2019 09:42 AM
‎04-23-2019 09:42 AM
if several new variables are added to the dataset, I need to keep all these records. ... View more

Re: How to convert a hierarchy file into a flat file in SAS?

by Calcite | Level 5 in New SAS User
‎04-18-2019 04:08 PM
‎04-18-2019 04:08 PM
if one more variable is added at the end of  the old dataset, this new variable can have several lines with different value for the same IDNumber, how to keep those records for the same IDNumber.   Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-06-2024 12:37 AM
Quick links