Hmm. That puts a lot of values in the wrong columns. v3 and v6 are always empty. Edit: saw you made some changes. cm(v4)=07 is missing in the line for Boston_Worcester or Chicago-Gary... pmsa (v3) is read into v2
... View more
Yeah right. But have you tried to search for "expand tabstops" in the SAS Product Documentation? The result is revealing (empty). Most of the time, it is easier to find the right SAS documents through google than through the search function on the SAS website. On top of that, I entered the wrong phrase in google, searching for "replace tabs" instead of "expanding tabs" (I'm not a native English speaker).
... View more
Direct import only transfers values, not formulas. If you want to get the formulas, you could decompress the .xlsx and then work through the .xml files in the tree.
... View more
Try this: data cencty; infile '$HOME/sascommunity/cencty.txt' truncover lrecl=100; length inp_line $ 100; input; inp_line = _infile_; *have to do this, or the first 2 blanks are eaten; *expand the tabs; i = indexc(inp_line,byte(9)); do while (i ne 0); x = mod(i-1,8); inp_line = substr(inp_line,1,i-1) !! repeat(' ',7-x) !! substr(inp_line,i+1); i = indexc(inp_line,byte(9)); end; area = substr(inp_line,1,48); cmsa = substr(inp_line,49,4); pmsa = substr(inp_line,57,4); cm = substr(inp_line,65,2); ss = substr(inp_line,73,2); eeeee = substr(inp_line,81,5); drop i x inp_line; run; You may want do some grouping along the cmsa-level cities
... View more
His problem seem to be the tabstops in the file. They need to be expanded to the next column where mod(column,8) = 0. At least I don't know of a simple SAS mechanism to do that.
... View more
I'm working on it. But if you are a US citizen, do something for your country: get ahold of the idiot who created that file and use a LART on him/her.
... View more
With Haikuo's method you avoid the messages from the data step. Aside from that, just put your date-generating code in a separate file and %inc it everywhere you need the dates. However you do it, this piece of code will not use more than just a few milliseconds, so you should do what feels most readable to you. Efficiency is a point of consideration when you start dealing with massive data.
... View more
Since I am both the system admin and the SAS admin, I have complete root access (I also do system installation&maintenance). But I keep my "hats" strictly separated: root - users, file systems, access rights etc sas - SAS installation&maintenance my personal id - SAS development ctrl-m user - manual runs of SAS batch jobs
... View more
Are you absolutely sure that the path works (eg copy it into a cd statement in telnet and the see if ls shows the file)? With that many capital letters there may be an error hiding. Double slashes are usually compressed to single slashes by UNIX. I rarely do more than filename xx "&path./&file"; and have no problems.
... View more
