About SASPhile

SASKiwi · ‎08-23-2022

My understanding is that you can't use S3 for "normal" SAS libraries / storage, that is, SAS7BDAT files. S3 is for other file types like text and delimited files. If you are using SAS Viya, then SASHDAT-format files can be stored on S3.

andreas_lds · ‎01-27-2022

@sujaybshha wrote: Could you provide an example x command to copy a text file using SAS Studio? In most environments i have access to, the xcmd is disabled in SAS Studio session. So you may want to check the status of xmcd: proc options option=xcmd; run;

Kurt_Bremser · ‎09-29-2021

Go to the Communities Home Page and hit "Ask a Question". But BEFORE you do this, study this article closely to get you started. Do not skip this.

sandyzman1 · ‎03-12-2021

Awesome. Simple and Straightforward.

novinosrin · ‎10-22-2020

data have; input ID $8. Description $; cards; 001 Text1 002:003 Text2 ; data Need; length _id $20; set have; do _n_=1 to countw(id,':'); _id=scan(id,_n_,':'); output; end; drop id; rename _id=id; run;

SASPhile · ‎09-30-2020

My bad, I forgot to update the records, The refid2 should be 005, 006 and 007 respectively 1 122005 0.00 001 Sep1 001 2 122005 0.25 002 Sep2 002 3 122005 1.00 003 Sep3 003 4 122005 3.00 004 Sep4 004 5 122006 0.25 002 Sep1 002 6 122006 1.00 003 Sep2 003 7 122006 3.00 004 Sep3 004 8 122006 0.00 005 Sep4 005 9 122006 1.00 006 Sep5 006 10 122006 3.00 007 Sep6 007

ballardw · ‎09-25-2020

@SASPhile wrote: I found the trick: proc format ; picture newfmt(default=10) other='%b-%Y'(datatype=date); run; This gets me the desired output. Default = 8 would likely be better to prevent leading spaces.

LeonidBatkhan · ‎09-24-2020

I would caution about using DEQUOTE() function since it does not exactly remove "surrounding" quotes. According to the documentation for DEQUOTE function it "Removes matching quotation marks from a character string that begins with a quotation mark, and deletes all characters to the right of the closing quotation mark." That means that if your character string begins with a quotation mark and has the same quotation mark somewhere inside it's value, the DEQUOTE function will strip all the characters after that "internal" quotation mark. Try running the following code: data A; length c $40; input c $char40.; c1 = dequote(c); put c1=; datalines; 'Some' value' ; It will produce the following in the SAS log: c1=Some That is you will lose information (word value is lost). UNQUOTE() Function To prevent such information loss I developed and implemented a user-defined function UNQUOTE that does exactly what was asked in this question - remove matching single or double quotes surrounding character value. You can find the UNQUOTE() function implementation code along with a detail review of other quoting and unquoting issues in the following blog post How to unquote SAS character variable values.

Tom · ‎03-09-2020

@SASPhile wrote: Hi Tom, Its only the second and foruth record that needs parsing. To not find those two then do not include the hyphen as one of the valid characters in the VERIFY() call. But can you have negative values like: -123? Are you only looking for integers? What about values like 1.5 ? How about scientific notation, 1.2E23 ? What about percentages like: 10%? What commas separating thousands groups like: 1,234? Do you want try converting the value to an actual number? Try using the INPUT() function. What informat to want to use?

kiranp · ‎01-24-2020

BIG THANKS to all ideas! I solved it by including my statements into a dataset, but I can't understand why my initial version works for only a few people.

Tom · ‎01-09-2020

@SASPhile wrote: If the date doesnt have seconds ,I dont want to display seconds. Then you need to store that information in another variable. The easiest way is to just keep the original text string. Or you could store the length of the original string.

r_behata · ‎12-23-2019

data have; input Raw_Date ANYDTDTE.; Raw_Date_New=put(Raw_Date,yymmddd10.); put Raw_Date_New =; cards; 01 NOV 2019 01-NOV-19 ; run; Log : Raw_Date_New=2020-11-01 Raw_Date_New=2019-11-01

Reeza · ‎12-02-2019

Usually you'd have dates attached to those as well to help define the order.

hashman · ‎10-30-2019

@novinosrin: Please feel free to keep plagiarizing ;). Many thanks for the plug! A little note, if I may: Here you can call the ADD method unassigned (i.e. without coding rc=) because due to the subsetting IF logic, it is always successful - the method is called only when the key is not in the table, and so there's no risk of getting a method call error. Kind regards Paul D.

Tom · ‎10-04-2019

Looks good, but you probably will want to tighten up the logic. Make sure test for names that end in ZZ or zZ or Zz also. lowcase(substr(name,length(name)-1,2))='zz' Also you don't want to remove the zz from the middle of a name like PIzzazz. call execute(catx(' ','rename',name,'=',substr(name,1,length(name)-2)))

Online Status	Offline
Date Last Visited	‎04-23-2021 05:04 PM

Multiple rows

Re: Enumeration

Re: Enumeration

Re: Enumeration

Enumeration

Re: Convert YYYY-MM to MON-2020

Re: Convert YYYY-MM to MON-2020

Convert YYYY-MM to MON-2020

Re: Separate Number and characters

Re: Separate Number and characters

Re: Multiple records

Re: Add dummy values to column

Re: INPUT function reported 'WARNING:

Re: INPUT function reported 'WARNING:

Re: INPUT function reported 'WARNING:

Xcopy

long to wide

input and output files

Re: Like Operator

Name match algorithm

Re: SAS and AWS S3

Re: how to sftp files

Re: Remove brackets in a string

Re: select the rows of a table that don't match another table in SQL?

Re: Multiple rows

Re: Enumeration

Re: Convert YYYY-MM to MON-2020

Re: Remove single or double quotes around values

Re: Separate Number and characters

Re: Print Macro value to output window

Re: ISO8601 to Numeric and back to ISO8601

Re: Mixed Dates to YYYY-MM-DD

Re: Update Old id with new

Re: Multiple records

Re: Rename variables