Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 123sush

    How to use nested file - reading data from nested file

    Hi, I have 50 patients information and each is in saperate .txt file. The name of TXT file has a format like PAT00001.txt for 1st patient, PAT00002.TXT for second patient.. and this all file names are listed in another text file. I need to read these patient information and study it. To read...
  2. 123sush

    How to use LAG or Retain function in Array

    Thanks all of you for the help. I have submitted the report with in my ded line. Thanks again!
  3. 123sush

    How to use LAG or Retain function in Array

    Hi Nick and KDT , Thanks for the reply. Actually my dataset is some what like this year drug1 drug2 drug3 drug4 drug5 drug6 drug7 drug8 drug9 1992 10 15 12 13 12 15 12 16 21 1993 12 12 12 11 12 20 11 18 19 1994 ....... 1995...
  4. 123sush

    How to use LAG or Retain function in Array

    Hi, I have a data set with price of 23 drugs in past 5 years.I need to find out each year average price by subtracting current year with previous year divide by two for all 23 drugs and for all years. I am thinking to use DO loop for year and durgs and use of lag function to get last price...
  5. 123sush

    Reading raw data file

    Thanks Chris, I am using / for reading next line. I removed it and it also worked. I am little confused that if I have to use formula for percentage rating for car1 in year 1991 = (rating of car1 in 1991 - rating of car1 in 1990) * 100 divide by rating of car1 in 1990 Then in that case how...
  6. 123sush

    Reading raw data file

    Thanks Chris. I am a Cobol developer and just started in SAS. I wrote the code to read the input file thru Array like below. ********************************************* data car_price; infile 'C:\SAS\annual_car_price.txt'; Array SY{10,24} Y1S1-Y1S24 Y2S1-Y2S24 Y3S1-Y3S24 Y4S1-...
  7. 123sush

    Reading raw data file

    I am new to SAS and I need to generate report for an input data given name of care, their rating and year. The report should show average rating of car in particular year. Te data look like car1 car2 car3 car4 car5 car6 .......car30 1990 3 2 1991 4 4 and so on...

Part and Inventory Search

Back
Top