topic Re: how to ask SAS continuous to read data after the last variable in SAS Programming

how to ask SAS continuous to read data after the last variable

elsalam — Wed, 25 Apr 2018 17:27:00 GMT

I have a line of raw data as follow.

Variables: GenderType Year Total Asofdate
ihe-M 1970 5,044 Retrieved: 03/14/2012 f-IHE 1970 3,537 Retrieved: 03/14/2012
ihe-m 1980 5,874 Retrieved: 03/14/2012 f-IHE 1980 6,223 Retrieved: 03/14/2012

It should have four gendertype but I can only read ihe-M and ihe-m. How to ask SAS to pick up f-IHE and f-IHE.

Even if I put @, it still won't read.

libname Lesson08 '/home/coccus030/sasuser.v94/';
Data Lesson08.college09ds;
Infile '/home/coccus030/sasuser.v94/institutiondata.txt' firstobs=2;
Input GenderType & $6. Year 7-10 Total comma6. @29 AsofDate mmddyy10.;
run;

Re: how to ask SAS continuous to read data after the last variable

MarkWik — Wed, 25 Apr 2018 17:43:23 GMT

@elsalam You asked the same question in another thread

https://communities.sas.com/t5/Base-SAS-Programming/unable-to-read-messy-raw-data/m-p/457417#M115972

Kindly do not duplicate the same questions over and over .. Thank you!

Re: how to ask SAS continuous to read data after the last variable

SuryaKiran — Wed, 25 Apr 2018 17:49:39 GMT

Did you check the solution in your other post and did you notice double trailing (@@) which is used to hold the line.

http://documentation.sas.com/?docsetId=basess&docsetTarget=n068wqvbjnndvjn17mqpoxdj7te7.htm&docsetVersion=9.4&locale=en

Re: how to ask SAS continuous to read data after the last variable

Astounding — Wed, 25 Apr 2018 17:52:28 GMT

Here's what can be used to replace the INPUT statement:

input GenderType $ 1-5 year 7-10 @11 total comma6. @29 AsofDate mmddyy10. @;

output;

input GenderType $ 40-44 year 46-49 @51 total comma6. @69 AsofDate mmddyy10.;

output;

format asofdate yymmdd10.;

Re: how to ask SAS continuous to read data after the last variable

elsalam — Wed, 25 Apr 2018 18:01:18 GMT

I am self learning so I use SAS studio.

Whenever I put @@ at SAS studio, the output will keep running and never display the result.

therefore, I thought SAS studio won't work with @@.

I don't know computer language well enough to understand the issue so my thought might be kind of stupid.

Re: how to ask SAS continuous to read data after the last variable

elsalam — Wed, 25 Apr 2018 18:03:08 GMT

I ensure this code will work but I wonder whether or not it has another way.

I use @@ at SAS studio but it never display the result.

It will continuous to run so I click cancel.

Thx

Re: how to ask SAS continuous to read data after the last variable

Astounding — Wed, 25 Apr 2018 18:09:40 GMT

You can use @@, but you then have to change the INPUT statement. For example, you can't tell SAS to move to column 29 to start reading the date. If you do that, SAS will never get to the end of the line of data (hence you are seeing an infinite loop). You would need to use a style of INPUT that keeps moving from left to right.

Since the format is slightly different on the left vs. the right (two spaces vs. one space separating two of the variables), it's easier to just hard-code all the positions.

Re: how to ask SAS continuous to read data after the last variable

Tom — Wed, 25 Apr 2018 19:16:26 GMT

Do you have any null values represented as spaces only? There are none in your example.

Variables: GenderType Year Total Asofdate
ihe-M 1970 5,044 Retrieved: 03/14/2012 f-IHE 1970  3,537 Retrieved: 03/14/2012
ihe-m 1980 5,874 Retrieved: 03/14/2012 f-IHE 1980  6,223 Retrieved: 03/14/2012

If not then just use list mode input. Why not just read the text in the line to its own variable?

data want ;
  infile 'filename' firstobs=2 truncover ;
  input GenderType :$10. Year Total :$comma. AsOfType :$12. Asofdate :mmddyy. @@;
  format Asofdate yymmdd10. ;
run;

Re: how to ask SAS continuous to read data after the last variable

elsalam — Thu, 26 Apr 2018 17:39:18 GMT

Thank you for your help.

Your code should work but I want to know the other way on how to