About SASguyCO

SASguyCO · ‎01-30-2012

Thanks Tom, that worked too!

SASguyCO · ‎01-30-2012

Thanks FriedEgg! that's the ticket! Quick questions though, what is the purpose of the colon before the informat? You have it again after the acct variable too? Last, how come you changed the anydtdte length to be 21? Was there a reason you chose that length?

SASguyCO · ‎01-30-2012

Here is a sample of what's in the text file: "Date","Account Number (prop6)","Visits" "January 1, 2011","",31709 "January 1, 2011","10001767",1 "January 1, 2011","10003595",1 "January 1, 2011","1001489",1 "January 1, 2011","10041613",1 "January 13, 2011","52094543",1 "January 13, 2011","52094640",1 "April 10, 2011","",37979 "April 11, 2011","",36743 "April 12, 2011","",36164 "April 13, 2011","",36517

SASguyCO · ‎01-30-2012

I've never been too good at importing raw text files and am having trouble with this simple one. Only has three columns, however the first one is a date column that is written out in full form ie January 5, 2011, etc... Need to bring it into SAS EG and have gotten this far below, but it's still not quite right. Attached is a sample of the raw text file and testfile is the fileref to the actual text file. Any assistance is greatly appreciated! data test; infile testfile firstobs=2 dsd termstr=crlf; *length date $20.; input date anydtdte20. cust_acct_nbr visits; run;

SASguyCO · ‎09-28-2011

Thanks again Art and FriedEgg. Looks like it's not defined. I looked at the link Art and it's certainly helpful. Option 2 won't fly for sure, and option 1 requires me to gain admin rights which they will want to know what for so I'm not sure they'll let me go about it that way either. Appreciate the help!

SASguyCO · ‎09-28-2011

You'll have to forgive my ignorance on this, but what do you mean by check your options: xcmd, xsync, xwait? How do I do that? I should state I'm doing all this in SAS EG but within actual code.

SASguyCO · ‎09-28-2011

Tried that FriedEgg, and got the following: ERROR: Shell escape is not valid in this SAS session.

SASguyCO · ‎09-28-2011

Hey Art!, thanks for responding, I guess I should have been more specific... I love Proc delete!, but it won't work on a "locked" data set Problem is each night there is some sort of back up running and the data set becomes locked and I need to overwrite it (every night) and the SAS process fails to overwrite as it says the file is locked. I can however, go in and manually delete the data set in windows explorer and then recreate it, but I want to be able to either overwrite the existing one, or delete the old one first (from a locked state) and recreate it.

SASguyCO · ‎09-28-2011

Anyone have any code that can be used to delete a file that does not involve using proc delete? thanks!

SASguyCO · ‎08-19-2011

Thanks Bruce, I have since learned this as well through talking with someone on the phone at SAS support. It seems like it would be a great feature to add in a future update as Cognos has this ability.......

SASguyCO · ‎08-19-2011

Thanks Bob, yes I only use SAS EG to view the cubes. It is a great tool.

SASguyCO · ‎07-19-2011

Thanks again Tom! Excellent solutions for sure! The first one worked perfect just using the countw function which I was unaware of. I tried the count one as well and that did the trick too. Really appreciate it!

SASguyCO · ‎07-19-2011

Tom, Regarding how to do this when N is unknown, I'm not sure how to do it with your recommendations above. I've tried it several ways using a %do %while and %do %until and trying to determine if the value is blank to terminate the loop, but I keep getting errors. Can you show me how I would do this if the N is unknown? thanks again!

SASguyCO · ‎07-19-2011

Thanks for the response Tom, makes sense.

SASguyCO · ‎07-19-2011

Thank you Peter, that did the trick. The 1 was an error on my part of typing as I did have the &i in the original. I'm familiar with the symbolgen mprint mlogic as well, thank you. My question is I was able to run this not using the %str(' ') inside with the blank quotes and just using the empty single quotes alone ' '. What is the purpose of the %str in this case? I'm not familiar with the %str and thus was curious what it does here. thank you all for your help.

Online Status	Offline
Date Last Visited	‎12-16-2015 11:23 AM

Re: sample a similar population?

sample a similar population?

Re: Need to condense a PROC SQL into one step

Re: Need to condense a PROC SQL into one step

Need to condense a PROC SQL into one step

Re: preserving (or adding single 'quotes') around a computed macro rol...

preserving (or adding single 'quotes') around a computed macro rolling...

calling E-miner from SAS EG code?

how to subset data for a graph so that lines are not stacked?

how to subset data for a graph so that lines are not stacked?

Re: trouble importing raw text file (3 columns only)

Re: trouble importing raw text file (3 columns only)

trouble importing raw text file (3 columns only)

trouble importing raw text file (3 columns only)

how to delete a SAS file without using PROC DELETE

how to delete a SAS file without using PROC DELETE

Re: how to delete a SAS file without using PROC DELETE

Re: how to delete a SAS file without using PROC DELETE

how to delete a SAS file without using PROC DELETE

stacking dimensions in cube studio??

stacking dimensions in cube studio??

how to take a list of n variables and assign them to macro variables c...

how to take a list of n variables and assign them to macro variables c...

how to take a list of n variables and assign them to macro variables c...

how to take a list of n variables and assign them to macro variables c...