Hi. I wanted to import text file into SAS, but this file has 62 variables and tab and line spaced (see an example data with only a few variables). How can I read this file correctly into SAS if I do not know the variables' format and length? Thank you. ... View more

Hello. I have a question. I want to create a bar graph by subgroup. This below the code is working well, but I want to change the transparency of all AMR bars but not the color (AIR should be no transparent). Can anyone help with it? Thank you so much.   ************** SAS code;   GOPTIONS RESET=ALL DEVICE=PNG TARGET=PNG HSIZE=8in VSIZE=7in FTITLE='Albany AMT/bold' FTEXT='Albany AMT/bold' HTITLE=1.75 HTEXT=1.5; data mileage; input age & $15. sex $ amount sam & $15.; call execute(catt('pattern',_N_,'color='('red','violet','BIGB','grey','STGB'),';'); datalines; All sites M 500 , n=2812(100%) All sites F 400 , n=1044(100%) Female breast M 50 , n=554(20%) Female breast F 5 , n=89(9%) Male prostate M 110.0 , n=332(12%) Male prostate F 10 , n=74(7%) Lung & bronchus M 40 , n=242(9%) Lung & bronchus F 35 , n=186(18%) Colon & rectum M 45 , n=231(8%) Colon & rectum F 70 , n=102(10%) ; run; data convert; set mileage; if sex='M' then amount=-amount; run; proc format; picture posval low-high='000,009'; run; data anlabels(drop=age sex ); length text color $ 50; retain function 'label' when 'a' xsys ysys '2' hsys '3' size 2.5; set convert; midpoint=age; subgroup=sex; text=strip(""||strip(left(put(amount,posval.)))||left(sam)); /*if age='All sites' then color='red';*/ /*else if age='Female breast' then color='violet';*/ /*else if age='Male prostate' then color='BIGB';*/ /*else if age='Lung & bronchus' then color='grey';*/ /*else color='STGB'; */ /* */ /* POSITION changes to place label outside of bar if bar is too small. */ if amount ge -115 and sex='M' then position='<'; else if sex='M' then position='>'; /* POSITION changes to place label outside of bar if bar is too small. */ if amount le 115 and sex='F' then position='>'; else if sex='F' then position='<'; output; run; /* Add a title to the graph */ title1 ''; axis1 label=(justify=left '') style=0 value=(f="Albany AMT/bold" h=1.5); axis2 label=none value=( h=10pt) minor=none major=none width=3 order=(-440 to 160 by 40) value=(f="Albany AMT/bold" h=1); pattern1 v=solid color=red; pattern2 v=solid color=STGB; pattern3 v=solid color=violet; pattern4 v=solid color=grey; pattern5 v=solid color=BIGB; /*pattern1 color = white;*/ /*pattern2 color = white;*/ proc gchart data=convert; format amount posval.; note font="Albany AMT/bold" move=(22pct,65pct) h=12pt 'AIR' move=(80pct,65pct) 'AMR'; hbar age / sumvar=amount discrete nostat subgroup=sex SPACE =1 WIDTH =2 maxis=axis1 raxis=axis2 nolegend annotate=anlabels patternid=subgroup patternid=midpoint ; run; quit; ... View more

Hi. i have the following long formatted data (2 variables: ID and var (with more than 32 bytes)) id var 1 my name is mike 1 8 z street 1 unit 5 2 my name is z 2 78 8th street 2 city oktown - old town of the fairf county etc.   i want to create a dummy variable for each unique value of variable “var” (name of the dummy variables should be col1, col2 etc. and labels should come from the values of var). Can anyone help me? thank you.   ... View more

Hi.  I would like to record variable dynamically (I don’t know how many unique values) from: Blue sky white snow etc to value1 value2 value3 etc.   thank you.     ... View more

I have data as daily (attached below): I want to make as 30 days (from i2 variable)  interval data as, for example,  ID END sum_fill_i 123699041 30 VVV (whatever sum of this fill_i between 1 and 30) next row would be as below: 123699041 60 XXX (next summation of the fill_i).   Can you help please? Thank you.   ENROLID i2 fill_i 1236990401 1 1 1236990401 2 1 1236990401 3 1 1236990401 4 1 1236990401 5 1 1236990401 6 1 1236990401 7 1 1236990401 8 1 1236990401 9 1 1236990401 10 1 1236990401 11 1 1236990401 12 1 1236990401 13 1 1236990401 14 1 1236990401 15 1 1236990401 16 1 1236990401 17 1 1236990401 18 1 1236990401 19 1 1236990401 20 1 1236990401 21 1 1236990401 22 1 1236990401 23 1 1236990401 24 1 1236990401 25 1 1236990401 26 1 1236990401 27 1 1236990401 28 1 1236990401 29 1 1236990401 30 1 1236990401 32 32 1236990401 33 32 1236990401 34 32 1236990401 35 32 1236990401 36 32 1236990401 37 32 1236990401 38 32 1236990401 39 32 1236990401 40 32 1236990401 41 32 1236990401 42 32 1236990401 43 32 1236990401 44 32 1236990401 45 32 1236990401 46 32 1236990401 47 32 1236990401 48 32 1236990401 49 32 1236990401 50 32 1236990401 51 32 1236990401 52 32 1236990401 53 32 1236990401 54 54 1236990401 55 54 1236990401 56 54 1236990401 57 54 1236990401 58 54 1236990401 59 54 1236990401 60 54 1236990401 61 54 1236990401 62 54 1236990401 63 54 1236990401 64 54 1236990401 65 54 1236990401 66 54 1236990401 67 54 1236990401 68 54 1236990401 69 54 1236990401 70 54 1236990401 71 54 1236990401 72 54 1236990401 73 54 1236990401 74 54 1236990401 75 54 1236990401 76 54 1236990401 77 54 1236990401 78 54 1236990401 79 54 1236990401 80 54 1236990401 81 54 1236990401 82 54 1236990401 83 54 1236990401 92 92 1236990401 93 92 1236990401 94 92 1236990401 95 92 1236990401 96 92 1236990401 97 92 1236990401 98 92 1236990401 99 92 1236990401 100 92 1236990401 101 92 1236990401 102 92 1236990401 103 92 1236990401 104 92 1236990401 105 92 1236990401 106 92 1236990401 107 92 1236990401 108 92 1236990401 109 92 1236990401 110 92 1236990401 111 92 1236990401 112 92 1236990401 113 92 1236990401 114 92 1236990401 115 92 1236990401 116 92 1236990401 117 92 1236990401 118 92 1236990401 119 92 1236990401 120 92 1236990401 121 92 1236990401 171 171 1236990401 172 171 1236990401 173 171 1236990401 174 171 1236990401 175 171 1236990401 176 171 1236990401 177 171 1236990401 178 171 1236990401 179 171 1236990401 180 171 1236990401 181 171 1236990401 182 171 1236990401 183 171 1236990401 184 171 1236990401 185 171 1236990401 186 171 1236990401 187 171 1236990401 188 171 1236990401 189 171 1236990401 190 171 1236990401 191 171 1236990401 192 171 1236990401 193 171 1236990401 194 171 1236990401 195 171 1236990401 196 171 1236990401 197 171 1236990401 198 171 1236990401 199 171 1236990401 200 171 1236990401 228 228 1236990401 229 228 1236990401 230 228 1236990401 231 228 1236990401 232 228 1236990401 233 228 1236990401 234 228 1236990401 235 228 1236990401 236 228 1236990401 237 228 1236990401 238 228 1236990401 239 228 1236990401 240 228 1236990401 241 228 1236990401 242 228 1236990401 243 228 1236990401 244 228 1236990401 245 228 1236990401 246 228 1236990401 247 228 1236990401 248 228 1236990401 249 228 1236990401 250 228 1236990401 251 228 1236990401 252 228 1236990401 253 228 1236990401 254 228 1236990401 255 228 1236990401 256 228 1236990401 257 228 1236990401 268 268 1236990401 269 268 1236990401 270 268 1236990401 271 268 1236990401 272 268 1236990401 273 268 1236990401 274 268 1236990401 275 268 1236990401 276 268 1236990401 277 268 1236990401 278 268 1236990401 279 268 1236990401 280 268 1236990401 281 268 1236990401 282 268 1236990401 283 268 1236990401 284 268 1236990401 285 268 1236990401 286 268 1236990401 287 268 1236990401 288 268 1236990401 289 268 1236990401 290 268 1236990401 291 268 1236990401 292 268 1236990401 293 268 1236990401 294 268 1236990401 295 268 1236990401 296 268 1236990401 297 268 1236990401 299 299 1236990401 300 299 1236990401 301 299 1236990401 302 299 1236990401 303 299 1236990401 304 299 1236990401 305 299 1236990401 306 299 1236990401 307 299 1236990401 308 299 1236990401 309 299 1236990401 310 299 1236990401 311 299 1236990401 312 299 1236990401 313 299 1236990401 314 299 1236990401 315 299 1236990401 316 299 1236990401 317 299 1236990401 318 299 1236990401 319 299 1236990401 320 299 1236990401 321 299 1236990401 322 299 1236990401 323 299 1236990401 324 299 1236990401 325 299 1236990401 326 299 1236990401 327 299 1236990401 328 299 1236990401 347 347 1236990401 348 347 1236990401 349 347 1236990401 350 347 1236990401 351 347 1236990401 352 347 1236990401 353 347 1236990401 354 347 1236990401 355 347 1236990401 356 347 1236990401 357 347 1236990401 358 347 1236990401 359 347 1236990401 360 347 1236990401 361 347 1236990401 362 347 1236990401 363 347 1236990401 364 347 1236990401 365 347 1236990401 366 347 1236990401 367 347 1236990401 368 347 1236990401 369 347 1236990401 370 347 1236990401 371 347 1236990401 372 347 1236990401 373 347 1236990401 374 347 1236990401 375 347 1236990401 376 347 1236990401 409 409 1236990401 410 409 1236990401 411 409 1236990401 412 409 1236990401 413 409 1236990401 414 409 1236990401 415 409 1236990401 416 409 1236990401 417 409 1236990401 418 409 1236990401 419 409 1236990401 420 409 1236990401 421 409 1236990401 422 409 1236990401 423 409 1236990401 424 409 1236990401 425 409 1236990401 426 409 1236990401 427 409 1236990401 428 409 1236990401 429 409 1236990401 430 409 1236990401 431 409 1236990401 432 409 1236990401 433 409 1236990401 434 409 1236990401 435 409 1236990401 436 409 1236990401 437 409 1236990401 438 409 1236990401 443 443 1236990401 444 443 1236990401 445 443 1236990401 446 443 1236990401 447 443 1236990401 448 443 1236990401 449 443 1236990401 450 443 1236990401 451 443 1236990401 452 443 1236990401 453 443 1236990401 454 443 1236990401 455 443 1236990401 456 443 1236990401 457 443 1236990401 458 443 1236990401 459 443 1236990401 460 443 1236990401 461 443 1236990401 462 443 1236990401 463 443 1236990401 464 443 1236990401 465 443 1236990401 466 443 1236990401 467 443 1236990401 468 443 1236990401 469 443 1236990401 470 443 1236990401 471 443 1236990401 472 443 1236990401 474 474 1236990401 475 474 1236990401 476 474 1236990401 477 474 1236990401 478 474 1236990401 479 474 1236990401 480 474 1236990401 481 474 1236990401 482 474 1236990401 483 474 1236990401 484 474 1236990401 485 474 1236990401 486 474 1236990401 487 474 1236990401 488 474 1236990401 489 474 1236990401 490 474 1236990401 491 474 1236990401 492 474 1236990401 493 474 1236990401 494 474 1236990401 495 474 1236990401 496 474 1236990401 497 474 1236990401 498 474 1236990401 499 474 1236990401 500 474 1236990401 501 474 1236990401 502 474 1236990401 503 474 1236990401 822 822 1236990401 823 822 1236990401 824 822 1236990401 825 822 1236990401 826 822 1236990401 827 822 1236990401 828 822 1236990401 829 822 1236990401 830 822 1236990401 831 822 1236990401 832 822 1236990401 833 822 1236990401 834 822 1236990401 835 822 1236990401 836 822 1236990401 837 822 1236990401 838 822 1236990401 839 822 1236990401 840 822 1236990401 841 822 1236990401 842 822 1236990401 843 822 1236990401 844 822 1236990401 845 822 1236990401 846 822 1236990401 847 822 1236990401 848 822 1236990401 849 822 1236990401 850 822 1236990401 851 822 1236990401 1116 1116 1236990401 1117 1116 1236990401 1118 1116 1236990401 1119 1116 1236990401 1120 1116 1236990401 1121 1116 1236990401 1122 1116 1236990401 1123 1116 1236990401 1124 1116 1236990401 1125 1116 1236990401 1126 1116 1236990401 1127 1116 1236990401 1128 1116 1236990401 1129 1116 1236990401 1130 1116 1236990401 1131 1116 1236990401 1132 1116 1236990401 1133 1116 1236990401 1134 1116 1236990401 1135 1116 1236990401 1136 1116 1236990401 1137 1116 1236990401 1138 1116 1236990401 1139 1116 1236990401 1140 1116 1236990401 1141 1116 1236990401 1142 1116 1236990401 1143 1116 1236990401 1146 1146 1236990401 1147 1146 1236990401 1148 1146 1236990401 1149 1146 1236990401 1150 1146 1236990401 1151 1146 1236990401 1152 1146 1236990401 1153 1146 1236990401 1154 1146 1236990401 1155 1146 1236990401 1156 1146 1236990401 1157 1146 1236990401 1158 1146 1236990401 1159 1146 1236990401 1160 1146 1236990401 1161 1146 1236990401 1162 1146 1236990401 1163 1146 1236990401 1164 1146 1236990401 1165 1146 1236990401 1166 1146 1236990401 1167 1146 1236990401 1168 1146 1236990401 1169 1146 1236990401 1170 1146 1236990401 1171 1146 1236990401 1172 1146 1236990401 1173 1146 1236990401 1181 1181 1236990401 1182 1181 1236990401 1183 1181 1236990401 1184 1181 1236990401 1185 1181 1236990401 1186 1181 1236990401 1187 1181 1236990401 1188 1181 1236990401 1189 1181 1236990401 1190 1181 1236990401 1191 1181 1236990401 1192 1181 1236990401 1193 1193 1236990401 1194 1193 1236990401 1195 1193 1236990401 1196 1193 1236990401 1197 1193 1236990401 1198 1193 1236990401 1199 1193 1236990401 1200 1193 1236990401 1201 1193 1236990401 1202 1193 1236990401 1203 1193 1236990401 1204 1193 1236990401 1205 1193 1236990401 1206 1193 1236990401 1207 1193 1236990401 1208 1193 1236990401 1209 1193 1236990401 1210 1193 1236990401 1211 1193 1236990401 1212 1212 1236990401 1213 1212 1236990401 1214 1212 1236990401 1215 1212 1236990401 1216 1212 1236990401 1217 1212 1236990401 1218 1212 1236990401 1219 1212 1236990401 1220 1212 1236990401 1221 1212 1236990401 1222 1212 1236990401 1223 1212 1236990401 1224 1212 1236990401 1225 1212 1236990401 1226 1212 1236990401 1227 1212 1236990401 1228 1212 1236990401 1229 1212 1236990401 1230 1212 1236990401 1231 1212 1236990401 1232 1212 1236990401 1233 1212 1236990401 1234 1212 1236990401 1235 1212 1236990401 1236 1212 1236990401 1237 1212 1236990401 1238 1212 1236990401 1239 1212 1236990401 1240 1240 1236990401 1241 1240 1236990401 1242 1240 1236990401 1243 1240 1236990401 1244 1240 1236990401 1245 1240 1236990401 1246 1240 1236990401 1247 1240 1236990401 1248 1240 1236990401 1249 1240 1236990401 1250 1240 1236990401 1251 1240 1236990401 1252 1240 1236990401 1253 1240 1236990401 1254 1240 1236990401 1255 1240 1236990401 1256 1240 1236990401 1257 1240 1236990401 1258 1240 1236990401 1259 1240 1236990401 1260 1240 1236990401 1261 1240 1236990401 1262 1240 1236990401 1263 1240 1236990401 1264 1240 1236990401 1265 1240 1236990401 1266 1240 1236990401 1267 1240 1236990401 1268 1268 1236990401 1269 1268 1236990401 1270 1268 1236990401 1271 1268 1236990401 1272 1268 1236990401 1273 1268 1236990401 1274 1268 1236990401 1275 1268 1236990401 1276 1268 1236990401 1277 1268 1236990401 1278 1268 1236990401 1279 1268 1236990401 1280 1268 1236990401 1281 1268 1236990401 1282 1268 1236990401 1283 1268 1236990401 1284 1268 1236990401 1285 1268 1236990401 1286 1268 1236990401 1287 1268 1236990401 1288 1268 1236990401 1289 1268 1236990401 1290 1268 1236990401 1291 1268 1236990401 1292 1268 1236990401 1293 1268 1236990401 1294 1268 1236990401 1295 1268 1236990401 1296 1268 1236990401 1297 1268 1236990401 1317 1317 1236990401 1318 1317 1236990401 1319 1317 1236990401 1320 1317 1236990401 1321 1317 1236990401 1322 1317 1236990401 1323 1317 1236990401 1324 1317 1236990401 1325 1317 1236990401 1326 1317 1236990401 1327 1317 1236990401 1328 1317 1236990401 1329 1317 1236990401 1330 1317 1236990401 1331 1317 1236990401 1332 1317 1236990401 1333 1317 1236990401 1334 1317 1236990401 1335 1317 1236990401 1336 1317 1236990401 1337 1317 1236990401 1338 1317 1236990401 1339 1317 1236990401 1340 1317 1236990401 1341 1317 1236990401 1342 1317 1236990401 1343 1317 1236990401 1344 1317 1236990401 1345 1317 1236990401 1346 1317 1236990401 1376 1376 1236990401 1377 1376 1236990401 1378 1376 1236990401 1379 1376 1236990401 1380 1376 1236990401 1381 1376 1236990401 1382 1376 1236990401 1383 1376 1236990401 1384 1376 1236990401 1385 1376 1236990401 1386 1376 1236990401 1387 1376 1236990401 1388 1376 1236990401 1389 1376 1236990401 1390 1376 1236990401 1391 1376 1236990401 1392 1376 1236990401 1393 1376 1236990401 1394 1376 1236990401 1395 1376 1236990401 1396 1376 1236990401 1397 1376 1236990401 1398 1376 1236990401 1399 1376 1236990401 1400 1376 1236990401 1401 1376 1236990401 1402 1376 1236990401 1403 1376 1236990401 1422 1422 1236990401 1423 1422 1236990401 1424 1422 1236990401 1425 1422 1236990401 1426 1422 1236990401 1427 1422 1236990401 1428 1422 1236990401 1429 1422 1236990401 1430 1422 1236990401 1431 1422 1236990401 1432 1422 1236990401 1433 1422 1236990401 1434 1422 1236990401 1435 1422 1236990401 1436 1422 1236990401 1437 1422 1236990401 1438 1422 1236990401 1439 1422 1236990401 1440 1422 1236990401 1441 1422 1236990401 1442 1422 1236990401 1443 1422 1236990401 1444 1422 1236990401 1445 1422 1236990401 1446 1422 1236990401 1447 1422 1236990401 1448 1422 1236990401 1449 1422 1236990401 1509 1509 1236990401 1510 1509 1236990401 1511 1509 1236990401 1512 1509 1236990401 1513 1509 1236990401 1514 1509 1236990401 1515 1509 1236990401 1516 1509 1236990401 1517 1509 1236990401 1518 1509 1236990401 1519 1509 1236990401 1520 1509 1236990401 1521 1509 1236990401 1522 1509 1236990401 1523 1509 1236990401 1524 1509 1236990401 1525 1509 1236990401 1526 1509 1236990401 1527 1509 1236990401 1528 1509 1236990401 1529 1509 1236990401 1530 1509 1236990401 1531 1509 1236990401 1532 1509 1236990401 1533 1509 1236990401 1534 1509 1236990401 1535 1509 1236990401 1536 1509 1236990401 1554 1554 1236990401 1555 1554 1236990401 1556 1554 1236990401 1557 1554 1236990401 1558 1554 1236990401 1559 1554 1236990401 1560 1554 1236990401 1561 1554 1236990401 1562 1554 1236990401 1563 1554 1236990401 1564 1554 1236990401 1565 1554 1236990401 1566 1554 1236990401 1567 1554 1236990401 1568 1554 1236990401 1569 1554 1236990401 1570 1554 1236990401 1571 1554 1236990401 1572 1554 1236990401 1573 1554 1236990401 1574 1554 1236990401 1575 1554 1236990401 1576 1554 1236990401 1577 1554 1236990401 1578 1554 1236990401 1579 1554 1236990401 1580 1554 1236990401 1581 1554 1236990401 1734 1734 1236990401 1735 1734 1236990401 1736 1734 1236990401 1737 1734 1236990401 1738 1734 1236990401 1739 1734 1236990401 1740 1734 1236990401 1741 1734 1236990401 1742 1734 1236990401 1743 1734 1236990401 1744 1734 1236990401 1745 1734 1236990401 1746 1734 1236990401 1747 1734 1236990401 1748 1734     ... View more