I want to derive a new column 'Region'. I have City, County and State columns available in the source table. Is there a way to do so in SAS and/or proc sql ? Any help is much appreciated. Here is a sample select statement(For eg: need to derive RTP, Triad etc. regions of North Carolina): Proc sql; Create tbl1 as select full name, address, city, state, zip, county, /*how to derive 'region' column from available columns?*/ from tbl2 ; quit; ... View more

Hello everyone,  I am looking for a condensed way to write the following (repetitive and hard coded) block of code. Is there a way to do so in macro or something else? Any help would be greatly appreciated. case when gender = 'M'  then A  else ' ' end) as MA, case when gender = 'M’  then B else . end) as MB,  case when gender = 'M'  then C else . end) as MC,   case when gender = 'F'  then A else ' ' end) as FA, case when gender = 'F'  then B else . end) as FB, case when gender = 'F'  then C else . end) as FC (and so on...) FROM student; ... View more

Hi All, I have a following text(magnolia) file on my free sas university edition.   M. grandiflora      Southern Magnolia    80  15  E  White M. Campbellii                                        80  20  D  Rose M. Liliflora           Lily Magnolia             12    4   D  Purple M. soulangiana   Saucer Magnolia       25    3   D  Pink M. Stellata Star   Magnolia                   10    3   D  White   I used the following code to read that into sas but  would not work.The problem is that four rows under M. Campbelli (80,20,D Rose) would be missing in the output.I tried using whatever  options i could recall but failed.The result looked like this: Obs name sciname sale_qty remnant code color 1 M. grandiflora                 Southern Magnolia               80 15 E White 2 M. Campbellii                  . .     3 M. Liliflora                 Lily Magnolia               12 4 D Purple 4 M. soulangiana                 Saucer Magnolia               25 3 D Pink 5 M. Stellata                 Star Magnolia               10 3 D White data flowers; infile'/folders/myfolders/magnolia.txt' missover; input name $ 1-14 sci_name $ 15-35 sale_qty 36-38  remnant 39-40 code$ 41-42 color $; run; proc print data=flowers; run;     Any help would be greatly appreciated.   Thanks, ... View more