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: 
_maldini_
‎06-04-2024
  • 401 Posts
  • 404 Likes Given
  • 1 Solutions
  • 16 Likes Received

Variable has been defined as both character and numeric.

by Barite | Level 11 in SAS Programming
‎03-10-2016 11:30 PM
‎03-10-2016 11:30 PM
I have 5 datasets in Excel files (5 different time points w/ the same variables, for the most part). Because of Excel’s formats, I have painstakingly converted variables in both directions - character to numeric and numeric to character - using arrays in numerous SAS programs throughout this project. It has been a huge effort.   In the final phase I am trying to stack the datasets using the code below. I received 83 errors stating that “Variable XXX has been defined as both character and numeric.”   I’m assuming that this means that in different datasets the variable has different data types. For example, VAR1 is character in one dataset and numeric in another. Most of the solutions in this forum describe converting the variables that are causing the errors. Do I need to check each dataset to see the data type of each variable and then convert them all to the desired type? Should I do this in each dataset or is there a way I can do this globally?   Thanks for the help.   DATA a1_a5_final; SET a1_final a2_final a3_final a4_final a5_final; RUN; ... View more

NOTE: Invalid argument to function INPUT

by Barite | Level 11 in SAS Programming
‎03-10-2016 03:39 PM
1 Like
‎03-10-2016 03:39 PM
1 Like
I'm using an array to convert character variables to numeric. The code executes w/o errors or warnings, but the notes state " NOTE: Invalid argument to function INPUT at line 80 column 16."   What's wrong w/ this syntax? Thanks for your help.   79 DO i=1 to dim(_char); 80 _num(i) = input(_char(i),6.); 81 END;   DATA conversion_subset; SET dropping_strings; Array _char(*) $ _100400 _100500 _100600 _200100 _200200 _200300 _200400 _200401 _400402 _400403 _400601 _400602 _500800 _500900 _501000; Array _num(*) var1-var15; DO i=1 to dim(_char); _num(i) = input(_char(i),6.); END; DROP _100400 _100500 _100600 _200100 _200200 _200300 _200400 _200401 _400402 _400403 _400601 _400602 _500800 _500900 _501000 i; RENAME VAR1 = _100400 VAR2 = _100500 VAR3 = _100600 VAR4 = _200100 VAR5 = _200200 VAR6 = _200300 VAR7 = _200400 VAR8 = _200401 VAR9 = _400402 VAR10 = _400403 VAR11 = _400601 VAR12 = _400602 VAR13 = _500800 VAR14 = _500900 VAR15 = _501000; RUN;   ... View more

Re: Make first letter capital only

by Barite | Level 11 in SAS Procedures
‎03-10-2016 03:28 PM
‎03-10-2016 03:28 PM
@Vince28_Statcan I'm just trying to capitalize the first letter of the first word in a string. I'm using your suggested code. It works, but I'm getting the following warning. Any suggestions? Thanks!   316 QWB4a_NOSCORE=upcase(substr(QWB4a_NOSCORE,1,1))||lowcase(substr(QWB4a_NOSCORE,2,0)); 317 QWB4b_NOSCORE=upcase(substr(QWB4b_NOSCORE,1,1))||lowcase(substr(QWB4b_NOSCORE,2,0)); 318 319 DROP 320 QWB7D_1QWB7D_2QWB7D_3; 321 RUN; NOTE: Invalid third argument to function SUBSTR at line 316 column 59. NOTE: Invalid third argument to function SUBSTR at line 317 column 59. ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-10-2016 02:33 PM
‎03-10-2016 02:33 PM
It's not empy. The data is there:  _300101,_300102,_300201,_300202, 8:00 PM,10:00 PM,4:00 AM,9:00 AM 1:00 AM,2:00 AM,10:00 AM,12:00 PM 12:00AM,11:30AM,8:00AM,6:30AM 12:00 AM,2:00 AM,6:00 AM,11:00 AM 7:00AM,9:00AM,11:00PM,11:00PM 12:00 AM,12:00 AM,6:30 AM,8:00 AM ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-10-2016 01:59 PM
‎03-10-2016 01:59 PM
Similar error...   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc import 57 datafile= "/folders/myfolders/xxxx/xxxx/! Datasets/Original Datasets/xxxxx Complete A4 Data COPY.csv" 58 dbms=csv 59 out=test_import REPLACE; 60 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. Unable to sample external file, no data in first 5 records. ERROR: Import unsuccessful. See SAS Log for details. ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-10-2016 01:41 PM
‎03-10-2016 01:41 PM
data test_data; infile "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv" dlm=","; input _300101 _300102 _300201 _300202; run; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 data test_data; 57 infile "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv" dlm=","; 58 input _300101 _300102 _300201 _300202; 59 run; NOTE: The infile "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv" is: Filename=/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=10Mar2016:09:52:08, File Size (bytes)=226 NOTE: Invalid data for _300101 in line 1 1-7. NOTE: Invalid data for _300102 in line 1 9-15. NOTE: Invalid data for _300201 in line 1 17-23. NOTE: Invalid data for _300202 in line 1 25-39. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 CHAR _300101,_300102,_300201,_300202.8:00 PM,10:00 PM,4:00 AM,9:00 AM.1:00 AM,2:00 AM,10:00 AM,12:00 PM.1 ZONE 5333333253333332533333325333333033332542333332542333324423333244033332442333324423333324423333325403 NUMR F300101CF300102CF300201CF300202D8A0000DC10A0000DC4A0001DC9A0001DD1A0001DC2A0001DC10A0001DC12A0000DD1 101 2:00AM,11:30AM,8:00AM,6:30AM.12:00 AM,2:00 AM,6:00 AM,11:00 AM.7:00AM,9:00AM,11:00PM,11:00PM.12:00 A ZONE 3333442333334423333442333344033333244233332442333324423333324403333442333344233333542333335403333324 NUMR 2A001DC11A301DC8A001DC6A301DD12A0001DC2A0001DC6A0001DC11A0001DD7A001DC9A001DC11A000DC11A000DD12A0001 201 M,12:00 AM,6:30 AM,8:00 AM 226 _300101=. _300102=. _300201=. _300202=. _ERROR_=1 _N_=1 NOTE: 1 record was read from the infile "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv". The minimum record length was 226. The maximum record length was 226. NOTE: The data set WORK.TEST_DATA has 1 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds proc import datafile= "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv" out=test_import REPLACE; run; *Time program.sas Importing Datasets.sas CODE LOG RESULTS Errors, Warnings, Notes Errors (1) Warnings Notes (2) 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc import 57 datafile= "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/XXXX Complete A4 Data COPY.csv" 58 out=test_import; 59 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. Unable to sample external file, no data in first 5 records. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 60 61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 73 _300101,_300102,_300201,_300202 8:00 PM,10:00 PM,4:00 AM,9:00 AM 1:00 AM,2:00 AM,10:00 AM,12:00 PM 12:00AM,11:30AM,8:00AM,6:30AM 12:00 AM,2:00 AM,6:00 AM,11:00 AM 7:00AM,9:00AM,11:00PM,11:00PM 12:00 AM,12:00 AM,6:30 AM,8:00 AM ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-10-2016 01:27 PM
‎03-10-2016 01:27 PM
@Reeza I just uploaded the data.    I thought I WAS specifying an INFORMAT!    When I run the PROC IMPORT, I receive the following error message:   "NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. Unable to sample external file, no data in first 5 records. ERROR: Import unsuccessful. See SAS Log for details."   proc import datafile= "/folders/myfolders...csv" out=test; run; ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-10-2016 01:07 PM
‎03-10-2016 01:07 PM
@Reeza Could offer some feedback here?    I have saved the Excel file as a CSV. I am attempting to use the following code:  data test; infile "/folders/myfolders/..." dlm=","; input _300101 TIMEw. _300102 TIMEw. _300201 TIMEw. _300202 TIMEw.; run; proc print data=test; run; I am getting an "Invalid data" error for each variable (See attached screen shot).   Thanks!   ... View more

Re: Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-09-2016 12:38 PM
‎03-09-2016 12:38 PM
@Reeza Thanks. How might I process the data manually in this situation? ... View more

Using informats for time data

by Barite | Level 11 in SAS Programming
‎03-09-2016 12:09 PM
‎03-09-2016 12:09 PM
Can I assign informats to specific varialbes using PROC IMPORT and an Excel file, or in a DATA step (The resources I have seen for assigning informats all seem to reference using an INPUT statement for raw data).   How can I use SAS Help to find a list of informats?   I have 4 character variables w/ time values (e.g. 11:00 PM, 1:00PM). When I read them into SAS (Using PROC IMPORT from an Excel file) they are assigned different formats and informats. The first 2 variables are assigned an informat of $21. The next 2 are assigned an informat of $11 (See attachment).   In a PROC PRINT (See attachment), the values that have a space between the numbers and the AM/PM appear as long strings with a single digit followed by multiple digits following the decimal point.   For example, 10:00 AM (Space) appears as 0.916666667, while 10:00AM (No space) appears as 10:00AM.   How should I assign informats for these variables so that the values appear consistent. Thanks for you help! ... View more

Re: The SUBSTR function call has too many arguments

by Barite | Level 11 in SAS Programming
‎03-07-2016 07:39 PM
‎03-07-2016 07:39 PM
I used a LENGTH statement after the DATA statement and the WARNING was eliminated. I am seriously grateful for all your help in this forum!  @Astounding @Reeza ... View more

Re: The SUBSTR function call has too many arguments

by Barite | Level 11 in SAS Programming
‎03-07-2016 06:58 PM
‎03-07-2016 06:58 PM
Actually, I didn't exclude those 4 variables b/c of their length, but the lengths of the variables in the array are different looking at the PROC CONTENTS. Do the lengths all have to be the same? The informat lengths? Neither? Should I set the length with a LENGTH statement further up the DATA step? ... View more

Re: The SUBSTR function call has too many arguments

by Barite | Level 11 in SAS Programming
‎03-07-2016 06:24 PM
‎03-07-2016 06:24 PM
@Astounding @Reeza  Multiple errors. See attached screen shot. Thanks for your help! ... View more

Re: The SUBSTR function call has too many arguments

by Barite | Level 11 in SAS Programming
‎03-07-2016 12:55 PM
‎03-07-2016 12:55 PM
@Astounding This code is producing the desired result, but I'm getting a warning message: "NOTE: Invalid second argument to function SUBSTR at line 180 column 18."   What am I doing wrong here?   180 new{i,j} = substr(original{i}, 2*j-1); 181 end; 182 end; 183 run;   There are 57 variables, not 44 as previously mentioned. DATA want; 58 SET have; 59 60 array original {57} 61 _400201 62 _400202...; 118 119 array new {57,3} $ 2 120 _400201_part1-_400201_part3 121 _400202_part1-_400202_part3...; 177 178 do i=1 to 57; 179 do j=1 to 3; 180 new{i,j} = substr(original{i}, 2*j-1); 181 end; 182 end; 183 run;   ... View more

Re: The SUBSTR function call has too many arguments

by Barite | Level 11 in SAS Programming
‎03-07-2016 10:32 AM
‎03-07-2016 10:32 AM
<It's still not clear if you want to copy two characters from the original variable,>   I want to copy 2 characters from the original variable. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-04-2024 08:13 PM
Likes given to
Likes from
Quick links