About howardtsai

howardtsai · ‎05-29-2022

Thank you so much Quentin! Yeah I have old college handwritten notes as well....I converted a lot of them into PDF so that was nice. I still enjoy taking notes by hand!

howardtsai · ‎05-05-2022

AH yes that must be it -- I got the two kinds of data confused! Thank you so much Quentin for your help, Howard

howardtsai · ‎05-04-2022

Thank you! I had tried that too, but what complicates it further (arrgh) is artist names with multiple spaces, like "Pierre August Renoir" and "Vincent van Gogh." It's an easy fix, I can just squish the middle and last names together by deleting the space in the original data file. Still, even this simple example has created so much problems that I was just curious about potential solutions. Howard

howardtsai · ‎05-04-2022

Good question -- it seems like it is actually FIVE spaces in the .txt (after I convert it from .dat) file, and not an actual tab. What makes this a headache is that sometimes the values are divided by less than 5 spaces (3-4 spaces). Just seems like the original data file (artists.txt) wasn't written clearly in the first place.

howardtsai · ‎05-04-2022

Dear SAS Community: I want to import a .dat file that is tab delimited. Here is the file (also attached to post): https://support.sas.com/kb/34/436.html "Artists.dat", under the "Downloads" tab When I import it using the INFILE statement, it would create a separate column for every space it encounters, rather than using solely the tab (five spaces). Here is the code I have so far: DATA artists; INFILE 'file_location/file_name'; INPUT Name $ Genre $ Nation $; RUN; As a result each artist's name, rather than being in a single column, gets divided into separate columns (2 or 3) because of the spaces between the artist's first and last names. Is this a problem of the source data format? Thank you for any advise, Howard

howardtsai · ‎04-10-2022

This is for the web-based SAS Studio version. Right click the (virtual) folder where the file is and click "properties." It will show you the path. Mine is /home/u167737/EPG1V2/data. So the correct programming line would be proc contents data="/home/u167737/storm_summary.sas7bdat"; run; Good luck!

Online Status	Offline
Date Last Visited	‎05-29-2022 10:33 AM

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

How do I tell SAS NOT to delimit by space and/or comma?

Re: SAS programming 1 lesson 2 activity 2

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

Re: How do I tell SAS NOT to delimit by space and/or comma?

How do I tell SAS NOT to delimit by space and/or comma?

Re: SAS programming 1 lesson 2 activity 2