Dear Expert;   I have a huge dataset I want to sort with new variable I created (Neworder). How do I sort the data.   Here is the sample codes; data want; set sashelp.class; rownum=_n_; newvalue=mod(rownum,6); if newvalue=0 then newvalue1=6; else newvalue1=newvalue;   run; data want1; set want; if newvalue1=1 then neworder=1; if newvalue1=2 then neworder=4; if newvalue1=3 then neworder=2; if newvalue1=4 then neworder=5; if newvalue1=5 then neworder=3; if newvalue1=6 then neworder=6; run; proc sort data=want1 out=test; by Name rownum neworder; run;   After running the above code I have the following output. Name Sex Age Height Weight rownum newvalue newvalue1 neworder Alfred M 14 69.0 112.5 1 1 1 1 Alice F 13 56.5 84.0 2 2 2 4 Barbara F 13 65.3 98.0 3 3 3 2 Carol F 14 62.8 102.5 4 4 4 5 Henry M 14 63.5 102.5 5 5 5 3 James M 12 57.3 83.0 6 0 6 6 Jane F 12 59.8 84.5 7 1 1 1 Janet F 15 62.5 112.5 8 2 2 4 Jeffrey M 13 62.5 84.0 9 3 3 2 John M 12 59.0 99.5 10 4 4 5 Joyce F 11 51.3 50.5 11 5 5 3 Judy F 14 64.3 90.0 12 0 6 6 Louise F 12 56.3 77.0 13 1 1 1 Mary F 15 66.5 112.0 14 2 2 4 Philip M 16 72.0 150.0 15 3 3 2 Robert M 12 64.8 128.0 16 4 4 5 Ronald M 15 67.0 133.0 17 5 5 3 Thomas M 11 57.5 85.0 18 0 6 6 William M 15 66.5 112.0 19 1 1 1   The  Expected output should be sorted the the first 1-6 then next 1-6 ....   Name Sex Age Height Weight rownum newvalue newvalue1 neworder Alfred M 14 69.0 112.5 1 1 1 1 Barbara F 13 65.3 98.0 3 3 3 2 Henry M 14 63.5 102.5 5 5 5 3 Alice F 13 56.5 84.0 2 2 2 4 Carol F 14 62.8 102.5 4 4 4 5 James M 12 57.3 83.0 6 0 6 6 Jane F 12 59.8 84.5 7 1 1 1 Jeffrey M 13 62.5 84.0 9 3 3 2 Joyce F 11 51.3 50.5 11 5 5 3 Janet F 15 62.5 112.5 8 2 2 4 John M 12 59.0 99.5 10 4 4 5 Judy F 14 64.3 90.0 12 0 6 6 Louise F 12 56.3 77.0 13 1 1 1 Philip M 16 72.0 150.0 15 3 3 2 Ronald M 15 67.0 133.0 17 5 5 3 Mary F 15 66.5 112.0 14 2 2 4 Robert M 12 64.8 128.0 16 4 4 5 Thomas M 11 57.5 85.0 18 0 6 6 William M 15 66.5 112.0 19 1 1 1 ... View more

Exeperts,   I have huge dataset and I want to reorder my row number 1-6.how do I order when I don't have other variable to group.   here is the sample SAS program:   data want; set sashelp.class; rownum=_n_; newvalue=mod(rownum,2); run;   Here is the expected output: Name Sex Age Height Weight rownum newvalue Alfred M 14 69.0 112.5 1 1 Alice F 13 56.5 84.0 2 2 Barbara F 13 65.3 98.0 3 3 Carol F 14 62.8 102.5 4 4 Henry M 14 63.5 102.5 5 5 James M 12 57.3 83.0 6 6 Jane F 12 59.8 84.5 7 1 Janet F 15 62.5 112.5 8 2 Jeffrey M 13 62.5 84.0 9 3 John M 12 59.0 99.5 10 4 Joyce F 11 51.3 50.5 11 5 Judy F 14 64.3 90.0 12 6 Louise F 12 56.3 77.0 13 1 Mary F 15 66.5 112.0 14 2 Philip M 16 72.0 150.0 15 3 Robert M 12 64.8 128.0 16 4 Ronald M 15 67.0 133.0 17 5 Thomas M 11 57.5 85.0 18 6 William M 15 66.5 112.0 19 1     Appreciate your help.   thanks,   ... View more

Dear Experts,   options msglevel=i nodate noquotelenmax mprint;   proc sql stimer;   connect to oledb (provider     = 'XXXXXXXX'                             datasource = "XXXXXXXX"                             user       = XXXXXXXXXXX                             password   = XXXXXXXXXXX                             properties = ('initial catalog'=XXXXXXXXX)                            dbmax_text  = 30000);   create table TempData as   select * from connection to oledb       ( execute Storeprocedurefromdatabse        %if &A ne %then  &A,;        %if &B ne %then &B,;        %if &C ne %then &C;,        &D) by oledb;    disconnect from oledb;    quit; %mend test;   I have a store procedure in a database and i want to create a tempdata using sas. i have four parameters to pass: @A,@B,@c,@D, The fourth parameter(@D) is always provided by the users but the other three parameters are selected by users. for instance for one user: If they select @A then @B and @c is null. If they select @B then @A and @C is null. when i run the sas web application i got the follwoing error. ERROR 79-322: Expecting a ). could you please help me how to create a dataset from the store procedure.   Thanks, kesete ... View more

Dear Experts,   I have an existing dataset with datetime format. I want to add a datetime range 03/18/2017-03/20/2017.   data have1; input datevalues ; informat datevalues datetime22.; format datevalues datetime22.; cards; 11MAR2017:00:00:00.000 12MAR2017:00:00:00.000 13MAR2017:00:00:00.000 14MAR2017:00:00:00.000 15MAR2017:00:00:00.000 16MAR2017:00:00:00.000 17MAR2017:00:00:00.000 ; run; 　 　 　 %let start_date=11MAR2017:00:00:00.000; %let end_date=16MAR2017:00:00:00.000; 　 data have2; do datevalues="&start_date"dt to "&end_date"dt; output; end; format datevalues datetime22.3; run; proc append base=have1 data=have2; run;     desired output. 11MAR2017:00:00:00.000 12MAR2017:00:00:00.000 13MAR2017:00:00:00.000 14MAR2017:00:00:00.000 15MAR2017:00:00:00.000 16MAR2017:00:00:00.000 17MAR2017:00:00:00.000 18MAR2017:00:00:00.000 19MAR2017:00:00:00.000 20MAR2017:00:00:00.000   thanks, ... View more