Date: Fri, 7 Sep 2001 15:29:02 -0500
Reply-To: Bill Kreamer <kreamer@WAISMAN.WISC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Bill Kreamer <kreamer@WAISMAN.WISC.EDU>
Subject: How can I scan a charecter variable for a certain letter in
defined position?
Content-type: text/plain; format=flowed; charset=us-ascii
Hi folks,
I have data step question:
I have a data set that is composed of three variables:
1. ID "Data file name"
2. WAVE "Wavelength"
3. Value "absorbance at the particular a wavelength"
When the data was collected the instrument automatically assigned a unique
ID for each spectrum that was taken. Each new sample was given a unique
four letter assignment and 5 spectrum were taken that were take for each
sample. Each spectrum was save in a separate file that was named based on
the four letter assignment with a sequence number appended to it. Each
individual file was appended into on large data set. I want to calculate
the mean and SD at each of the 12 wavelengths for each group of 5 replicate
spectra for a given sample. The problem is that the value of the ID
variable is different for EACH spectrum in the last digit (1-5) (BSDJ0001,
BSDJ0002, BSDJ0003, BSDJ0004, BSDJ0005).
How do I sort the data so that I can group the data appropriately?
Thanks again,
Bill Kreamer
UW-Madison
Pediatrics
So I have a data set that looks like:
WAVE Value ID
329.88 552.00 BSDJ0001
332.85 561.00 BSDJ0001
368.48 617.00 BSDJ0001
371.45 632.00 BSDJ0001
481.32 1756.00 BSDJ0001
484.29 1793.00 BSDJ0001
516.95 4667.00 BSDJ0001
519.92 9602.00 BSDJ0001
561.50 12850.00 BSDJ0001
564.47 12935.00 BSDJ0001
897.05 73.00 BSDJ0001
900.02 50.00 BSDJ0001
329.88 495.00 BSDJ0002
332.85 513.00 BSDJ0002
368.48 638.00 BSDJ0002
371.45 681.00 BSDJ0002
481.32 1714.00 BSDJ0002
484.29 1829.00 BSDJ0002
516.95 4683.00 BSDJ0002
519.92 9634.00 BSDJ0002
561.50 12809.00 BSDJ0002
564.47 12934.00 BSDJ0002
897.05 53.00 BSDJ0002
900.02 11.00 BSDJ0002
329.88 543.00 BSDJ0003
332.85 531.00 BSDJ0003
368.48 675.00 BSDJ0003
371.45 673.00 BSDJ0003
481.32 1777.00 BSDJ0003
484.29 1788.00 BSDJ0003
516.95 4696.00 BSDJ0003
519.92 9658.00 BSDJ0003
561.50 12780.00 BSDJ0003
564.47 12922.00 BSDJ0003
897.05 85.00 BSDJ0003
900.02 42.00 BSDJ0003
329.88 526.00 BSDJ0004
332.85 500.00 BSDJ0004
368.48 603.00 BSDJ0004
371.45 639.00 BSDJ0004
481.32 1768.00 BSDJ0004
484.29 1844.00 BSDJ0004
516.95 4741.00 BSDJ0004
519.92 9753.00 BSDJ0004
561.50 12846.00 BSDJ0004
564.47 12992.00 BSDJ0004
897.05 48.00 BSDJ0004
900.02 131.00 BSDJ0004
329.88 548.00 BSDJ0005
332.85 541.00 BSDJ0005
368.48 619.00 BSDJ0005
371.45 667.00 BSDJ0005
481.32 1813.00 BSDJ0005
484.29 1877.00 BSDJ0005
516.95 4803.00 BSDJ0005
519.92 9789.00 BSDJ0005
561.50 12872.00 BSDJ0005
564.47 13015.00 BSDJ0005
897.05 102.00 BSDJ0005
900.02 74.00 BSDJ0005
329.88 503.00 BSDK0001
332.85 493.00 BSDK0001
368.48 556.00 BSDK0001
371.45 584.00 BSDK0001
481.32 1200.00 BSDK0001
484.29 1163.00 BSDK0001
516.95 3771.00 BSDK0001
519.92 4224.00 BSDK0001
561.50 12694.00 BSDK0001
564.47 12820.00 BSDK0001
897.05 69.00 BSDK0001
900.02 36.00 BSDK0001
329.88 484.00 BSDK0002
332.85 530.00 BSDK0002
368.48 599.00 BSDK0002
371.45 559.00 BSDK0002
481.32 1102.00 BSDK0002
484.29 1103.00 BSDK0002
516.95 3776.00 BSDK0002
519.92 4208.00 BSDK0002
561.50 12615.00 BSDK0002
564.47 12794.00 BSDK0002
897.05 96.00 BSDK0002
900.02 31.00 BSDK0002
329.88 508.00 BSDK0003
332.85 568.00 BSDK0003
368.48 612.00 BSDK0003
371.45 574.00 BSDK0003
481.32 1089.00 BSDK0003
484.29 1156.00 BSDK0003
516.95 3823.00 BSDK0003
519.92 4250.00 BSDK0003
561.50 12635.00 BSDK0003
564.47 12799.00 BSDK0003
897.05 70.00 BSDK0003
900.02 91.00 BSDK0003
329.88 481.00 BSDK0004
332.85 525.00 BSDK0004
368.48 558.00 BSDK0004
371.45 562.00 BSDK0004
481.32 1115.00 BSDK0004
484.29 1189.00 BSDK0004
516.95 3808.00 BSDK0004
519.92 4198.00 BSDK0004
561.50 12676.00 BSDK0004
564.47 12792.00 BSDK0004
897.05 94.00 BSDK0004
900.02 64.00 BSDK0004
329.88 528.00 BSDK0005
332.85 570.00 BSDK0005
368.48 602.00 BSDK0005
371.45 562.00 BSDK0005
481.32 1157.00 BSDK0005
484.29 1157.00 BSDK0005
516.95 3812.00 BSDK0005
519.92 4247.00 BSDK0005
561.50 12655.00 BSDK0005
564.47 12787.00 BSDK0005
897.05 137.00 BSDK0005
900.02 -13.00 BSDK0005
329.88 675.00 BSDL0001
332.85 744.00 BSDL0001
368.48 842.00 BSDL0001
371.45 852.00 BSDL0001
481.32 9997.00 BSDL0001
484.29 10106.00 BSDL0001
516.95 11648.00 BSDL0001
519.92 11737.00 BSDL0001
561.50 13447.00 BSDL0001
564.47 13592.00 BSDL0001
897.05 101.00 BSDL0001
900.02 14.00 BSDL0001
329.88 659.00 BSDL0002
332.85 728.00 BSDL0002
368.48 858.00 BSDL0002
371.45 875.00 BSDL0002
481.32 9865.00 BSDL0002
484.29 10071.00 BSDL0002
516.95 11538.00 BSDL0002
519.92 11681.00 BSDL0002
561.50 13327.00 BSDL0002
564.47 13514.00 BSDL0002
897.05 61.00 BSDL0002
900.02 53.00 BSDL0002
329.88 704.00 BSDL0003
332.85 730.00 BSDL0003
368.48 875.00 BSDL0003
371.45 827.00 BSDL0003
481.32 9833.00 BSDL0003
484.29 10039.00 BSDL0003
516.95 11492.00 BSDL0003
519.92 11688.00 BSDL0003
561.50 13327.00 BSDL0003
564.47 13447.00 BSDL0003
897.05 94.00 BSDL0003
900.02 58.00 BSDL0003
329.88 700.00 BSDL0004
332.85 706.00 BSDL0004
368.48 845.00 BSDL0004
371.45 898.00 BSDL0004
481.32 10018.00 BSDL0004
484.29 10202.00 BSDL0004
516.95 11722.00 BSDL0004
519.92 11832.00 BSDL0004
561.50 13558.00 BSDL0004
564.47 13747.00 BSDL0004
897.05 145.00 BSDL0004
900.02 140.00 BSDL0004
329.88 728.00 BSDL0005
332.85 687.00 BSDL0005
368.48 823.00 BSDL0005
371.45 840.00 BSDL0005
481.32 9906.00 BSDL0005
484.29 10117.00 BSDL0005
516.95 11605.00 BSDL0005
519.92 11722.00 BSDL0005
561.50 13476.00 BSDL0005
564.47 13570.00 BSDL0005
897.05 127.00 BSDL0005
900.02 101.00 BSDL0005
329.88 387.00 BSDM0001
332.85 446.00 BSDM0001
368.48 456.00 BSDM0001
371.45 399.00 BSDM0001
481.32 874.00 BSDM0001
484.29 848.00 BSDM0001
516.95 2574.00 BSDM0001
519.92 2941.00 BSDM0001
561.50 10088.00 BSDM0001
564.47 10243.00 BSDM0001
897.05 70.00 BSDM0001
900.02 81.00 BSDM0001
329.88 369.00 BSDM0002
332.85 450.00 BSDM0002
368.48 449.00 BSDM0002
371.45 461.00 BSDM0002
481.32 808.00 BSDM0002
484.29 849.00 BSDM0002
516.95 2529.00 BSDM0002
519.92 2839.00 BSDM0002
561.50 10068.00 BSDM0002
564.47 10224.00 BSDM0002
897.05 43.00 BSDM0002
900.02 52.00 BSDM0002
329.88 403.00 BSDM0003
332.85 378.00 BSDM0003
368.48 462.00 BSDM0003
371.45 477.00 BSDM0003
481.32 887.00 BSDM0003
484.29 901.00 BSDM0003
516.95 2549.00 BSDM0003
519.92 2861.00 BSDM0003
561.50 10106.00 BSDM0003
564.47 10243.00 BSDM0003
897.05 90.00 BSDM0003
900.02 26.00 BSDM0003
329.88 386.00 BSDM0004
332.85 402.00 BSDM0004
368.48 406.00 BSDM0004
371.45 419.00 BSDM0004
481.32 859.00 BSDM0004
484.29 893.00 BSDM0004
516.95 2572.00 BSDM0004
519.92 2933.00 BSDM0004
561.50 10048.00 BSDM0004
564.47 10241.00 BSDM0004
897.05 70.00 BSDM0004
900.02 10.00 BSDM0004
329.88 418.00 BSDM0005
332.85 389.00 BSDM0005
368.48 423.00 BSDM0005
371.45 404.00 BSDM0005
481.32 793.00 BSDM0005
484.29 910.00 BSDM0005
516.95 2534.00 BSDM0005
519.92 2902.00 BSDM0005
561.50 10043.00 BSDM0005
564.47 10215.00 BSDM0005
897.05 53.00 BSDM0005
900.02 89.00 BSDM0005
3
