Is possible to change variable length without creating a new dataset using proc dataset or sql? Example: proc datasets library=work nolist; modify datset format variabe $5 length variable 10; run; Proc sql; alter table dataset modify variabe format = $5 modify length variable 10; quit; ... View more

Data Code1; Set Test1; Run; Data Code2; Set Test2; Run; Data Code3; Set Test3; Run; I want the rest of the program to stop running if dataset Code1 is empty. Any help with this? ... View more

I am trying to get to this with my macro. Can anyone help? '1jan2012'd','1jan2013'd','1jan2014'd','1jan2015'd','1jan2016'd', data want;   informat Date_of_Birth mmddyy10.;   format Date_of_Birth mmddyy10.;   input Date_of_Birth;   cards; 1/1/2012 1/1/2012 1/1/2013 1/1/2013 1/1/2014 1/1/2014 1/1/2015 1/1/2015 1/1/2016 1/1/2016 ; Run; proc sql noprint;   select distinct cats("'"(put(Date_of_Birth format,date9.))           into :date  separated by ','   from want ; quit; %put &date; ... View more

I used format = date9. to convert datetime to date9. but it doesn't work in an SQL statement. Any help? ... View more

I want three outputs in one dataset and I also want each output to read from “tourrevenue dataset” and not the previous output. As you may notice there is no data in third output because it is reading from the previous dataset. I want it to have data from tourrevenue where Vendor = 'World'. data tourrevenue;     input Country $ 1-11 LandCost Vendor $ NumberOfBookings; cards; France       575 Express  10 Spain        510 World    12 Brazil       540 World     6 India        489 Express   . Japan        720 Express  10 Greece       698 Express  20 New Zealand 1489 Southsea  6 Venezuela    425 World     8 Italy        468 Express   9 Russia       924 World     6 Switzerland  734 World    20 Australia   1079 Southsea 10 Ireland      558 Express   9 ; Run; Data Three_outputs; set tourrevenue; Disc = 'Data'; Output; Disc = 'Ori'; IF Vendor = 'Express'; output; LandCost = 0-LandCost ; Disc = 'rvs'; IF Vendor = 'World'; output; Run; Proc sort data= Three_outputs out=Results; by Disc; Run; ... View more

data tourrevenue;     input Country $ 1-11 LandCost Vendor $ customer; cards; France       575 Express  10 Spain        510 World    12 Brazil       540 World     6 Japan        720 Express  10 Greece       698 Express  20 Venezuela    425 World     8 Italy        468 Express   9 Russia       924 World     6 Switzerland  734 World    20 Ireland      558 Express   9 ; Run; Proc sort data = tourrevenue by vendor; run; How do I get to this from the data set about??? Country LandCost Vendor Customer Percentages New_Landcost France 575 Express 10 0.527272727                  303.18 Japan 720 Express 10 0.527272727                  379.64 Greece 698 Express 20 0.527272727                  368.04 Italy 468 Express 9 0.527272727                  246.76 Ireland 558 Express 9 0.527272727                  294.22 Spain 510 World 12 0.472727273                  241.09 Brazil 540 World 6 0.472727273                  255.27 Venezuela 425 World 8 0.472727273                  200.91 Russia 924 World 6 0.472727273                  436.80 Switzerland 734 World 20 0.472727273                  346.98 This is how the percentage was arrived at Vendor Customer Percentages Express 58 0.52727 World 52 0.47273 Total 110 1 ... View more

I have a field named Product with some fields having trailing and leading spaces. What code should I use to spot all the products with leading and trailing space out of million observations? The spaces below are denoted as ... Product  Milk..   ..Banana  Orange..  Pear.. ... View more

I am trying to merge two files and don’t want to get rid of the duplicate values in Table_1 and replaced with the values in table_2. What are the codes that will do it for me? Data Table_1;    input ID Name$ SalesQ Price;    datalines; 101 AMBA   4 15 107 GEORGE 22 15 107 GEORGE 22 15 107 GEORGE 22 15 108 HADEN 9  15 110 JACKY 8  15 109 IDDIE 19 15 104 DAME 6   15 111 KAN  211 15 112 LAN 83 09 15 106 FOYE 26   15 107 GEORGE 22 15 107 GEORGE 22 15 ; data Table_2;    input ID Name $ SalesQ Price color$;      datalines; 101 AMBA   6  24 blue 102 BAMBIE 5 32 red 103 CARRIE 1 17  yellow 104 DAME 1 24  green 105 EDDIE 7  2  tan 106 FOYE 3  6 bluegreen 107 GEORGE 100 11 pink ; Proc sort Data = Table_1; By ID; Run; Proc sort Data = Table_2; By ID; Run; Data Table_3; Merge Table_1 Table_2; By ID; Run; Current Output ID Name SalesQ Price color 101 AMBA 6 24 blue 102 BAMBIE 5 32 red 103 CARRIE 1 17 yellow 104 DAME 1 24 green 105 EDDIE 7 2 tan 106 FOYE 3 6 bluegree 107 GEORGE 100 11 pink 107 GEORGE 22 15 pink 107 GEORGE 22 15 pink 107 GEORGE 22 15 pink 107 GEORGE 22 15 pink 108 HADEN 9 15 109 IDDIE 19 15 110 JACKY 8 15 111 KAN 211 15 112 LAN 83 9 Desired Output ID Name SalesQ Price color 101 AMBA 6 24 blue 102 BAMBIE 5 32 red 103 CARRIE 1 17 yellow 104 DAME 1 24 green 105 EDDIE 7 2 tan 106 FOYE 3 6 bluegree 107 GEORGE 100 11 pink 107 GEORGE 100 11 pink 107 GEORGE 100 11 pink 107 GEORGE 100 11 pink 107 GEORGE 100 11 pink 108 HADEN 9 15 109 IDDIE 19 15 110 JACKY 8 15 111 KAN 211 15 112 LAN 83 9 ... View more