About nrb

nrb · ‎12-07-2016

This is what I have tried to code but it's still incorrect and I need help leading towards the right direction data cork; input Tree$1-2 North South East West; datalines; T1 72 66 76 77 T2 60 53 66 63 T3 56 57 64 58 T4 41 29 36 38 T5 32 32 35 36 T6 30 35 34 26 %MACRO randomorder (input= ,nsets=, seed=, output=); PROC SORT DATA = input OUT = "&output"; seed=ranuni(seed); run; %MEND select; %randomorder(input=cork ,nsets=5, seed=0, output=outdata1) The question is asking Suppose we want to create several copies of a data set, but every time shuffled randomly. This task can be done with the following SAS program. Data new; set old; index=RANUNI(seed); Run; Proc sort data=new; By index; Run; Data new; set new; drop index; run; (a) Write a macro program with 4 parameters: input, nsets, seed, and output. “input” is the name of the existing data set, “nsets” is the number of randomly shuffled data sets, “seed” is an integer‐valued seed for RANUNI(), and “output” is the prefix of the names of randomly shuffled data sets. B. Read the datalines It contains 5 variables: tree, north, east, south, west. Read this data file into SAS. Suppose this SAS dataset name is ‘cork’. Then, suppose you submit the following code. %RandomOrder(cork, 5, 0, outData). Report the output of the following code: Proc print data=outData1; Run;

nrb · ‎12-07-2016

grad school level, but i'm in undergrad taking it.

nrb · ‎12-07-2016

So i'm converting the SAS code into a macro code? Can't I just replace the variables in the SAS code with the variables presented for the macro code?

nrb · ‎12-06-2016

let's say I have the code below data cork; input tree$1-3 north east south west; datalines; T1 72 66 76 77 T2 60 53 66 63 T3 56 57 64 58 T4 41 29 36 38 run; The question is Then, suppose you submit the following code. %RandomOrder(cork, 5, 0, outData) what would happen in we printed this out? Proc print data=outData1; Run; Proc print data=outData2; The problem i'm having is that i'm putting the %RandomOrder(cork, 5, 0, outData) below the run statement in the code presented above however it mentions "Statement is not valid or it is used out of proper order" Here's the full question Dataset contains 5 variables: tree, north, east, south, west. Read this data file into SAS. Suppose this SAS dataset name is ‘cork’. Then, suppose you submit the following code. %RandomOrder(cork, 5, 0, outData) Report the output of the following code: Proc print data=outData1; Run; Proc print data=outData2; Run;

nrb · ‎12-06-2016

I have the following dataset: who's inputs are CustomerID, SaleDate,Variety, Quantity 240W 02-07-2008 Ginger 120 240W 02-07-2008 Protea 180 356W 02-08-2008 Heliconia 60 356W 02-08-2008 Anthurium 300 188R 02-11-2008 Ginger 24 188R 02-11-2008 Anthurium 24 240W 02-12-2008 Heliconia 48 240W 02-12-2008 Protea 48 356W 02-12-2008 Ginger 240 I have to Write a procedure to compute the average quantity of sale. I then have to Write a DATA step to put the average quantity in a macro variable AVG, I cant use the %let statement. Run the program below. proc chart data = flowersales; vbar variety / type=mean sumvar=quantity ref=&avg; run; How would I do this? I can't figure it out, please help me understand how it would work.

nrb · ‎12-06-2016

Suppose we want to create several copies of a data set, but every time shuffled randomly. This task can be done with the following SAS program. Data new; set old; index=RANUNI(seed); Run; Proc sort data=new; By index; Run; Data new; set new; drop index; run; How can we write a macro program with 4 parameters: input, nsets, seed, and output. “input” is the name of the existing data set, “nsets” is the number of randomly shuffled data sets, “seed” is an integer‐valued seed for RANUNI(), and “output” is the prefix of the names of randomly shuffled data sets.

nrb · ‎12-05-2016

I have the following data data left; input subj Height Weight; cards; 001 68 155 002 75 220 003 65 99 005 79 266 006 70 190 009 61 122 ; data right; input subj salary; datalines; 001 46000 003 67900 004 28200 005 98202 006 88000 007 57200 ; a. I want to use Proc SQL to create a new SAS data set containing Subj (both Subj variables), Height, Weight and Salary, I know I have to rename Subj from the left data set as LeftSubj and rename Subj from the right data set as RightSubj in Proc SQL, however i'm not sure how to do this. When I do it on my own the output doesn't come out right.

nrb · ‎12-02-2016

Duncan Hines ------------------------------------------------ Flavor Height in cm. ------------------------------------------------ Devil's food 39 Devil's food 36.5 White 30.5 White 34.5 Yellow 37.0 Yellow 35.0 Betty Crocker ------------------------------------------------ Flavor Height in cm. ------------------------------------------------ Devil's food 35.5 Devil's food 36.0 White 35.5 White 37.5 Yellow 32.5 Yellow 32.5 So let's say I have these two data sets above one for Duncan Hines and one for Betty crocker, how do I a. Combine these two data sets by Concatenating b. Combine these two data sets interleaving by flavor *the variables should be read as how they are spaced and the spacing not be replaced by underscore.

nrb · ‎11-22-2016

How do you read in this data with the following datalines. CURR is stored in the first three columns, next three variables, namely, DDEP, PRICES, and GNP are stored in four columns each, WAGES is stored in the next three columns, the next three variables, namely, INCOME, POPULATION, and CONS are stored in the following four columns each, and variable YEAR is stored in the next two columns and the QUARTER is stored in the last column. Furthermore, all the variables’ values are one decimal number except the last two variables, which are whole numbers. *Do not change the formatting of the datalines because that's how you're supposed to read it in. 251 920 8993180154270015401739511 253 929 9033258157276215471743512 257 939 9103328158280515541774513 260 959 9223369161285315611809514 263 972 9163395163286315671817521 265 980 9243391163286615731855522 268 990 9303456167291715811893523 272 999 9303577170301215881930524 2751001 9263642173306015941950531 2771007 9333675174307916001967532 2781008 9393658176306416071976533 2781010 9363608177298516151977534 282107810054347208357917402467581 283109310084383210359317462506582 284110610084514212370217542545583 285112210084644217383017622570584 287113310084740219392417692612591 289114110154869221404917762648592

nrb · ‎11-22-2016

I have attached a screenshot of the question. Please help me figure this out, i'm very lost.

nrb · ‎11-14-2016

Hello, so I need help reading and formatting the output into the following. For example if i have these datalines 01 Alabama e 6 112 -27 3893888 77 35.600 60.035 4801 346 02 Alaska w 9 100 -80 401851 1 0.400 64.344 6410 858 04 Arizona w 8 127 -40 2718215 24 53.300 83.832 7614 257 * THE DATA LINES ARE SUPPOSED TO BE READ IN LIKE ABOVE IN MULTIPLE LINES. I want to assign it variable names and format the output so that it looks like this. stcod stname east/west CBcode Hightemp Lowtemp Pop80 popsqm plandag purbpop crimerate BTU 01 Alabama e 6 112 -27 3893888 77 35.600 60.035 4801 346 02 Alaska w 9 100 -80 401851 1 0.400 64.344 6410 858 04 Arizona w 8 127 -40 2718215 24 53.300 83.832 7614 257 Please help!

Online Status	Offline
Date Last Visited	‎12-07-2016 04:47 PM

Write a macro program with 4 parameters

Re: writing a macro with 4 parameters

Re: writing a macro with 4 parameters

What would happen in this code?

writing a data step to put in macro variable

writing a macro with 4 parameters

How do I combine the data using PROC SQL

How to combine data through Concatenate and Interleaving

How to read this datalines and format them.

Help Please Concatenate and interleaving

How do I combine the data using PROC SQL

Write a macro program with 4 parameters

Re: writing a macro with 4 parameters

Re: writing a macro with 4 parameters

What would happen in this code?

writing a data step to put in macro variable

writing a macro with 4 parameters

How do I combine the data using PROC SQL

How to combine data through Concatenate and Interleaving

How to read this datalines and format them.

Help Please Concatenate and interleaving

Reading in multiple data lines