cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
riccardo88
‎01-26-2021
  • 33 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Proc MI: impute only some missing values and select range of imputed v...

by Calcite | Level 5 in Statistical Procedures
‎01-06-2021 11:57 AM
‎01-06-2021 11:57 AM
Hallo everybody, I am working with a database that looks like this: data have; input id trt $ var1 $ var2 $; datalines; 1 placebo 0.2 3.0 2 placebo 1.1 <1.0 3 drug <0.2 2.0 4 placebo 2.3 . 5 drug <0.2 2.2 6 drug . 1.2 ; As you can see I have missing values and values that are reported as "below the limit of detection" from the laboratory. My aim is to use multiple imputation to impute ONLY the values under the limit of detection and not the real missing values. To do this  I differentiated the two "kinds" of missing values like this: data have; set have; if var1='' then var1_n=.a; else if var1 ne '' then var1_n = input(var1, 8.); if var1_n=. then var1_n=.b; if var2='' then var2_n=.a; else if var2 ne '' then var2_n = input(var2, 8.); if var2_n=. then var2_n=.b; drop var1 var2; run; Now A are real missing values and B are values below detection limit.   My questions are: 1) Is it possible to use proc mi specifing that I want to impute only the missing values specified with B and not all missing values? 2) Is there an option in proc mi to specify that the imputed values should be between 0 and the limit of detection (for example for var1 between 0 and 0.2)?   Thank you very much for your help!   SAS Version: 9.4 ... View more

Count different kinds of missing values for numerical variable

by Calcite | Level 5 in SAS Programming
‎01-06-2021 04:31 AM
‎01-06-2021 04:31 AM
Hello everybody, I have a dataset of this kind: data have; input var; datalines; 34 54 .a .b 65 .b ; As you can see I have different kinds of missing values identified with "A" and "B". I would like to know how many A and B missing values are there: e.g. A: 1; B: 2 Does anybody know how?   Thank you very much!   SAS Version: 9.4 ... View more

Problem with importing csv files and creating new variables

by Calcite | Level 5 in SAS Programming
‎10-30-2019 04:58 AM
‎10-30-2019 04:58 AM
Hallo!   I have to import some csv files and the device I used to collect the data creates csv files with a strange format  with some information on the side (see image). Is there any way to create new variables with those informations (e.g. ID=G, Sex=Male, Age=25, etc...)?     You can find 3 csv file in the attachments section and this is the code I used to import them.   data want; infile "FolderHave\*csv" dlm=',' missover dsd; input one $ two $ three $ four $ five $ six $ seven $ eight $ nine $ time $ VP VO2 VCO2 R VO2divKg METS HF VO2divHF FeO2 FeCO2 FiO2 FiCO2 PeO2 PeCO2 SpO2 Phase $ Marker $ UmgebTemp RHUmgeb Sensordruck PB EEkc EEh EEm EEtot EEkg PRO FETT KH PROprc FETTprc KHprc npRQ tRel Phasenzeit $ VO2prcSoll; run; My SAS version is 9.4.   Thank you very much for your help!!!   Riccardo ... View more

Create VBAR and HBAR with percentages of a continuos variable

by Calcite | Level 5 in Graphics Programming
‎10-21-2019 05:51 AM
‎10-21-2019 05:51 AM
Hallo! I would need some help to create a Graph with my data. The dataset looks like this: data have; input ID $ co2 $ area area_under area_over; datalines; 101 High 329274.45563 1161.4533333 328113.0023 101 Low 329807.07976 51867.348667 277939.7311 103 High 299940.79867 1437.205 298503.59367 103 Low 309707.27464 196061.47517 113645.79948 105 High 500296.11766 32079.163619 468216.95404 105 Low 330042.631 69774.392944 260268.23805; Run; and the graphS I would like to obtain like this:   N.1   where I have two vBars (one for every co2 level) and the blue part rapresent the percentage area_over/area and the red part rapresent the percentage area_under/area. If possible I would also like to have a standard deviation bar.     N.2   The second Graph I would like to have looks like this     Thank you very much for your help!   Riccardo ... View more

Re: Create increasing variable from 1 to 7 and start again when some c...

by Calcite | Level 5 in New SAS User
‎03-11-2019 07:47 AM
‎03-11-2019 07:47 AM
data want; input ID Date_for:mmddyy10. Time_start_for $ Session; infile datalines dlm=','; format Date_for mmddyy10.; datalines; 101,01/31/19,10:19,1 101,01/31/19,10:19,1 101,01/31/19,10:19,1 101,01/31/19,10:19,1 101,01/31/19,10:19,1 101,01/31/19,11:58,2 101,01/31/19,11:58,2 101,01/31/19,11:58,2 101,01/31/19,11:58,2 101,01/31/19,11:58,2 101,01/31/19,13:00,3 101,01/31/19,13:00,3 101,01/31/19,13:00,3 101,01/31/19,13:00,3 101,01/31/19,13:00,3 101,01/31/19,14:00,4 101,01/31/19,14:00,4 101,01/31/19,14:00,4 101,01/31/19,14:00,4 101,01/31/19,14:00,4 101,01/31/19,15:01,5 101,01/31/19,15:01,5 101,01/31/19,15:01,5 101,01/31/19,15:01,5 101,01/31/19,15:01,5 101,01/31/19,15:58,6 101,01/31/19,15:58,6 101,01/31/19,15:58,6 101,01/31/19,15:58,6 101,01/31/19,15:58,6 101,01/31/19,16:59,7 101,01/31/19,16:59,7 101,01/31/19,16:59,7 101,01/31/19,16:59,7 101,01/31/19,16:59,7 101,02/07/19,9:34,1 101,02/07/19,9:34,1 101,02/07/19,9:34,1 101,02/07/19,9:34,1 101,02/07/19,9:34,1 101,02/07/19,11:00,2 101,02/07/19,11:00,2 101,02/07/19,11:00,2 101,02/07/19,11:00,2 101,02/07/19,11:00,2 101,02/07/19,11:57,3 101,02/07/19,11:57,3 101,02/07/19,11:57,3 101,02/07/19,11:57,3 101,02/07/19,11:57,3 101,02/07/19,12:58,4 101,02/07/19,12:58,4 101,02/07/19,12:58,4 101,02/07/19,12:58,4 101,02/07/19,12:58,4 ; run; The session has to Change when "Time_start_for" changes so this variable is also required. ... View more

Re: Create increasing variable from 1 to 7 and start again when some c...

by Calcite | Level 5 in New SAS User
‎03-11-2019 07:32 AM
‎03-11-2019 07:32 AM
Doesn't work. 😞 It gives me session_number is equal1 for every observation. ... View more

Re: Create increasing variable from 1 to 7 and start again when some c...

by Calcite | Level 5 in New SAS User
‎03-11-2019 07:10 AM
‎03-11-2019 07:10 AM
Thank you! No every 5 lines correspond to a session (basically every time "Time_start_for" Changes we have a new session.   And also ID 101 for example has 14 sessions but on 2 different days. On both days the sessions should be marked from 1 to 7. ... View more

Re: Create increasing variable from 1 to 7 and start again when some c...

by Calcite | Level 5 in New SAS User
‎03-11-2019 07:08 AM
‎03-11-2019 07:08 AM
Dear Amir,   Thank you very much for answer. Unfortunately is not what I Need.   The session_number should be the same for lines with same "Time_start_for", Count up to 7 and then start again from 1.   Regards,   Riccardo ... View more

Re: Create increasing variable from 1 to 7 and start again when some c...

by Calcite | Level 5 in New SAS User
‎03-11-2019 06:50 AM
‎03-11-2019 06:50 AM
ID,Date_for,Time_start_for,_TYPE_,_FREQ_,_STAT_,HR,Atemfrequenz,SpO2 101,01/31/19,10:19,0,118,N,118,118,118 101,01/31/19,10:19,0,118,MIN,81.5,7.5757575758,95 101,01/31/19,10:19,0,118,MAX,96.25,27.649769585,96 101,01/31/19,10:19,0,118,MEAN,88.846559726,14.766582398,95.156920904 101,01/31/19,10:19,0,118,STD,2.7743979079,2.7931480556,0.305087647 101,01/31/19,11:58,0,140,N,140,140,140 101,01/31/19,11:58,0,140,MIN,75,6.8259385666,89.333333333 101,01/31/19,11:58,0,140,MAX,93,23.346303502,92 101,01/31/19,11:58,0,140,MEAN,83.328511905,17.71234626,90.900436508 101,01/31/19,11:58,0,140,STD,3.1957743662,2.8950150452,0.6360118615 101,01/31/19,13:00,0,151,N,151,151,151 101,01/31/19,13:00,0,151,MIN,78.6,7.5949367089,89 101,01/31/19,13:00,0,151,MAX,92.333333333,23.166023166,92.333333333 101,01/31/19,13:00,0,151,MEAN,85.379801325,18.333250653,90.838410596 101,01/31/19,13:00,0,151,STD,2.5256651737,2.8289307891,0.6783282034 101,01/31/19,14:00,0,154,N,154,154,154 101,01/31/19,14:00,0,154,MIN,67.333333333,6.7643742954,91 101,01/31/19,14:00,0,154,MAX,101.5,30,94 101,01/31/19,14:00,0,154,MEAN,87.054298083,19.278342826,92.448953824 101,01/31/19,14:00,0,154,STD,4.145978296,3.1982577136,0.6179428555 101,01/31/19,15:01,0,150,N,150,150,150 101,01/31/19,15:01,0,150,MIN,78,6.8337129841,91 101,01/31/19,15:01,0,150,MAX,99.2,32.786885246,95 101,01/31/19,15:01,0,150,MEAN,84.734404762,18.504781387,92.669777778 101,01/31/19,15:01,0,150,STD,3.2353262727,3.5150039626,0.7165649131 101,01/31/19,15:58,0,159,N,159,159,159 101,01/31/19,15:58,0,159,MIN,80,9.7879282219,90 101,01/31/19,15:58,0,159,MAX,92,23.529411765,94 101,01/31/19,15:58,0,159,MEAN,86.893186583,19.174924095,91.981551363 101,01/31/19,15:58,0,159,STD,2.496592061,2.3915392137,0.7136098857 101,01/31/19,16:59,0,154,N,154,154,154 101,01/31/19,16:59,0,154,MIN,80.5,6.528835691,92 101,01/31/19,16:59,0,154,MAX,98.333333333,24.291497976,96 101,01/31/19,16:59,0,154,MEAN,88.338899196,19.373919748,93.797186147 101,01/31/19,16:59,0,154,STD,2.6253857217,3.1071420356,0.8541002927 101,02/07/19,9:34,0,138,N,138,138,138 101,02/07/19,9:34,0,138,MIN,83,7.4074074074,96.75 101,02/07/19,9:34,0,138,MAX,96.5,23.255813953,98.666666667 101,02/07/19,9:34,0,138,MEAN,89.338112491,17.429150926,97.667011732 101,02/07/19,9:34,0,138,STD,2.3489566457,3.1713217584,0.4528912065 101,02/07/19,11:00,0,145,N,145,145,145 101,02/07/19,11:00,0,145,MIN,79.666666667,6.0975609756,88 101,02/07/19,11:00,0,145,MAX,90.333333333,23.166023166,92.75 101,02/07/19,11:00,0,145,MEAN,85.648259442,17.757981771,89.848604269 101,02/07/19,11:00,0,145,STD,2.4946143529,2.9558597284,0.8604079029 101,02/07/19,11:57,0,149,N,149,149,149 101,02/07/19,11:57,0,149,MIN,74.666666667,9.2592592593,89 101,02/07/19,11:57,0,149,MAX,86.5,25.210084034,93.666666667 101,02/07/19,11:57,0,149,MEAN,82.228427613,18.242657167,91.121428571 101,02/07/19,11:57,0,149,STD,2.1273408499,3.0168947674,0.9109684751 101,02/07/19,12:58,0,141,N,141,141,141 101,02/07/19,12:58,0,141,MIN,77,5.1063829787,89 101,02/07/19,12:58,0,141,MAX,91,34.88372093,93 101,02/07/19,12:58,0,141,MEAN,84.177090049,18.019936177,91.111583924 101,02/07/19,12:58,0,141,STD,2.9756893198,3.593121113,0.8299501402 101,02/07/19,13:58,0,135,N,135,135,135 101,02/07/19,13:58,0,135,MIN,79,7.3619631902,88.75 101,02/07/19,13:58,0,135,MAX,92,26.200873362,93 101,02/07/19,13:58,0,135,MEAN,85.887460317,16.609089431,89.862345679 101,02/07/19,13:58,0,135,STD,2.3950279785,2.9043491671,0.902890519 101,02/07/19,14:55,0,142,N,142,142,142 101,02/07/19,14:55,0,142,MIN,83.25,8.1190798376,89 101,02/07/19,14:55,0,142,MAX,96.75,21.428571429,93.5 101,02/07/19,14:55,0,142,MEAN,89.697065728,17.453225263,90.860160966 101,02/07/19,14:55,0,142,STD,2.7399597438,2.8494281241,0.6730471505 101,02/07/19,15:59,0,144,N,144,144,144 101,02/07/19,15:59,0,144,MIN,78.5,9.6,89 101,02/07/19,15:59,0,144,MAX,90.666666667,22.556390977,93 101,02/07/19,15:59,0,144,MEAN,85.147106481,17.402927058,90.960532407 101,02/07/19,15:59,0,144,STD,2.5681513657,2.46291814,0.8412646956 126,02/01/19,9:51,0,96,N,96,96,96 126,02/01/19,9:51,0,96,MIN,67.6,7.100591716,95 126,02/01/19,9:51,0,96,MAX,83,22.900763359,97 126,02/01/19,9:51,0,96,MEAN,72.25536541,12.918101228,95.826116071 126,02/01/19,9:51,0,96,STD,2.6607553354,3.5511741217,0.6422341224 126,02/01/19,11:26,0,129,N,129,129,129 126,02/01/19,11:26,0,129,MIN,78,7.2115384615,65.6 126,02/01/19,11:26,0,129,MAX,97,32.432432432,80.666666667 126,02/01/19,11:26,0,129,MEAN,86.562575366,17.138618253,72.190079365 126,02/01/19,11:26,0,129,STD,4.4198323625,5.1557816279,3.2852246717 126,02/01/19,12:25,0,120,N,120,120,120 126,02/01/19,12:25,0,120,MIN,79.5,7.371007371,68 126,02/01/19,12:25,0,120,MAX,99.142857143,27.52293578,77.333333333 Like this is ok? 🙂 ... View more

Create increasing variable from 1 to 7 and start again when some condt...

by Calcite | Level 5 in New SAS User
‎03-11-2019 06:34 AM
‎03-11-2019 06:34 AM
Hello,   I have a dataset that Looks like this:     I would like to assign an increasing number from 1 to 7 to a new variable when "Time_start_for" change (increase) and: -ID is the same -date_for is the same   when is done should start again with 1.   To explain me better: every ID (test subject) has on different Dates 7 different "sessions". The "Time_start_for" is not always the same for all the subjects. What I want is a new variable that indicate the session number.   Thank you!   Version: 9.4 ... View more

Re: Import files in one table and create a new variable corresponding ...

by Calcite | Level 5 in New SAS User
‎03-08-2019 08:27 AM
‎03-08-2019 08:27 AM
Thank you so much! that works! Just the position of the missing values is wrong and they are all shifted to the end. I've tried to add "DSD" after infile but didn't work.   Could you please help me with that?   ... View more

Re: Missing values are don't recognized correctly while importing TAB ...

by Calcite | Level 5 in New SAS User
‎03-08-2019 05:57 AM
‎03-08-2019 05:57 AM
Thank you very much! After modifying the variable's names it works. ... View more

Missing values are don't recognized correctly while importing TAB deli...

by Calcite | Level 5 in New SAS User
‎03-08-2019 05:45 AM
‎03-08-2019 05:45 AM
Hallo, I'm importing some TAB delimited .txt files to SAS. In the files some values are missing. Here  my code:   filename inn 'G:\***\**\*****\BBB101-07022019-0934.txt'; data innocor_full; infile inn dlm='09'x dsd firstobs=16; input Time Arbeitsbelastung HR Atemfrequenz Ve VCO2 VO2 R VO2/HR FO2et FCO2et Ve/VCO2 Ve/VO2 SpO2 VO2/kg VO2/BSA FiCO2 FiO2 Va Vt Vd Geschwindigkeit Steigung DIA SYS MAP VeVCO2slp VO2loadSlp CoVo2slp BRper FEV1 FVC PEF MEF75 MEF50 MEF25 FET FEV1per MVV heigth weight BSA Alter UmgDruck UmgTemp UmgFeucht cvp1 PO2 PCO2 pH BE HCO3; run; Whit this code I get wrongly all the missing values at the end like this:     this is wrong since most of the missing values are relatives to other variables. I tought this would have been solved writing the DSD Option.   Can someone help me spot the mistake?   Thank you! ... View more

Re: Import files in one table and create a new variable corresponding ...

by Calcite | Level 5 in New SAS User
‎03-07-2019 12:41 PM
‎03-07-2019 12:41 PM
Hi Ballardw,   many thanks for your answer. Here a sample of the data:   Innocor, von Innovision Dänemark "Pro Atemzug"-Daten -------------------------------------------------------------------- Nummer 101 Nachname ATL Vorname(n) - Größe 170.00 Gewicht 75.00 Geburtsdatum 01-01-1993 -------------------------------------------------------------------- Test durchgeführt: 07-02-2019 9:34:20 Time Arbeitsbelastung HR Atemfrequenz Ve VCO2 VO2 R VO2/HR FO2et FCO2et Ve/VCO2 Ve/VO2 SpO2 VO2/kg VO2/BSA FiCO2 FiO2 Va Vt Vd Geschwindigkeit Steigung DIA SYS MAP VeVCO2slp VO2loadSlp CoVo2slp BR% FEV1 FVC PEF MEF75 MEF50 MEF25 FET FEV1% MVV Größe Gewicht BSA Alter Umg. Druck Umg. Temp Umg. Feucht cvp1 PO2 PCO2 pH BE HCO3 Sec. l l l/s l/s l/s l/s s l/min m2 mmHg mmHg mmHg mmo/l mmol/l 5.71 0 86.6666666666667 19.6078431372549 13.6573671806811 0.262892022137917 0.33883954047642 0.775859929948794 3.90968700549715 15.22296875 4.29359375 44.4173806753726 34.4616658593035 98 4.5178605396856 181.824020006407 0.1275244140625 20.3928125 9.06877690623077 0.696525726214734 0.133018103996965 0 170 75 1.86355763371902 26 1000 23 30 10.09 0 85 13.6986301369863 9.79250804627849 0.200375356694935 0.252087805219194 0.794863347398759 2.9657388849317 15.42453125 4.266875 41.9659709713966 33.3572121631634 98 3.36117073625593 135.272341814357 0.152509765625 20.348125 6.58678059426528 0.71485308737833 0.133018103996965 0 170 75 1.86355763371902 26 1000 23 30 13.71 0 83 16.5745856353591 9.05946308217038 0.15993651903984 0.20800220455958 0.768917422671009 2.50605065734433 15.4421875 4.181171875 46.1772581855393 35.5064983500386 98 2.77336272746106 111.615654271169 0.13502685546875 20.449375 5.91460182939175 0.546587605957613 0.0887399622509773 0 170 75 1.86355763371902 26 1000 23 30 18.43 0 83 12.7118644067797 10.3474613736413 0.141691862890056 0.186458387481383 0.759911446215864 2.24648659616124 14.75 4.645859375 63.9667154040408 48.6090392123632 98 2.48611183308511 100.055068921735 0.15125 20.460625 7.9355127009594 0.81400029472645 0.0887399622509773 0 170 75 1.86355763371902 26 1000 23 30 22.98 0 83 13.1868131868132 9.74451086266263 0.306908637798289 0.409195717581188 0.750028958300121 4.93006888652034 14.73953125 4.649375 27.4109024468825 20.5589706083015 98 5.4559429010825 219.577709955003 0.14106201171875 20.3809375 7.242445426386 0.738958740418582 0.0887399622509773 0 170 75 1.86355763371902 26 1000 23 30 28.71 0 86 10.4712041884817 16.6853841328195 0.421930140115425 0.516634876987974 0.816689230458684 6.00738229055783 15.711875 4.16859375 37.0388152538892 30.2492015268001 98 6.88846502650632 277.230426169835 0.12505126953125 20.400625 13.5742336585385 1.59345418468426 0.196114870293837 0 170 75 1.86355763371902 26 1000 23 30 32.55 0 86 15.625 8.24244055898938 0.145907386894171 0.174955706742466 0.833967577341997 2.03436868305193 15.7828125 4.09828125 45.674970272911 38.0914443036673 98 2.33274275656621 93.8826380128175 0.13190673828125 20.383125 5.9099417191454 0.52751619577532 0.0482799257500143 0 170 75 1.86355763371902 26 1000 23 30 37.19 0 83 12.9310344827586 6.33536199328416 0.115180893738459 0.141365534203144 0.814773518790961 1.70319920726679 15.630625 4.193515625 43.6645987653613 35.5767587826489 98 1.88487378937525 75.8578815300854 0.1333447265625 20.4075 3.95109025976385 0.489934660813975 0.0833836807255711 0 170 75 1.86355763371902 26 1000 23 30 41.02 0 84.25 15.6657963446475 9.27962304197726 0.174840339772174 0.220832091373705 0.791734293166201 2.62115241986593 15.365625 4.310703125 44.0251810377281 34.8562455904197 98 2.94442788498273 118.500274624187 0.1366943359375 20.405625 5.92799698118713 0.592349270846215 0.112945463547104 0 170 75 1.86355763371902 26 1000 23 30 44.8 0 83.25 15.8730158730159 7.73802012702268 0.136018541716549 0.171822049451662 0.791624486790997 2.06392852194189 15.31515625 4.30796875 45.1030090929261 35.7046464259173 98 2.2909606593555 92.2010923315338 0.1810693359375 20.32 4.47852898733533 0.487495268002429 0.104347941800303 0 170 75 1.86355763371902 26 1000 23 30 48.59 0 82 15.8311345646438 8.59846051206866 0.1731244683582 0.22496604312773 0.769558222882129 2.74348833082598 15.12390625 4.42109375 40.4305410287667 31.1136553042607 98 2.99954724170307 120.718586351834 0.13092529296875 20.381875 5.77267654679437 0.543136089012337 0.0774953538064927 0 170 75 1.86355763371902 26 1000 23 30 52.41 0 82.75 15.7068062827225 7.49195576981453 0.130974990149388 0.170449970055112 0.768407234727231 2.05981836924607 15.1946875 4.334609375 45.0892825303805 34.6469309050045 98 2.27266626740149 91.4648235026422 0.1464404296875 20.3984375 4.83202530522098 0.476987850678192 0.0683489062457892 0 170 75 1.86355763371902 26 1000 23 30 56.24 0 83.3333333333333 15.6657963446475 7.6925697145026 0.150843269421084 0.198932105060424 0.758265084337525 2.38718526072509 15.12359375 4.363828125 40.5077688062835 30.7156267302215 98.3333333333333 2.65242806747232 106.748566001377 0.13260009765625 20.34375 5.01690741609424 0.491042366775749 0.0697964433817334 0 170 75 1.86355763371902 26 1000 23 30 60.07 0 84.5 15.6657963446475 7.93784638328618 0.151982715461823 0.20354391321647 0.746682684144864 2.40880370670379 14.87125 4.457578125 41.8179194467232 31.224716337833 98.25 2.71391884288627 109.22329931394 0.1471533203125 20.381875 5.35037533215779 0.506699194133101 0.0641669020970285 0 170 75 1.86355763371902 26 1000 23 30 65.49 0 84.6666666666667 20.4081632653061 17.0255707873831 0.200783612664238 0.275440619151741 0.728954259842213 3.25323565927253 14.531875 4.6703125 74.5297193282971 54.3287563892067 98 3.67254158868988 147.803649411183 0.13590087890625 20.39375 12.486941607484 0.834252968581772 0.121392829815057 0 170 75 1.86355763371902 26 1000 23 30 68.89 0 86 17.6470588235294 11.3930782575312 0.333199814561887 0.459969117329989 0.724396056187494 5.34847810848825 14.469375 4.69203125 28.8437294870394 20.8942838861503 98 6.13292156439986 246.823124226133 0.17279052734375 20.345625 6.83933769838043 0.64560776792677 0.157045298351879 0 170 75 1.86355763371902 26 1000 23 30 72.82 0 86.25 15.2671755725191 7.83379384352958 0.180980439336628 0.238380738694602 0.759207477616255 2.76383465153161 15.87734375 3.7822265625 34.7651333689285 26.3939492140169 98 3.17840984926135 127.917019780534 0.1843408203125 20.3628125 5.17344820401572 0.513113496751188 0.0732526393881581 0 170 75 1.86355763371902 26 1000 23 30 76.22 0 89.3333333333333 17.6470588235294 9.8939304919259 0.143981738900737 0.190769668141954 0.754741255793339 2.13548135979799 15.24046875 4.238046875 56.3375440016159 42.5202687080921 98 2.54359557522605 102.368536765478 0.1403125 20.36875 6.46309296003413 0.560656061209134 0.0934141268072006 0 170 75 1.86355763371902 26 1000 23 30 Those information on the top are needed but I thought it would be out of my SAS skills to include them. If it's possible to include them I would need: - Nummer (that's the same included in the filename) - Größe - Gewicht - Geburtsdatum - The Date and time after "Test durchgeführt:" (Those are also include in the filename)   The number of lines and the text in the heading section are always the same for all files. The number of lines of data differs beetwen files. My code worked correclty and the data are numeric.   Thank you,   Riccardo   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-26-2021 01:55 PM
Likes given to
View All
Quick links