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: 
Job04
‎10-04-2022
  • 51 Posts
  • 0 Likes Given
  • 1 Solutions
  • 4 Likes Received

Re: Changing subject's ID

by Quartz | Level 8 in SAS Programming
‎02-10-2022 08:01 AM
‎02-10-2022 08:01 AM
As you can see the IDs are not sequential perhaps some subjects were exluded from the  study. I would like to  identify subjects by their numbers in the study and not by this long and confusing ID. I have another column that specifies the time of measurement (S1,S3  and S5) which I can use in my modeling. For example these 3 measurements of patient 002 I want to have 3  records called 002. In other word, I want to leave only the three digits to the far right of this long ID. I hope I answered your question.   ... View more

Changing subject's ID

by Quartz | Level 8 in SAS Programming
‎02-10-2022 06:59 AM
‎02-10-2022 06:59 AM
This is a subset of a larger data. The data was generated by a biochemist and I have an issue with the subjects' IDs.    "METAPH" is the name of the study. Subjects are  measured at 3 occasions (S1-1, S3-1 and S5-1). The subject's ID is as follow: occasion-study'name-subject. For example the first subject has 3 IDs corresponding to the 3 measurements: S1-1-METAPH-002 S3-1-METAPH-002 S5-1-METAPH-002   Data looks like it was manually entered:    SUBJECT S1-1-METAPH-002 S1-1-METAPH-019 S1-1-METAPH-089 S1-1-METAPH-027 S1-1-METAPH-006 S1-1-METAPH-007 S1-1-METAPH-008 S1-1-METAPH-003 S3-1-METAPH-027 S3-1-METAPH-008 S3-1-METAPH-089 S3-1-METAPH-003 S3-1-METAPH-002 S3-1-METAPH-006 S3-1-METAPH-007 S3-1-METAPH-019 S5-1-METAPH-002 S5-1-METAPH-003 S5-1-METAPH-027 S5-1-METAPH-089 S5-1-METAPH-006 S5-1-METAPH-019 S5-1-METAPH-008 S5-1-METAPH-007   I would like to replace  these 3 IDs by only one, which is 1, and the data to look like:     1 1 1 2 2 2 ...   Thank you     ... View more

Re: Recoding categorical variable

by Quartz | Level 8 in SAS Programming
‎12-02-2021 04:11 PM
‎12-02-2021 04:11 PM
Variable will be used in certain model as predictor. Actually I run the model using the original variable and I got weird results. So I want to recode  the variable  either by creating new variable or just replacing it.  ... View more

Recoding categorical variable

by Quartz | Level 8 in SAS Programming
‎12-02-2021 03:34 PM
‎12-02-2021 03:34 PM
I have categorical  variable ( string variable) with 3 levels: one, two and three. I would like to  recode this variable to have these levels as 1, 2 and 3.  Thank you ... View more

Converting measurement occasions to numbers

by Quartz | Level 8 in SAS Programming
‎11-29-2021 05:58 PM
‎11-29-2021 05:58 PM
I have bi-weekly measurements and in total 23 measurements per country. I want to convert the days of measurements which corresponds to days in  months to simply numbering these measurement occasions from 1 to 23 for all countries. I want them to be categorical. Thank you.     location,day Austria,14 Austria,28 Austria,11 Austria,25 Austria,11 Austria,25 Austria,8 Austria,22 Austria,6 Austria,20 Austria,3 Austria,17 Austria,1 Austria,15 Austria,29 Austria,12 Austria,26 Austria,9 Austria,23 Austria,7 Austria,21 Austria,4 Austria,18 Belgium,14 Belgium,28 Belgium,11 Belgium,25 Belgium,11 Belgium,25 Belgium,8 Belgium,22 Belgium,6 Belgium,20 Belgium,3 Belgium,17 Belgium,1 Belgium,15 Belgium,29 Belgium,12 Belgium,26 Belgium,9 Belgium,23 Belgium,7 Belgium,21 Belgium,4 Belgium,18 Bulgari,14 Bulgari,28 Bulgari,11 Bulgari,25 Bulgari,11 Bulgari,25 Bulgari,8 Bulgari,22 Bulgari,6 Bulgari,20 Bulgari,3 Bulgari,17 Bulgari,1 Bulgari,15 Bulgari,29 Bulgari,12 Bulgari,26 Bulgari,9 Bulgari,23 Bulgari,7 Bulgari,21 Bulgari,4 Bulgari,18 ... View more

Re: Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-29-2021 05:33 PM
‎11-29-2021 05:33 PM
This imports everything but  variables continent and location are messed up.        ... View more

Re: Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-26-2021 03:23 PM
‎11-26-2021 03:23 PM
Data is from here: https://github.com/owid/covid-19-data/tree/master/public/data I'm intrested only in these variables:  location date new_cases_per_million new_deaths_per_million weekly_hosp_admissions_per_million people_fully_vaccinated stringency_index population ... View more

Re: Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-26-2021 03:21 PM
‎11-26-2021 03:21 PM
Data is csv. Saved it as text format then copied and pasted it here.    Data is from here: https://github.com/owid/covid-19-data/tree/master/public/data I'm intrested only in these variables:  location date new_cases_per_million new_deaths_per_million weekly_hosp_admissions_per_million people_fully_vaccinated stringency_index population ... View more

Re: Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-26-2021 12:11 PM
‎11-26-2021 12:11 PM
Austria 231.78 4.313 82.41 9043072 Austria 153.819 1.548 82.41 9043072 Austria 162.113 5.419 82.41 9043072 Austria 181.575 3.649 82.41 9043072 Austria 255.555 11.058 82.41 9043072 Austria 273.027 7.52 82.41 9043072 Austria 280.878 4.755 82.41 9043072 Austria 228.13 8.072 82.41 9043072 Austria 251.906 5.087 82.41 9043072 Austria 182.571 3.981 82.41 9043072 Austria 169.854 2.654 82.41 9043072 Austria 174.166 7.962 82.41 9043072 Austria 211.985 5.419 82.41 9043072 Austria 388.142 5.861 82.41 9043072 Austria 168.969 7.298 82.41 9043072 Austria 190.533 7.298 12 82.41 9043072 Austria 140.107 3.207 394 82.41 9043072 Austria 128.386 4.423 1307 82.41 9043072 Austria 164.325 8.515 2807 82.41 9043072 Austria 184.782 4.202 4132 82.41 9043072 Austria 188.21 5.64 4306 82.41 9043072 Austria 230.895 4.644 4914 82.41 9043072 Austria 179.806 6.524 4919 82.41 9043072 Austria 132.919 3.207 4931 82.41 9043072 Austria 111.577 3.649 5049 82.41 9043072 Austria 156.695 7.077 5974 82.41 9043072 Austria 181.465 5.419 6512 82.41 9043072 Austria 160.233 4.755 9202 82.41 9043072 Austria 165.873 5.64 19008 82.41 9043072 Austria 719.446 2.212 5650776 57.41 9043072 Austria 950.341 2.101 5660006 57.41 9043072 Austria 1038.143 3.539 5671516 57.41 9043072 Austria 1099.516 3.428 5677339 57.41 9043072 Austria 945.917 2.212 5679691 57.41 9043072 Austria 904.339 1.438 5686359 49.07 9043072 Austria 852.808 4.313 5695643 49.07 9043072 Austria 1260.412 2.543 5705493 49.07 9043072 Austria 1324.218 2.654 5717671 49.07 9043072 Austria 1304.645 4.423 5732401 49.07 9043072 Austria 1454.373 5.308 5741822 49.07 9043072 Austria 1277.442 1.88 5746307 49.07 9043072 Austria 1314.708 4.423 5755649 59.26 9043072 Austria 1145.96 6.745 5767024 59.26 9043072 Austria 1594.149 4.534 5779929 59.26 9043072 Austria 1674.763 6.082 5793907 59.26 9043072 Austria 1748.189 5.308 5812738 59.26 9043072 Belgium 222.053 4.384 1480 60.19 11632334 Belgium 155.773 4.556 86.006 1504 60.19 11632334 Belgium 102.473 3.009 1550 60.19 11632334 Belgium 153.366 5.588 3349 60.19 11632334 Belgium 259.621 4.642 6842 62.96 11632334 Belgium 238.559 4.212 14807 62.96 11632334 Belgium 230.65 3.095 24040 62.96 11632334 Belgium 233.573 4.126 26974 62.96 11632334 Belgium 199.1 2.235 72.641 27325 62.96 11632334 Belgium 108.663 2.751 31315 62.96 11632334 Belgium 159.383 4.212 45807 62.96 11632334 Belgium 268.562 3.697 66663 62.96 11632334 Belgium 210.792 3.783 91177 62.96 11632334 Belgium 222.225 3.009 114301 62.96 11632334 Belgium 209.588 4.9 119661 62.96 11632334 Belgium 149.583 3.181 80.538 122766 62.96 11632334 Belgium 75.049 2.923 130702 62.96 11632334 Belgium 159.125 4.212 150636 62.96 11632334 Belgium 224.976 3.439 169931 62.96 11632334 Belgium 1584.979 3.439 8647984 45.83 11632334 Belgium 1435.567 3.611 8652215 45.83 11632334 Belgium 1848.468 3.611 8655713 11632334 Belgium 0 0 8658714 11632334 Belgium 0 0 8658729 11632334 Bulgaria 39.729 4.06 53.7 6896655 Bulgaria 49.299 5.8 53.7 6896655 Bulgaria 24.795 4.93 53.7 6896655 Bulgaria 149.203 22.765 53.7 6896655 Bulgaria 189.947 9.715 53.7 6896655 Bulgaria 145.288 8.555 53.7 6896655 Bulgaria 125.713 8.12 53.7 6896655 Bulgaria 109.183 8.845 53.7 6896655 Bulgaria 57.129 2.755 53.7 6896655 Bulgaria 15.225 4.205 53.7 6896655 Bulgaria 89.899 15.37 53.7 6896655 Bulgaria 108.748 6.815 53.7 6896655 Bulgaria 77.574 10.15 53.7 6896655 Bulgaria 77.574 6.815 53.7 6896655 Bulgaria 80.039 8.845 53.7 6896655 Bulgaria 33.784 2.465 53.7 6896655 Bulgaria 11.165 1.305 53.7 6896655 Bulgaria 82.649 11.89 1114 53.7 6896655 Bulgaria 78.879 7.105 3168 53.7 6896655 Bulgaria 69.889 5.365 4293 53.7 6896655 Bulgaria 65.974 13.05 4532 53.7 6896655 Croatia 166.599 5.39 1777373 37.96 4081657 Croatia 823.195 7.35 1781470 37.96 4081657 Croatia 1119.888 6.37 37.96 4081657 Croatia 1017.724 6.37 1791056 37.96 4081657 Croatia 1076.034 6.37 1795287 37.96 4081657 Croatia 1114.008 7.35 37.96 4081657 Croatia 813.15 5.39 275.987 1798069 37.96 4081657 Croatia 275.868 7.595 1798141 37.96 4081657 Croatia 192.324 9.8 1802284 37.96 4081657 Croatia 1120.378 10.045 1806387 37.96 4081657 Croatia 1545.941 7.84 1811801 37.96 4081657 Croatia 1698.33 8.82 1816377 37.96 4081657 Croatia 1738.02 12.25 1820138 37.96 4081657 Croatia 1018.949 12.25 397.224 37.96 4081657 Croatia 304.288 11.27 37.96 4081657 Croatia 1216.663 14.455 1831401 37.96 4081657 Croatia 1792.164 12.25 1837846 35.19 4081657 Croatia 1711.805 16.17 35.19 4081657 Cyprus 148.437 2.232 10024 80.56 896005 Cyprus 147.321 1.116 78.828 80.56 896005 Cyprus 128.347 1.116 80.56 896005 Cyprus 117.187 2.232 80.56 896005 Cyprus 106.026 0 80.56 896005 Cyprus 126.115 3.348 80.56 896005 Cyprus 114.955 1.116 80.56 896005 Cyprus 126.115 1.116 14837 80.56 896005 Cyprus 113.839 1.116 60.81 80.56 896005 Cyprus 137.276 1.116 80.56 896005 Cyprus 126.115 1.116 80.56 896005 Cyprus 90.401 3.348 80.56 896005 Cyprus 135.044 2.232 80.56 896005 Cyprus 119.419 1.116 80.56 896005 Cyprus 123.883 1.116 19221 80.56 896005 Cyprus 119.419 0 74.324 80.56 896005 Cyprus 119.419 0 80.56 896005 Cyprus 146.205 1.116 20323 80.56 896005 Estonia 95.081 0 39.128 582191 23.15 1325188 Estonia 110.928 0 585027 23.15 1325188 Estonia 218.082 0 588215 23.15 1325188 Estonia 259.586 1.509 591022 23.15 1325188 Estonia 280.715 0 593767 23.15 1325188 Estonia 205.254 0 596814 23.15 1325188 Estonia 218.837 0 599331 23.15 1325188 Estonia 152.431 0 54.177 600479 23.15 1325188 Estonia 123.001 0 603458 23.15 1325188 Estonia 270.905 0 606080 23.15 1325188 Estonia 215.818 1.509 608764 23.15 1325188 Estonia 269.396 0 612119 23.15 1325188 Estonia 249.776 0 612873 23.15 1325188 Estonia 164.505 0 614153 23.15 1325188 Estonia 76.216 0 54.93 614585 23.15 1325188 Estonia 240.721 3.018 616794 23.15 1325188 Estonia 282.224 0 619135 23.15 1325188 Estonia 329.765 0 621748 23.15 1325188 Estonia 304.862 0.755 623866 28.7 1325188 Estonia 264.868 0.755 626465 28.7 1325188 Estonia 242.984 0 628411 28.7 1325188 Estonia 249.021 1.509 85.028 630605 28.7 1325188 France 549.521 1.939 180.481 2670306 68.52 67564251 France 134.775 5.328 2724543 68.52 67564251 France 454.723 5.639 2794128 68.52 67564251 France 873.983 4.485 2866986 68.52 67564251 France 750.042 4.559 2954702 68.52 67564251 France 690.942 4.914 3046736 68.52 67564251 France 2.457 2.753 3108520 68.52 67564251 France 1193.457 2.738 194.147 3127164 68.52 67564251 France 159.744 2.916 3138148 71.3 67564251 France 119.235 6.305 3245894 75 67564251 France 13.72 6.231 3361248 75 67564251 France 1436.159 5.077 3482576 75 67564251 France 2.427 4.899 3598966 75 67564251 France 20.78 3.064 3681655 75 67564251 France 1745.035 2.605 195.588 3716216 75 67564251 France 126.546 5.698 3831334 75 67564251 France 579.152 5.106 3976163 75 67564251 Greece 370.465 7.714 268.04 6464917 10370747 Greece 670.154 6.943 6472459 10370747 Greece 806.499 8.196 6481011 10370747 Greece 641.516 8.582 6489186 10370747 Greece 701.589 6.075 6493402 10370747 Greece 747.391 8.968 6502689 10370747 Greece 573.151 6.653 6512821 10370747 Greece 396.114 7.328 6513709 10370747 Hungary 286.896 13.494 72.22 9634162 Hungary 146.354 11.833 72.22 9634162 Hungary 135.663 10.691 72.22 9634162 Hungary 88.85 9.653 72.22 9634162 Hungary 90.304 10.691 72.22 9634162 Hungary 212.473 12.248 72.22 9634162 Hungary 318.45 13.182 72.22 9634162 Hungary 301.739 11.937 72.22 9634162 Hungary 281.913 11.833 72.22 9634162 Hungary 184.552 9.757 72.22 9634162 Hungary 147.288 7.992 72.22 9634162 Ireland 636.978 11.238 3756681 48.15 4982904 Ireland 606.875 0 3757883 48.15 4982904 Ireland 783.278 0 3758869 48.15 4982904 Ireland 739.529 0 3760182 48.15 4982904 Ireland 687.952 0 74.933 3760944 48.15 4982904 Ireland 634.369 0 3761410 48.15 4982904 Ireland 1069.858 0 3762380 48.15 4982904 Ireland 595.637 14.851 3763636 48.15 4982904 Ireland 737.923 0 3764659 48.15 4982904 Ireland 1099.359 0 3765681 48.15 4982904 Ireland 931.585 0 3766990 48.15 4982904 Ireland 763.611 0 102.328 3768771 48.15 4982904 Ireland 0 0 3769282 48.15 4982904 Ireland 1799.152 0 3770261 48.15 4982904 Ireland 728.892 8.63 3771253 48.15 4982904 Ireland 932.388 0 3773593 48.15 4982904 Ireland 628.75 0 3774917 48.15 4982904 Ireland 1195.889 0 3777756 48.15 4982904 Ireland 839.069 0 3780486 4982904 Italy 367.913 7.653 82.41 60367471 Italy 195.884 6.03 82.41 60367471 Italy 235.971 5.748 154.188 82.41 60367471 Italy 178.871 5.765 9 82.41 60367471 Luxembourg 0 0 17.569 41.67 634814 Luxembourg 389.09 0 41.67 634814 Luxembourg 211.085 0 41.67 634814 Luxembourg 185.881 0 41.67 634814 Luxembourg 193.758 0 41.67 634814 Luxembourg 200.059 1.575 41.67 634814 Luxembourg 0 0 41.67 634814 Luxembourg 0 0 28.749 41.67 634814 Luxembourg 356.01 1.575 41.67 634814 Luxembourg 140.199 0 37.96 634814 Luxembourg 222.112 0 37.96 634814 Luxembourg 148.075 0 37.96 634814 Luxembourg 162.252 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 23.958 37.96 634814 Luxembourg 218.962 1.575 37.96 634814 Luxembourg 135.473 0 37.96 634814 Luxembourg 168.553 0 37.96 634814 Luxembourg 113.419 0 37.96 634814 Luxembourg 85.064 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 15.972 37.96 634814 Luxembourg 189.032 0 37.96 634814 Luxembourg 81.914 0 37.96 634814 Luxembourg 160.677 3.151 37.96 634814 Luxembourg 107.118 0 37.96 634814 Luxembourg 78.763 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 11.18 37.96 634814 Luxembourg 209.51 1.575 37.96 634814 Luxembourg 66.161 0 37.96 634814 Luxembourg 96.091 3.151 37.96 634814 Luxembourg 74.037 0 37.96 634814 Luxembourg 78.763 1.575 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 19.166 37.96 634814 Luxembourg 149.65 0 37.96 634814 Luxembourg 140.199 0 37.96 634814 Luxembourg 119.72 1.575 37.96 634814 Luxembourg 99.242 1.575 37.96 634814 Malta 499.903 3.875 25118 52.78 516100 Malta 459.213 0 26781 52.78 516100 Malta 509.591 3.875 42.755 28048 52.78 516100 Malta 339.082 1.938 29021 52.78 516100 Malta 651.037 5.813 29748 52.78 516100 Malta 451.463 3.875 30329 52.78 516100 Malta 701.414 7.75 31034 52.78 516100 Malta 548.343 5.813 31710 52.78 516100 Malta 668.475 1.938 32420 52.78 516100 Malta 352.645 9.688 132.151 32862 52.78 516100 Netherlands 315.668 2.912 75 17173094 Netherlands 356.546 1.514 75 17173094 Netherlands 381.003 1.339 75 17173094 Netherlands 352.412 1.398 75.886 454352 75 17173094 Netherlands 321.782 1.048 75 17173094 Netherlands 294.996 1.922 75 17173094 Netherlands 357.536 2.737 75 17173094 Netherlands 369.066 1.98 75 17173094 Netherlands 441.213 2.737 75 17173094 Netherlands 455.655 0.932 75 17173094 Netherlands 417.106 0.932 86.801 582058 75 17173094 Netherlands 191.288 0.524 41.67 17173094 Netherlands 151.341 0.524 41.67 17173094 Netherlands 142.49 0.175 25.449 10606168 41.67 17173094 Netherlands 123.216 0.116 41.67 17173094 Slovakia 12.269 0 2053645 43.98 5460726 Slovakia 9.889 0 0.366 2058694 43.98 5460726 Slovakia 6.043 0 2067552 43.98 5460726 Slovakia 21.792 0.366 2075531 43.98 5460726 Slovakia 17.763 0.183 2085437 43.98 5460726 Slovakia 17.397 0 2094292 43.98 5460726 Slovakia 15.566 0 2102941 43.98 5460726 Slovakia 23.44 0 2106982 43.98 5460726 Slovakia 17.397 0 1.832 2108725 43.98 5460726 Slovakia 5.128 0 2114144 34.72 5460726 Slovakia 21.792 0.366 2118979 34.72 5460726 Slovakia 25.088 0.183 2124990 34.72 5460726 Spain 0 0 71.3 46745211 Spain 0 0 160.798 1070091 71.3 46745211 Spain 647.147 15.018 1096922 71.3 46745211 Spain 215.145 11.338 1119180 71.3 46745211 Spain 231.66 7.209 1144556 71.3 46745211 Spain 310.513 8.3 1171026 71.3 46745211 Spain 244.624 8.493 68.52 46745211 Spain 0 0 68.52 46745211 Spain 0 0 107.072 1197061 68.52 46745211 Spain 446.014 11.445 1208305 68.52 46745211 Spain 159.61 9.477 1221183 68.52 46745211 Spain 197.068 8.322 1231782 68.52 46745211 Spain 204.684 7.38 1243783 68.52 46745211 Spain 178.435 7.038 68.52 46745211 Spain 0 0 68.52 46745211 Spain 0 0 83.41 1261848 68.52 46745211 Spain 341.81 9.99 1266700 68.52 46745211 Spain -1590.473 4.107 1287002 68.52 46745211 Spain 131.286 9.541 1308913 68.52 46745211 Switzerland 0 3.213 48.534 46369 60.19 8715494 Switzerland 376.341 -9.982 54890 60.19 8715494 Switzerland 156.388 15.031 65949 60.19 8715494 Switzerland 183.811 2.868 76123 60.19 8715494 Switzerland 155.585 1.606 87350 60.19 8715494 Switzerland 143.767 1.836 97493 60.19 8715494 Switzerland 0 2.295 101039 60.19 8715494 Switzerland 0 2.065 37.749 101543 60.19 8715494 Switzerland 284.551 2.18 110510 60.19 8715494 Switzerland 0 0 33.848 5660446 8715494 United Kingdom 783.76 9.017 79.63 68207114 United Kingdom 848.196 6.524 79.63 68207114 United Kingdom 808.669 6.671 338.088 79.63 68207114 United Kingdom 863.883 6.011 79.63 68207114 United Kingdom 895.61 12.917 87.96 68207114 United Kingdom 917.148 15.277 87.96 68207114 United Kingdom 773.922 17.036 87.96 68207114 United Kingdom 999.778 19.543 87.96 68207114 United Kingdom 881.11 15.174 87.96 68207114 United Kingdom 806.749 8.313 422.302 391399 87.96 68207114 United Kingdom 678.448 7.756 412167 87.96 68207114 United Kingdom 669.256 18.268 428232 87.96 68207114 United Kingdom 698.783 22.989 437977 87.96 68207114 United Kingdom 715.527 18.371 443234 87.96 68207114 United Kingdom 819.343 18.84 447442 87.96 68207114 United Kingdom 607.385 19.045 450062 87.96 68207114 United Kingdom 566.95 9.999 419.223 452301 87.96 68207114 ... View more

Re: Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-26-2021 12:09 PM
‎11-26-2021 12:09 PM
I tried that code and it didn't work.   Austria 231.78 4.313 82.41 9043072 Austria 153.819 1.548 82.41 9043072 Austria 162.113 5.419 82.41 9043072 Austria 181.575 3.649 82.41 9043072 Austria 255.555 11.058 82.41 9043072 Austria 273.027 7.52 82.41 9043072 Austria 280.878 4.755 82.41 9043072 Austria 228.13 8.072 82.41 9043072 Austria 251.906 5.087 82.41 9043072 Austria 182.571 3.981 82.41 9043072 Austria 169.854 2.654 82.41 9043072 Austria 174.166 7.962 82.41 9043072 Austria 211.985 5.419 82.41 9043072 Austria 388.142 5.861 82.41 9043072 Austria 168.969 7.298 82.41 9043072 Austria 190.533 7.298 12 82.41 9043072 Austria 140.107 3.207 394 82.41 9043072 Austria 128.386 4.423 1307 82.41 9043072 Austria 164.325 8.515 2807 82.41 9043072 Austria 184.782 4.202 4132 82.41 9043072 Austria 188.21 5.64 4306 82.41 9043072 Austria 230.895 4.644 4914 82.41 9043072 Austria 179.806 6.524 4919 82.41 9043072 Austria 132.919 3.207 4931 82.41 9043072 Austria 111.577 3.649 5049 82.41 9043072 Austria 156.695 7.077 5974 82.41 9043072 Austria 181.465 5.419 6512 82.41 9043072 Austria 160.233 4.755 9202 82.41 9043072 Austria 165.873 5.64 19008 82.41 9043072 Austria 719.446 2.212 5650776 57.41 9043072 Austria 950.341 2.101 5660006 57.41 9043072 Austria 1038.143 3.539 5671516 57.41 9043072 Austria 1099.516 3.428 5677339 57.41 9043072 Austria 945.917 2.212 5679691 57.41 9043072 Austria 904.339 1.438 5686359 49.07 9043072 Austria 852.808 4.313 5695643 49.07 9043072 Austria 1260.412 2.543 5705493 49.07 9043072 Austria 1324.218 2.654 5717671 49.07 9043072 Austria 1304.645 4.423 5732401 49.07 9043072 Austria 1454.373 5.308 5741822 49.07 9043072 Austria 1277.442 1.88 5746307 49.07 9043072 Austria 1314.708 4.423 5755649 59.26 9043072 Austria 1145.96 6.745 5767024 59.26 9043072 Austria 1594.149 4.534 5779929 59.26 9043072 Austria 1674.763 6.082 5793907 59.26 9043072 Austria 1748.189 5.308 5812738 59.26 9043072 Belgium 222.053 4.384 1480 60.19 11632334 Belgium 155.773 4.556 86.006 1504 60.19 11632334 Belgium 102.473 3.009 1550 60.19 11632334 Belgium 153.366 5.588 3349 60.19 11632334 Belgium 259.621 4.642 6842 62.96 11632334 Belgium 238.559 4.212 14807 62.96 11632334 Belgium 230.65 3.095 24040 62.96 11632334 Belgium 233.573 4.126 26974 62.96 11632334 Belgium 199.1 2.235 72.641 27325 62.96 11632334 Belgium 108.663 2.751 31315 62.96 11632334 Belgium 159.383 4.212 45807 62.96 11632334 Belgium 268.562 3.697 66663 62.96 11632334 Belgium 210.792 3.783 91177 62.96 11632334 Belgium 222.225 3.009 114301 62.96 11632334 Belgium 209.588 4.9 119661 62.96 11632334 Belgium 149.583 3.181 80.538 122766 62.96 11632334 Belgium 75.049 2.923 130702 62.96 11632334 Belgium 159.125 4.212 150636 62.96 11632334 Belgium 224.976 3.439 169931 62.96 11632334 Belgium 1584.979 3.439 8647984 45.83 11632334 Belgium 1435.567 3.611 8652215 45.83 11632334 Belgium 1848.468 3.611 8655713 11632334 Belgium 0 0 8658714 11632334 Belgium 0 0 8658729 11632334 Bulgaria 39.729 4.06 53.7 6896655 Bulgaria 49.299 5.8 53.7 6896655 Bulgaria 24.795 4.93 53.7 6896655 Bulgaria 149.203 22.765 53.7 6896655 Bulgaria 189.947 9.715 53.7 6896655 Bulgaria 145.288 8.555 53.7 6896655 Bulgaria 125.713 8.12 53.7 6896655 Bulgaria 109.183 8.845 53.7 6896655 Bulgaria 57.129 2.755 53.7 6896655 Bulgaria 15.225 4.205 53.7 6896655 Bulgaria 89.899 15.37 53.7 6896655 Bulgaria 108.748 6.815 53.7 6896655 Bulgaria 77.574 10.15 53.7 6896655 Bulgaria 77.574 6.815 53.7 6896655 Bulgaria 80.039 8.845 53.7 6896655 Bulgaria 33.784 2.465 53.7 6896655 Bulgaria 11.165 1.305 53.7 6896655 Bulgaria 82.649 11.89 1114 53.7 6896655 Bulgaria 78.879 7.105 3168 53.7 6896655 Bulgaria 69.889 5.365 4293 53.7 6896655 Bulgaria 65.974 13.05 4532 53.7 6896655 Croatia 166.599 5.39 1777373 37.96 4081657 Croatia 823.195 7.35 1781470 37.96 4081657 Croatia 1119.888 6.37 37.96 4081657 Croatia 1017.724 6.37 1791056 37.96 4081657 Croatia 1076.034 6.37 1795287 37.96 4081657 Croatia 1114.008 7.35 37.96 4081657 Croatia 813.15 5.39 275.987 1798069 37.96 4081657 Croatia 275.868 7.595 1798141 37.96 4081657 Croatia 192.324 9.8 1802284 37.96 4081657 Croatia 1120.378 10.045 1806387 37.96 4081657 Croatia 1545.941 7.84 1811801 37.96 4081657 Croatia 1698.33 8.82 1816377 37.96 4081657 Croatia 1738.02 12.25 1820138 37.96 4081657 Croatia 1018.949 12.25 397.224 37.96 4081657 Croatia 304.288 11.27 37.96 4081657 Croatia 1216.663 14.455 1831401 37.96 4081657 Croatia 1792.164 12.25 1837846 35.19 4081657 Croatia 1711.805 16.17 35.19 4081657 Cyprus 148.437 2.232 10024 80.56 896005 Cyprus 147.321 1.116 78.828 80.56 896005 Cyprus 128.347 1.116 80.56 896005 Cyprus 117.187 2.232 80.56 896005 Cyprus 106.026 0 80.56 896005 Cyprus 126.115 3.348 80.56 896005 Cyprus 114.955 1.116 80.56 896005 Cyprus 126.115 1.116 14837 80.56 896005 Cyprus 113.839 1.116 60.81 80.56 896005 Cyprus 137.276 1.116 80.56 896005 Cyprus 126.115 1.116 80.56 896005 Cyprus 90.401 3.348 80.56 896005 Cyprus 135.044 2.232 80.56 896005 Cyprus 119.419 1.116 80.56 896005 Cyprus 123.883 1.116 19221 80.56 896005 Cyprus 119.419 0 74.324 80.56 896005 Cyprus 119.419 0 80.56 896005 Cyprus 146.205 1.116 20323 80.56 896005 Estonia 95.081 0 39.128 582191 23.15 1325188 Estonia 110.928 0 585027 23.15 1325188 Estonia 218.082 0 588215 23.15 1325188 Estonia 259.586 1.509 591022 23.15 1325188 Estonia 280.715 0 593767 23.15 1325188 Estonia 205.254 0 596814 23.15 1325188 Estonia 218.837 0 599331 23.15 1325188 Estonia 152.431 0 54.177 600479 23.15 1325188 Estonia 123.001 0 603458 23.15 1325188 Estonia 270.905 0 606080 23.15 1325188 Estonia 215.818 1.509 608764 23.15 1325188 Estonia 269.396 0 612119 23.15 1325188 Estonia 249.776 0 612873 23.15 1325188 Estonia 164.505 0 614153 23.15 1325188 Estonia 76.216 0 54.93 614585 23.15 1325188 Estonia 240.721 3.018 616794 23.15 1325188 Estonia 282.224 0 619135 23.15 1325188 Estonia 329.765 0 621748 23.15 1325188 Estonia 304.862 0.755 623866 28.7 1325188 Estonia 264.868 0.755 626465 28.7 1325188 Estonia 242.984 0 628411 28.7 1325188 Estonia 249.021 1.509 85.028 630605 28.7 1325188 France 549.521 1.939 180.481 2670306 68.52 67564251 France 134.775 5.328 2724543 68.52 67564251 France 454.723 5.639 2794128 68.52 67564251 France 873.983 4.485 2866986 68.52 67564251 France 750.042 4.559 2954702 68.52 67564251 France 690.942 4.914 3046736 68.52 67564251 France 2.457 2.753 3108520 68.52 67564251 France 1193.457 2.738 194.147 3127164 68.52 67564251 France 159.744 2.916 3138148 71.3 67564251 France 119.235 6.305 3245894 75 67564251 France 13.72 6.231 3361248 75 67564251 France 1436.159 5.077 3482576 75 67564251 France 2.427 4.899 3598966 75 67564251 France 20.78 3.064 3681655 75 67564251 France 1745.035 2.605 195.588 3716216 75 67564251 France 126.546 5.698 3831334 75 67564251 France 579.152 5.106 3976163 75 67564251 Greece 370.465 7.714 268.04 6464917 10370747 Greece 670.154 6.943 6472459 10370747 Greece 806.499 8.196 6481011 10370747 Greece 641.516 8.582 6489186 10370747 Greece 701.589 6.075 6493402 10370747 Greece 747.391 8.968 6502689 10370747 Greece 573.151 6.653 6512821 10370747 Greece 396.114 7.328 6513709 10370747 Hungary 286.896 13.494 72.22 9634162 Hungary 146.354 11.833 72.22 9634162 Hungary 135.663 10.691 72.22 9634162 Hungary 88.85 9.653 72.22 9634162 Hungary 90.304 10.691 72.22 9634162 Hungary 212.473 12.248 72.22 9634162 Hungary 318.45 13.182 72.22 9634162 Hungary 301.739 11.937 72.22 9634162 Hungary 281.913 11.833 72.22 9634162 Hungary 184.552 9.757 72.22 9634162 Hungary 147.288 7.992 72.22 9634162 Ireland 636.978 11.238 3756681 48.15 4982904 Ireland 606.875 0 3757883 48.15 4982904 Ireland 783.278 0 3758869 48.15 4982904 Ireland 739.529 0 3760182 48.15 4982904 Ireland 687.952 0 74.933 3760944 48.15 4982904 Ireland 634.369 0 3761410 48.15 4982904 Ireland 1069.858 0 3762380 48.15 4982904 Ireland 595.637 14.851 3763636 48.15 4982904 Ireland 737.923 0 3764659 48.15 4982904 Ireland 1099.359 0 3765681 48.15 4982904 Ireland 931.585 0 3766990 48.15 4982904 Ireland 763.611 0 102.328 3768771 48.15 4982904 Ireland 0 0 3769282 48.15 4982904 Ireland 1799.152 0 3770261 48.15 4982904 Ireland 728.892 8.63 3771253 48.15 4982904 Ireland 932.388 0 3773593 48.15 4982904 Ireland 628.75 0 3774917 48.15 4982904 Ireland 1195.889 0 3777756 48.15 4982904 Ireland 839.069 0 3780486 4982904 Italy 367.913 7.653 82.41 60367471 Italy 195.884 6.03 82.41 60367471 Italy 235.971 5.748 154.188 82.41 60367471 Italy 178.871 5.765 9 82.41 60367471 Luxembourg 0 0 17.569 41.67 634814 Luxembourg 389.09 0 41.67 634814 Luxembourg 211.085 0 41.67 634814 Luxembourg 185.881 0 41.67 634814 Luxembourg 193.758 0 41.67 634814 Luxembourg 200.059 1.575 41.67 634814 Luxembourg 0 0 41.67 634814 Luxembourg 0 0 28.749 41.67 634814 Luxembourg 356.01 1.575 41.67 634814 Luxembourg 140.199 0 37.96 634814 Luxembourg 222.112 0 37.96 634814 Luxembourg 148.075 0 37.96 634814 Luxembourg 162.252 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 23.958 37.96 634814 Luxembourg 218.962 1.575 37.96 634814 Luxembourg 135.473 0 37.96 634814 Luxembourg 168.553 0 37.96 634814 Luxembourg 113.419 0 37.96 634814 Luxembourg 85.064 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 15.972 37.96 634814 Luxembourg 189.032 0 37.96 634814 Luxembourg 81.914 0 37.96 634814 Luxembourg 160.677 3.151 37.96 634814 Luxembourg 107.118 0 37.96 634814 Luxembourg 78.763 0 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 11.18 37.96 634814 Luxembourg 209.51 1.575 37.96 634814 Luxembourg 66.161 0 37.96 634814 Luxembourg 96.091 3.151 37.96 634814 Luxembourg 74.037 0 37.96 634814 Luxembourg 78.763 1.575 37.96 634814 Luxembourg 0 0 37.96 634814 Luxembourg 0 0 19.166 37.96 634814 Luxembourg 149.65 0 37.96 634814 Luxembourg 140.199 0 37.96 634814 Luxembourg 119.72 1.575 37.96 634814 Luxembourg 99.242 1.575 37.96 634814 Malta 499.903 3.875 25118 52.78 516100 Malta 459.213 0 26781 52.78 516100 Malta 509.591 3.875 42.755 28048 52.78 516100 Malta 339.082 1.938 29021 52.78 516100 Malta 651.037 5.813 29748 52.78 516100 Malta 451.463 3.875 30329 52.78 516100 Malta 701.414 7.75 31034 52.78 516100 Malta 548.343 5.813 31710 52.78 516100 Malta 668.475 1.938 32420 52.78 516100 Malta 352.645 9.688 132.151 32862 52.78 516100 Netherlands 315.668 2.912 75 17173094 Netherlands 356.546 1.514 75 17173094 Netherlands 381.003 1.339 75 17173094 Netherlands 352.412 1.398 75.886 454352 75 17173094 Netherlands 321.782 1.048 75 17173094 Netherlands 294.996 1.922 75 17173094 Netherlands 357.536 2.737 75 17173094 Netherlands 369.066 1.98 75 17173094 Netherlands 441.213 2.737 75 17173094 Netherlands 455.655 0.932 75 17173094 Netherlands 417.106 0.932 86.801 582058 75 17173094 Netherlands 191.288 0.524 41.67 17173094 Netherlands 151.341 0.524 41.67 17173094 Netherlands 142.49 0.175 25.449 10606168 41.67 17173094 Netherlands 123.216 0.116 41.67 17173094 Slovakia 12.269 0 2053645 43.98 5460726 Slovakia 9.889 0 0.366 2058694 43.98 5460726 Slovakia 6.043 0 2067552 43.98 5460726 Slovakia 21.792 0.366 2075531 43.98 5460726 Slovakia 17.763 0.183 2085437 43.98 5460726 Slovakia 17.397 0 2094292 43.98 5460726 Slovakia 15.566 0 2102941 43.98 5460726 Slovakia 23.44 0 2106982 43.98 5460726 Slovakia 17.397 0 1.832 2108725 43.98 5460726 Slovakia 5.128 0 2114144 34.72 5460726 Slovakia 21.792 0.366 2118979 34.72 5460726 Slovakia 25.088 0.183 2124990 34.72 5460726 Spain 0 0 71.3 46745211 Spain 0 0 160.798 1070091 71.3 46745211 Spain 647.147 15.018 1096922 71.3 46745211 Spain 215.145 11.338 1119180 71.3 46745211 Spain 231.66 7.209 1144556 71.3 46745211 Spain 310.513 8.3 1171026 71.3 46745211 Spain 244.624 8.493 68.52 46745211 Spain 0 0 68.52 46745211 Spain 0 0 107.072 1197061 68.52 46745211 Spain 446.014 11.445 1208305 68.52 46745211 Spain 159.61 9.477 1221183 68.52 46745211 Spain 197.068 8.322 1231782 68.52 46745211 Spain 204.684 7.38 1243783 68.52 46745211 Spain 178.435 7.038 68.52 46745211 Spain 0 0 68.52 46745211 Spain 0 0 83.41 1261848 68.52 46745211 Spain 341.81 9.99 1266700 68.52 46745211 Spain -1590.473 4.107 1287002 68.52 46745211 Spain 131.286 9.541 1308913 68.52 46745211 Switzerland 0 3.213 48.534 46369 60.19 8715494 Switzerland 376.341 -9.982 54890 60.19 8715494 Switzerland 156.388 15.031 65949 60.19 8715494 Switzerland 183.811 2.868 76123 60.19 8715494 Switzerland 155.585 1.606 87350 60.19 8715494 Switzerland 143.767 1.836 97493 60.19 8715494 Switzerland 0 2.295 101039 60.19 8715494 Switzerland 0 2.065 37.749 101543 60.19 8715494 Switzerland 284.551 2.18 110510 60.19 8715494 Switzerland 0 0 33.848 5660446 8715494 United Kingdom 783.76 9.017 79.63 68207114 United Kingdom 848.196 6.524 79.63 68207114 United Kingdom 808.669 6.671 338.088 79.63 68207114 United Kingdom 863.883 6.011 79.63 68207114 United Kingdom 895.61 12.917 87.96 68207114 United Kingdom 917.148 15.277 87.96 68207114 United Kingdom 773.922 17.036 87.96 68207114 United Kingdom 999.778 19.543 87.96 68207114 United Kingdom 881.11 15.174 87.96 68207114 United Kingdom 806.749 8.313 422.302 391399 87.96 68207114 United Kingdom 678.448 7.756 412167 87.96 68207114 United Kingdom 669.256 18.268 428232 87.96 68207114 United Kingdom 698.783 22.989 437977 87.96 68207114 United Kingdom 715.527 18.371 443234 87.96 68207114 United Kingdom 819.343 18.84 447442 87.96 68207114 United Kingdom 607.385 19.045 450062 87.96 68207114 United Kingdom 566.95 9.999 419.223 452301 87.96 68207114 ... View more

Import data through data step

by Quartz | Level 8 in SAS Programming
‎11-26-2021 04:10 AM
‎11-26-2021 04:10 AM
I'm trying to import csv file using data step. Data consits of two columns : country and rate. The problem is the lengths of countries are different and also there an embedded spaces in the names, and the values of the second column are all over. This is how the data looks in text format:        I used this code:   data sales; infile "………………………."  trunvcover  ; input names $ 1-14     rate 16-20; Run;   But data was not imported properly and I got no error message in my log:  The minimum record length was 5. The maximum record length was 14. NOTE: The data set WORK.SALES has 9751 observations and 2 variables.     and the output looks like this:     Could anyone please suggest solution to this.   Thank you   ... View more

Re: Binomial mixture model and gradient function

by Quartz | Level 8 in Statistical Procedures
‎11-26-2021 02:41 AM
‎11-26-2021 02:41 AM
I interchanged those values but I got nothing. I see the gradient function is correctly specified. I think the errors are results of zero in denominator. For certain values the probability of assigning the successes to each component is zero . I run an equivalent code in R and I got the entire output for the numerator and denominator. I can see there are several zeros for the dominators. R stops there but SAS treats errors as missing values and imput them.   ... View more

Binomial mixture model and gradient function

by Quartz | Level 8 in Statistical Procedures
‎11-20-2021 01:37 PM
‎11-20-2021 01:37 PM
I'm trying to fit finite binomial mixture with 4 components. I have problem with the plot of the gradient function which must be equal or less than 1 in the interval of possible support points but equal to one for  the identified support points of the components. Number is the size of the trial and ntarget are the cured patients. The trick here is the different size of each trial. This was my code for the gradient function (with support points and their weights in the mixture):   data data1; set data; do p=0 to 1 by 0.01; output; end; run; data data2; set data1; gradient4 = pdf('BINOM', ntarget, p,number) / (0.263327842*pdf('BINOM', ntarget, 0.7978980, number) + 0.005551754*pdf('BINOM', ntarget, 0.5080765, number)+0.050572356*pdf('BINOM', ntarget, 0.5080765, number)+ 0.680548048*pdf('BINOM', ntarget, 0.6291304, number)); run; I get this message which I don't understand:      and the plot for the gradient function which does not prove that the 4 components are NPML :    Could you please explain the error I got up there and if the gradient function is correctly specified.   Thank you ... View more

Sensitivity analysis on marginal model

by Quartz | Level 8 in Statistical Procedures
‎01-29-2021 05:35 AM
‎01-29-2021 05:35 AM
I have continuous longitudinal data for which I conducted WGEE and MI-GEE. I want to conduct sensitivity analysis but I know no procedure for that. I'm familiar with procedures for linear mixed model under MI and pattern mixture  model but not for marginal models. Could someone please tell me what is the procedure for sensitivity analysis of marginal models.   Thank you  ... View more

Weighted GEE

by Quartz | Level 8 in Statistical Procedures
‎01-28-2021 02:07 PM
‎01-28-2021 02:07 PM
I have longitudinal data with continuous outcome and missing values and I want to fit marginal model. Can weighted GEE be fitted in this type of data as primary analysis?   Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-04-2022 09:11 AM
Likes from
View All
Quick links