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: 
Sidhu
‎05-10-2017
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

How to change order of observations in dataset without using proc proc...

by Calcite | Level 5 in SAS Programming
‎11-20-2013 11:54 AM
‎11-20-2013 11:54 AM
How to change order of observations in dataset without using proc procedures like proc sort, proc sql etc. What I want to ask ... is there any way to shuffle the dataset. As this is question I faced by interview. For example : In one dataset : Subid Invid Sex Age 0001 101   Male 30 0002 202   Male 40 0003 303   Male 50 0004 404  Female 60 The output dataset should be like. Subjid Invid Sex Age 0004 404 Female 60 0001 101 Male    30 0003 303 Male    50 0002 202 Male    40 ... View more

Re: problem with RBREAK Statement in PROC report

by Calcite | Level 5 in SAS Procedures
‎02-27-2013 11:29 AM
‎02-27-2013 11:29 AM
Hi Yaswanth Try this...i think it may help you proc sort data= sasuser.admit out = admit;    by actlevel;    run; proc univariate data = admit;     var  fee height weight;   by actlevel;   output out = admit1      min= min1   max = max1   sum = sum1 sum2 sum3;   run; proc report data = admit1 nowd list split = "/";   column actlevel   sum2 sum3 sum1 max1 min1;     define actlevel/"/ Actlevel" group width = 8;   define sum2 / " /Height" sum;   define sum3 / " /Weight" sum;   define sum1 / "/Fee" sum;   define max1/  "Max / Fee"sum;   define min1/  "Min / Fee"sum;   rbreak after/ summarize  dol ; run; or U can try this if you want proc report data = admit1 nowd list split = "/";   column actlevel   sum2 sum3 sum1 max1 min1;     define actlevel/"/ Actlevel" group width = 8;   define sum2 / " /Height" sum;   define sum3 / " /Weight" sum;   define sum1 / "/Fee" sum;   define max1/  "Max/____/ Fee"sum;   define min1/  "Min/____/Fee"sum;   rbreak after/ summarize  dol ; run; ... View more

Re: SUM on proc print

by Calcite | Level 5 in SAS Procedures
‎02-22-2013 11:46 AM
‎02-22-2013 11:46 AM
Even I did without Colon Doc, but I am getting same error why? ... View more

Re: SUM on proc print

by Calcite | Level 5 in SAS Procedures
‎02-22-2013 08:31 AM
‎02-22-2013 08:31 AM
Hi Arthur, Thanks for ur reply, and this was the error I see in my log of using sumlabel. proc print data=test noobs  sumlabel:                                  ---------                                  22      200 ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DOUBLE, HEADING, LABEL, N,               NOOBS, OBS, ROUND, ROWS, SPLIT, STYLE, UNIFORM, WIDTH. ERROR 200-322: The symbol is not recognized and will be ignored. 263     style(grandtotal) = {background=white}; 264     by dummy; 265     sum height weight; 266     label  dummy='Total'; 267     title 'Test of Getting Labeled Total'; 268  run; ... View more

Re: SUM on proc print

by Calcite | Level 5 in SAS Procedures
‎02-22-2013 05:36 AM
‎02-22-2013 05:36 AM
Hi Arthur, Thanks for your answer,I am getting some errors but I tried it by modifying your code little bit. Even label statement is not working, it displaying as Dummy it self why? Can you please explain me if you can. Modified code: data test;   set sashelp.class;   retain dummy 1; run; proc print data=test noobs  label    style(grandtotal) = {background=white};    by dummy;    sum height weight;    label  dummy='Total';    title 'Test of Getting Labeled Total'; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-10-2017 07:26 AM
Quick links