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: 
pali
‎11-10-2018
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: RECFM LRECL

by Fluorite | Level 6 in SAS Data Science
‎07-08-2013 09:05 AM
2 Likes
‎07-08-2013 09:05 AM
2 Likes
LRECL is logical record length.It denotes the length of input buffer which is created in datastep processing. Data flows from input buffer to pdv to your dataset in datastep processing. Input buffer holds record of the text file that is being read in a datastep. By default the length if input buffer is 256 bytes (which means if you are reading a file which has more than 256 bytes in a row then you have to increase this limit else SAS will not be able to read complete data from that row). RECFM can be fixed or it can be Variable. A file's record format is said to be fixed if you can not write more than specified byte in a row. Where as in files like notepad or wordpad you can write as much data in a row as you want. This makes .txt or .dat files as Variable length file. ... View more

Re: Function to locate the last character in a string

by Fluorite | Level 6 in SAS Enterprise Guide
‎07-02-2013 09:55 AM
‎07-02-2013 09:55 AM
Hi, In the query builder you can use expression like this to create a calculated column: case when substr(compress(put(num,15.)), length(compress(put(num,15.))),1)='9' then num+1; else num end I am not sure if you are looking for the same or not. -Saurabh ... View more

Re: Count Non Blanks Across Multiple Columns

by Fluorite | Level 6 in SAS Enterprise Guide
‎07-02-2013 08:29 AM
1 Like
‎07-02-2013 08:29 AM
1 Like
Hi JW, See if it helps! data new; set old; array chars(*)  _character_; array num(*)  _numeric_; count=0; do i=1 to dim(chars); if missing(chars(i))=0 then count=count+1; end; do j=1 to dim(num); if missing(num(j))=0 then count=count+1; end; drop i j; run; -Saurabh ... View more

Re: Can we get the same ex2 dataset in data step also? If so please gi...

by Fluorite | Level 6 in SAS Data Science
‎06-25-2013 10:34 AM
‎06-25-2013 10:34 AM
Seems you are looking a way to remove duplicates on some key variables (method other than proc sort nodupkey): See if it helps: data best;     input patient 1-2 arm $ 4-5 bestres $ 6-7 delay 9-10; datalines; 01 A CR 0 02 A PD 1 03 B PR 1 04 B CR 2 05 C SD 1 06 C SD 3 07 C PD 2 01 A CR 0 03 B PD 1 ; proc sort data=best ; by arm patient; run; data uniq; set best; by arm patient; if first.patient; run; ... View more

Re: Reading human entered data - eg - 'ten' as '10'

by Fluorite | Level 6 in SAS Programming
‎06-25-2013 08:10 AM
‎06-25-2013 08:10 AM
/*Create a dataset to be used to create informat*/ data informat_data; format start $100.; fmtname ='w_to_n'; type='I'; do label=1 to 100; start=tranwrd(put(label,words100.),'-',' '); /*Replacing - with space*/ output; end; run; /*Create an informat*/ proc format cntlin=informat_data; run; /*Apply informat to read words as numbers*/ data test ; input comments $50.; number=input(compbl(lowcase(comments)),w_to_n.); datalines; 10 twenTY FouR Thirty     nine one SIX ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-10-2018 12:02 AM
Likes from
Quick links