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: 
Blandine
‎03-02-2023
  • 31 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Specific filtering of data

by Obsidian | Level 7 in New SAS User
‎11-05-2020 04:18 PM
‎11-05-2020 04:18 PM
Hello I have a data set with bridge name, Condition, inspection and year The condition of the bridge can have different number (4,5,6,7,8) for the same bridge and the bridge name is repeated in my data set, not all the bridges are repeated though. I want to filter bridge that has at least 2 different conditions (I don't want to specify the condition Number neither the bridge name.) How could I proceed?     for example bridge P505 below has 3 condition (that is the type I want to keep) and bridge P416 only have 1 condition (I don't want to keep that). I have about 900 rows thanks   ... View more

Re: Error concatenating multiple data file

by Obsidian | Level 7 in New SAS User
‎10-23-2020 10:54 AM
‎10-23-2020 10:54 AM
STRUCTURE_NUMBER_008 is the name for a specific bridge, for example, my 1992 & 1994 file has this name "10300"  all numeric for the bridge my 1993 has these name format  "00000000000H311" and "000000000010300". these are just example of bridge name. At this point, I am not sure it's the same bridge. I got the data from the federal Highway website and it was a txt file that I imported. I use a macro  because I was importing multiple files at once   %MACRO IMPORT_TXT(FILENAME=ID,OUTFILENAME=ID); proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\Data with inspection year\ID_All years\&FILENAME..txt" dbms=dlm out=&OUTFILENAME (keep = STRUCTURE_NUMBER_008 MAINTENANCE_021 OWNER_022 YEAR_BUILT_027 ADT_029 SERVICE_ON_042A SERVICE_UND_042B STRUCTURE_KIND_043A STRUCTURE_TYPE_043B DECK_STRUCTURE_TYPE_107 DECK_COND_058 SUPERSTRUCTURE_COND_059 SUBSTRUCTURE_COND_060 PERCENT_ADT_TRUCK_109 SCOUR_CRITICAL_113 Inspection_year) replace; delimiter=','; Getnames=Yes; guessingrows=100000; run; %MEND; /* Calling Macro to import First file */ %IMPORT_TXT(FILENAME=ID1992,OUTFILENAME=IDAHO.ID1992); /* Calling Macro to import second and n file */ %IMPORT_TXT(FILENAME=ID1993,OUTFILENAME=IDAHO.ID1993); ... View more

Re: Error concatenating multiple data file

by Obsidian | Level 7 in New SAS User
‎10-23-2020 10:14 AM
‎10-23-2020 10:14 AM
So I guess I can try to convert all into character,concatenate and bring in back to the original name? Is it possible? I don't want to loose Bridge name as I will use it later on. ... View more

Re: Error concatenating multiple data file

by Obsidian | Level 7 in New SAS User
‎10-23-2020 09:38 AM
‎10-23-2020 09:38 AM
Unfortunately, I can't fix that I am working with bridge data from 1992 till 2019 and they change the name of bridges during year so some have numeric and letter in their name others don't.It will be very difficult to change the name as it's at least 1000 bridges per years ... View more

Error concatenating multiple data file

by Obsidian | Level 7 in New SAS User
‎10-16-2020 06:06 PM
‎10-16-2020 06:06 PM
Hello I have tried differents way of concatenating my file ID1992 ID1993.....ID2019 into one filr but I am having issue. I just test out 2 file but it's not working 1st method using append my code. I used force because sas recommended it when I ran without force. Also I have tried restarting SAS but it still doesn't work   proc Append base=IDAHO.Id1992 data=IDAHO.Id1993; force; run;   log error proc Append 38 base=IDAHO.Id1992 data=IDAHO.Id1993; force; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 39 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors.     2nd method using data set /*Combining all the data file into one file*/ data IDAHO.Id1992; set IDAHO.Id1993 IDAHO.Id1994; run;   log error   /*Combining all the data file into one file*/ 41 data IDAHO.Id1992; 42 set IDAHO.Id1993 43 IDAHO.Id1994; ERROR: Variable STRUCTURE_NUMBER_008 has been defined as both character and numeric. 44 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set IDAHO.ID1992 may be incomplete. When this step was stopped there were 0 observations and 16 variables. WARNING: Data set IDAHO.ID1992 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds     thanks for you help ... View more

How to import multiple text file into SAS

by Obsidian | Level 7 in New SAS User
‎10-15-2020 06:37 PM
‎10-15-2020 06:37 PM
Hello, I am trying to import multiple text file in R and have try to follow what was advise in a similar post but it's not working for me, I do not know what I am doing wrong. Below the link 's post  I am referring to   https://communities.sas.com/t5/SAS-Programming/Importing-multiple-delimited-txt-files-and-saving-as-unique-data/td-p/503613   Here is the path of my files   Below my code   /*Importing multiple text files */ %let path=C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\ID_All years; %MACRO IMPORT_TXT(FILENAME=ID,OUTFILENAME=ID); proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; delimiter=''; run; %MEND; /* Calling Macro to import First file */ %IMPORT_TXT(FILENAME=ID00,OUTFILENAME=ID00); /* Calling Macro to import second file */ %IMPORT_TXT(FILENAME=ID01,OUTFILENAME=ID01);     And the log error 168 %let path=C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI 168! Data from Fhwa site\ID_All years; 169 170 %MACRO IMPORT_TXT(FILENAME=ID,OUTFILENAME=ID); 171 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 171! 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; 172 delimiter=''; 173 run; 174 %MEND; 175 176 /* Calling Macro to import First file */ 177 %IMPORT_TXT(FILENAME=ID00,OUTFILENAME=ID00); WARNING: Apparent symbolic reference ID not resolved. ERROR: "IDAHO." is not a valid name. NOTE 137-205: Line generated by the invoked macro "IMPORT_TXT". 1 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 1 ! 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; - 22 1 ! delimiter=''; run; ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. NOTE: Line generated by the invoked macro "IMPORT_TXT". 1 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 1 ! 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; - 200 1 ! delimiter=''; run; ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.01 seconds WARNING: Apparent symbolic reference ID not resolved. ERROR: Invalid data set name IDAHO.. NOTE: The SAS System stopped processing this step because of errors. 178 179 /* Calling Macro to import second file */ 180 %IMPORT_TXT(FILENAME=ID01,OUTFILENAME=ID01); WARNING: Apparent symbolic reference ID not resolved. ERROR: "IDAHO." is not a valid name. NOTE 137-205: Line generated by the invoked macro "IMPORT_TXT". 1 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 1 ! 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; - 22 1 ! delimiter=''; run; ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. NOTE: Line generated by the invoked macro "IMPORT_TXT". 1 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 1 ! 8_Back-casting\NBI Data from Fhwa site\ID_All years\ID..txt" dbms=dlm out=IDAHO.&ID replace; - 200 1 ! delimiter=''; run; ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds WARNING: Apparent symbolic reference ID not resolved. ERROR: Invalid data set name IDAHO.. NOTE: The SAS System stopped processing this step because of errors.       thanks for your help     ... View more

Re: Randomly select a sample from data while specifying a criteria

by Obsidian | Level 7 in New SAS User
‎10-09-2020 06:09 PM
‎10-09-2020 06:09 PM
The code works and I try to replicate exactly what you show me. My only question is why it did put my variable "STRUCTURE_KIND_043A" in the first column? It's not a big deal I just wanted to understand what part of the code does it. "State_code_001" used to be in the first column   code is: /*This program will select randomly data from the PSC in ID while having a set number for PSC cont. and PSC*/ proc sort data=ID19_PSC out=RBI.ID19PSC_sort; by STRUCTURE_KIND_043A; /*sort by structure type 5=PSC and 6=PSC cont.*/ run;       proc format; /* the STRUCTURE_KIND_043A variable only takes values of 5 and 6 and I want to split into two strata later */ value STRUCTURE_KIND_043Astrata other = '5' 6 = '6'; run; /* this code wants to select 367 from the 5 group and 18 from the 6 */ proc surveyselect data=RBI.ID19PSC_sort out=RBI.ID19PSC_BRsample sampsize=(367 18); strata STRUCTURE_KIND_043A; format STRUCTURE_KIND_043A STRUCTURE_KIND_043Astrata.; run; ... View more

Randomly select a sample from data while specifying a criteria

by Obsidian | Level 7 in New SAS User
‎10-09-2020 03:48 PM
‎10-09-2020 03:48 PM
Hello, I have a population sample of 1832 bridges and want to randomly select 385 bridges. Out of those 385 bridges, I want to make sure that it has at least 16 bridges with the criteria "STRUCTURE_KIND_043A=6". "STRUCTURE_KIND_043A" is a column in my data set "ID19_PSC". I used the function SURVEYSELECT, it works fine but I only have 1 bridge with the above criteria and I don't know how to fix it. Any idea?   /*Randomly select 385 bridges from the sample population of PSC in ID*/ PROC SURVEYSELECT DATA=ID19_PSC OUT=RBI.ID19PSC_sample METHOD=SRS /*SRS=Simple random selection*/ SAMPSIZE=385 SEED=1234567; RUN; ... View more

Re: My data go to the default library why?

by Obsidian | Level 7 in New SAS User
‎10-09-2020 03:25 PM
‎10-09-2020 03:25 PM
Thanks a lot ... View more

My data go to the default library why?

by Obsidian | Level 7 in New SAS User
‎10-09-2020 03:06 PM
‎10-09-2020 03:06 PM
Hello, I don't know why the data I imported keep going to the "work" library while I have specified where it should go ( "RBI", library.)  I have to copy and paste it to the desired library. Not sure what I am doing wrong.   here is the code   /*Importing NBI Data for ILLINOIS into SAS*/ libname RBI 'C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\SAS Code\Blandine 1092020'; /*Importing TXT FILE for ILLINOIS in SAS*/ proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\IL 2019\IL19.txt" out=NewIL19 DBMS=dlm; delimiter=","; Getnames=Yes; guessingrows=1000000; run;     ... View more

Re: Error importing xlsx file

by Obsidian | Level 7 in New SAS User
‎10-09-2020 11:26 AM
1 Like
‎10-09-2020 11:26 AM
1 Like
Never mind a simple copy and paste did the work. Thanks a lot ... View more

Re: Error importing xlsx file

by Obsidian | Level 7 in New SAS User
‎10-09-2020 11:23 AM
1 Like
‎10-09-2020 11:23 AM
1 Like
So I just fixed it as you said and I realize my file name extension was "xlsx" and not "xls". I corrected it this is what I get in the log which I supposed my data were imported. However, how do I move it from the "work" library to a permanent library? sorry for my dumb question   33 /*PROGRAM FOR RBI RESEARCH STATE OF IDAHO OCTOBER 10 2020*/ 34 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 34 ! 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xlsx" 35 out=newID19 36 DBMS=xlsx 37 replace; 38 Sheet="sheet1"; 39 Getnames=Yes; 40 run; NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 4493 observations and 123 variables. NOTE: WORK.NEWID19 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 5.40 seconds cpu time 5.36 seconds       ... View more

Re: Error importing xlsx file

by Obsidian | Level 7 in New SAS User
‎10-09-2020 11:01 AM
‎10-09-2020 11:01 AM
It was opened but when I close the excel file I get this log result:   26 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 26 ! 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls" 27 out=newID19 28 DBMS=xls 29 replace; 30 Sheet="sheet1"; 31 Getnames=Yes; 32 run; ERROR: Physical file does not exist, C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.04 seconds cpu time 0.00 seconds   ... View more

Re: Error importing xlsx file

by Obsidian | Level 7 in New SAS User
‎10-09-2020 10:54 AM
‎10-09-2020 10:54 AM
So this is a new one I wrote since I lost what I did last week /*PROGRAM FOR RBI RESEARCH STATE OF IDAHO OCTOBER 10 2020*/ proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls" out=outID19 DBMS=xls Sheet="sheet1"; Getnames=Yes; run; here is the log error NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M6) Licensed to THE CURATORS OF THE UNIV OF MISSOURI - T&R SFA, Site 70084888. NOTE: This session is executing on the X64_10PRO platform. NOTE: Analytical products: SAS/STAT 15.1 SAS/ETS 15.1 SAS/IML 15.1 SAS/QC 15.1 NOTE: Additional host information: X64_10PRO WIN 10.0.19041 Workstation NOTE: SAS initialization used: real time 3.51 seconds cpu time 2.04 seconds NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 1 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 1 ! 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls" 2 out=outID19 3 DBMS=xls 4 Sheet="sheet1"; ----- 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. 5 Getnames=Yes; 6 run; NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 7 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 7 ! 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls" 8 out=outID19 9 DBMS=xls 10 Sheet="sheet1"; ----- 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. 11 Getnames=Yes; 12 run; 13 /*PROGRAM FOR RBI RESEARCH STATE OF IDAHO OCTOBER 10 2020*/ NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. 14 proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 14 ! 8_Back-casting\NBI Data from Fhwa site\ID 2019\ID19.xls" 15 out=outID19 16 DBMS=xls 17 Sheet="sheet1"; ----- 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. 18 Getnames=Yes; 19 run; ... View more

Re: Error importing xlsx file

by Obsidian | Level 7 in New SAS User
‎10-09-2020 10:50 AM
1 Like
‎10-09-2020 10:50 AM
1 Like
Yes the sheet name is ID19 same as the file name.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-02-2023 11:45 AM
Likes from
View All
Quick links