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

Assign one data type, or format, to multiple variables in a DATA step

by Barite | Level 11 in SAS Programming
‎03-16-2016 01:22 PM
‎03-16-2016 01:22 PM
How do I assign one data type, or format, to multiple variables in a DATA step?   In the following code, I want patientid to be a character variable w/ length 18, like name. I know I can add $18 after patientid, but how would I assign one format, or data type, to multiple variables.   I also want age to be a numeric variable w/ length 3. The current syntax produces a length of 8 for the variable age.   Thank you for the help.   data club1; INPUT patientid name $18. weight height age 3.; datalines; 023 Bob Shaw 123 72 58 049 Joey Smith 185 68 78 ; RUN; Variables in Creation Order # Variable Type Len 1 patientid Num 8 2 name Char 18 3 weight Num 8 4 height Num 8 5 age Num 8   ... View more

Re: Using an array to convert numeric variables to character variables

by Barite | Level 11 in SAS Programming
‎03-15-2016 02:49 PM
‎03-15-2016 02:49 PM
Thanks! That makes sense. ... View more

Re: Using an array to convert numeric variables to character variables

by Barite | Level 11 in SAS Programming
‎03-15-2016 02:22 PM
1 Like
‎03-15-2016 02:22 PM
1 Like
@Astounding Thank you. However, I tried that earlier w/ no effect. I just tried it again w/ your code. The PROC CONTENTS shows that they are still numeric:  # Variable Type Len 351 QWB2A Num 8 352 QWB2B Num 8 353 QWB2C Num 8   DATA a4_final_num; SET a4_final_pre; Array _numeric(*) QWB2A QWB2B QWB2C; Array _character(*) $ 8 var1-var3; DO i=1 to dim(_numeric); _character(i) = PUT(_numeric(i),8.); END; RUN;     1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 57 DATA a4_final_num; 58 SETa4_final_pre; 59 60 Array _numeric(*) 61 QWB2A 62 QWB2B 63 QWB2C; 64 65 Array _character(*) $ 8 var1-var3; 66 67 DO i=1 to dim(_numeric); 68 _character(i) = PUT(_numeric(i),8.); 69 END; 70 71 RUN; NOTE: There were 404 observations read from the data set WORK.A4_FINAL_PRE. NOTE: The data set WORK.A4_FINAL_NUM has 404 observations and 495 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.05 seconds 72 73 PROC CONTENTS DATA=a4_final_num (KEEP=QWB2A 74 QWB2B 75 QWB2C); 76 RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.10 seconds cpu time 0.08 seconds 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90 ... View more

Using an array to convert numeric variables to character variables

by Barite | Level 11 in SAS Programming
‎03-15-2016 01:52 PM
‎03-15-2016 01:52 PM
Why is this code not converting numeric variables to character variables? In fact, the log says it is doing the opposite, although a PROC CONTENTS reveals no conversion actually took place. Thank you for the assistance.   DATA a4_final_num; SET a4_final_pre; Array _numeric(*) QWB2A QWB2B QWB2C; Array _character(*) var1-var3; DO i=1 to dim(_numeric); _character(i) = PUT(_numeric(i),8.); END; RUN;   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 DATA a4_final_num; 57 SETa4_final_pre; 58 59 Array _numeric(*) 60 QWB2A 61 QWB2B 62 QWB2C; 63 64 Array _character(*) var1-var3; 65 66 DO i=1 to dim(_numeric); 67 _character(i) = PUT(_numeric(i),8.); 68 END; 69 70 RUN; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 67:6 ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-15-2016 01:05 PM
‎03-15-2016 01:05 PM
@Tom @Reeza Can you use PROC IMPORT and assign attributes for some of the variables, but let SAS guess at the others? Like a hybrid of a DATA step w/ LENGTH, INFORMAT, FORMAT, etc. and PROC IMPORT. ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-14-2016 01:28 PM
‎03-14-2016 01:28 PM
Perhaps the issue is w/ the different versions of Excel. I'm running Excel for Mac 2011. The same code also ran w/o error when it was converted from .xlsx to .csv on Windows... ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-14-2016 01:24 PM
‎03-14-2016 01:24 PM
Btw, I had a friend use Excel on Windows to convert the same file to a .csv and it worked w/o error in PROC IMPORT. Crazy. ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-14-2016 01:22 PM
‎03-14-2016 01:22 PM
@Tom This is very helpful. Thank you!   I'm using SAS University Edition and getting an error w/ your code. ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/cars_noheader.csv.   Regardless, I understand what you are trying to convey. This whole exercise was designed to understand what SAS does in PROC IMPORT. How it interprets data and assigns attributes. That's why I put a character string in the "numeric" variable and a number (i.e. 999) in the "character" variable. I wanted to see what SAS would do.    I understand that using a DATA step gives you much more control when reading in your data. The one drawback, it would seem, is when you have a large number of variables. I have a data set w/ 1,600 variables!   How do you assign informats and formats to multiple variables simultaneously? In your example, it looks like msrp and invoice will both be assigned the comma8. informat. What if there were other variables and other informats. Would you just follow the same convention (i.e. List variables individually followed by the informat). What about using lists of variables? ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-14-2016 12:24 AM
‎03-14-2016 12:24 AM
Does the DATAROW option have a different effect than the FIRSTOBS=2 option in this situation? ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-14-2016 12:23 AM
‎03-14-2016 12:23 AM
@Reeza The file is attached. Thanks for your assitance.    I'm using Mac for Excel 2011 ... View more

Re: Reading a .csv file into SAS using PROC IMPORT

by Barite | Level 11 in SAS Programming
‎03-13-2016 09:23 PM
‎03-13-2016 09:23 PM
@Tom   <The data you posted was all on one line, which matches what your SAS log says.>   When I copy and paste the data from TextEdit into a Word file, or an email message, it is in colums and rows (See screen shot, lower half). When I paste in into this message it is on one line.     <Where did you create the file?>   In Excel for Mac. There is no visible line break in the file (e.g.  '0D'x).    Is there something wrong with the way I am creating the .csv file from Excel? I simply typed the values into cells and then saved the file as a .csv file.   When I look more closely at the UCLA data, the non-standard data values are enclosed in quotation marks (See screen shot, upper half).    SAS is not recognizing the end of a row/observation. Do I need to tell it explicitly? With a DATA step I use the TERMSTR=CR option, which works.    <Note that there is not much value in using PROC IMPORT to read a file without column headers, especially one with only two columns.>   I'm just playing around at this point. Trying to understand how SAS assigns attributes to data during PROC IMPORT. My real data has more variables and observations. I'm not exactly clear on why PROC IMPORT wouldn't be valuable w/o column headers. Could you elaborate?   Thanks very much for your help! ... View more

How to read a .csv file into SAS using PROC IMPORT?

by Barite | Level 11 in SAS Programming
‎03-13-2016 07:41 PM
1 Like
‎03-13-2016 07:41 PM
1 Like
I am failing miserably at what should be a simple task. Reading a .csv file into SAS using PROC IMPORT.   I have followed instructions per the UCLA ATS site, the Little SAS book and other sources.   When I download the cars_novname.csv file from the UCLA Web site, this code works fine:   proc import datafile="\\Mac\Home\Downloads\cars_novname.csv" out=mydata dbms=csv replace; getnames=no; run;   When I use the same exact code, with my own data (Below), SAS reads in 1 observation and 6 variables. Given the data, it should be 4 observations and 2 variables. My .csv file was created in Excel and saved as a .csv. It looks identical to the data in the UCLA file when opened w/ a text editor. There is a comma separating each value and a carriage return after each line of data.   proc import datafile="\\Mac\Home\Desktop\Backup Desktop/num_char_test.csv" out=mydata_2 dbms=csv replace; getnames=no; run;   What am I doing wrong here? Thanks for your help.   Here is the data: numeric,character 123,TOM 234,BOB NULL,999 222,Fred 2 variables (numeric, character) and 8 observations. Log: 1 rows created in WORK.MYDATA_2 from \\Mac\Home\Desktop\Backup Desktop/num_char_test.csv.   NOTE: WORK.MYDATA_2 data set was successfully created. NOTE: The data set WORK.MYDATA_2 has 1 observations and 6 variables. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.17 seconds       cpu time            0.07 seconds ... View more

Re: Adding a space in a specific location to character string

by Barite | Level 11 in SAS Programming
‎03-11-2016 04:02 PM
‎03-11-2016 04:02 PM
TIME8. comes from this source, which identifies it as an Informat. What am I missing? ... View more

Re: Adding a space in a specific location to character string

by Barite | Level 11 in SAS Programming
‎03-11-2016 03:27 PM
‎03-11-2016 03:27 PM
@Reeza Could you help me do that?   I'm not having success assigning informats to the data (See code).   DATA timedata_a1_a5 ; INFILE "/folders/myfolders/XXXX/XXXX/! Datasets/Original Datasets/Time Data A1-A5.csv" DLM="," DSD TERMSTR=CR; INPUT PATIENTID a1_300101 TIME8. a1_300102 TIME8. a1_300201 TIME8. a1_300202 TIME8.; RUN; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 DATA timedata_a1_a5 ; 57 INFILE "/folders/myfolders/XXX/XXX/! Datasets/Original Datasets/Time Data A1-A5.csv" DLM="," DSD TERMSTR=CR; 58 INPUT PATIENTID 59 a1_300101 TIME8. a1_300102TIME8. a1_300201 TIME8. a1_300202 TIME8. ; 60 RUN; NOTE: The infile "/folders/myfolders/UCSD/SMART/! Datasets/Original Datasets/Time Data A1-A5.csv" is: Filename=/folders/myfolders/UCSD/SMART/! Datasets/Original Datasets/Time Data A1-A5.csv, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=11Mar2016:12:04:45, File Size (bytes)=60019 NOTE: Invalid data for a1_300102 in line 1 12-19. NOTE: Invalid data for a1_300201 in line 1 20-27. NOTE: Invalid data for a1_300202 in line 1 28-35. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 26,11:00 PM,01:00 AM,09:00 AM,10:30 AM,9:00 PM,10:00 PM,10:00 AM,8:30 AM,10:00 PM,11:00 PM,7:00 AM,8 101 :00 AM,8:00 PM,10:00 PM,4:00 AM,9:00 AM,10:00 PM,12:00 AM,4:30 AM,9:00 AM 173 PATIENTID=26 a1_300101=82800 a1_300102=. a1_300201=. a1_300202=. _ERROR_=1 _N_=1 NOTE: Invalid data for a1_300101 in line 2 4-11. NOTE: Invalid data for a1_300201 in line 2 20-27. NOTE: Invalid data for a1_300202 in line 2 28-35.   Etc... ... View more

Adding a space in a specific location to character string

by Barite | Level 11 in SAS Programming
‎03-11-2016 01:50 PM
‎03-11-2016 01:50 PM
I have a dataset w/ times stored as character strings. In some strings, there is a space between the trailing number, usually 0, and the AM/PM designation (e.g. 10:00 PM). In others, there is no space (8:00PM).   How can I create consistency in these data so that there is a space after the time and before the AM/PM designation?   Obs _300101 _300102 _300201 _300202 1 8:00PM 10:00 PM 4:00 AM 9:00AM 2 1:00 AM 2:00 AM 10:00 AM 12:00 PM 3 12:00AM 11:30AM 8:00AM 6:30AM 4 12:00 AM 2:00 AM 6:00 AM 11:00 AM   Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-04-2024 08:13 PM
Likes given to
Likes from
Quick links