chouchou Tracker

&syspbuff couldn't resolve to the value assigned

chouchou — Tue, 11 Nov 2014 04:15:42 GMT

%macro pbuffparms / parmbuff;

ods graphics on / reset=all;

%*----Process this section when parameter values specified;

%if &syspbuff ne %then %do;

%let i=1;

%let month=%scan(&syspbuff,&i);

%do %while(&month ne);

proc sgplot data=books.ytdsales

(where=(month(datesold)=&month));

title “Section Sales Report for Month &month”;

hbar section / response=saleprice stat=sum

datalabel;

yaxis label=' ';

run;

%let i=%eval(&i+1);

%let month=%scan(&syspbuff,&i);

%end;

%*----Process this section when no parameter values

specified;

%else %do;

proc sgplot data=books.ytdsales;

title “Annual Section Sales by Quarter”;

hbar section / response=saleprice stat=sum

group=datesold;

yaxis label=' ';

label datesold='Quarter';

format datesold qtr.;

run;

%end;

%mend pbuffparms;

*----Analyze sales for August and November;

%pbuffparms(8,11) It only comes out one graph titled "Section Sales Report for Month &month", obviously &syspbuff wasn't resolved. Could anyone help me out with this problem? Thank you so much.

Can't open SAS9.2 html output

chouchou — Tue, 11 Nov 2014 02:10:44 GMT

Hi guys,

I tried ODS html; and Tools-Options-Preferences-Results-Circle Create HIML;

Both of them do not work and I still can't open html output.

Can you give me some ideas?

Thank you!

Re: Proc report

chouchou — Tue, 21 Oct 2014 19:05:26 GMT

Yes, you're right. But is there a way to group age within the proc report statement?

Re: Proc report

chouchou — Tue, 21 Oct 2014 18:40:35 GMT

Hi data_null,

Thank you for your answer, however when I was dealing with this problem, the dataset had already existed, so I was wondering if there is one way to just use proc report, and within the proc report statement to group age values, and achieved the desired result, without using other statements?

Proc report

chouchou — Mon, 20 Oct 2014 21:40:26 GMT

Hi guys, I want to create a table like this by using PROC REPORT:

-Gender- -Gender-

Age Female Male Female Male

Group SBP SBP DBP DBP

<=50 XX XX XX XX

>50 XX XX XX XX

The data set I have looks like this:

Gender Age SBP DBP

M 23 144 90

F 68 110 62

M 55 130 80

F 28 120 70

M 35 142 82

M 45 150 96

F 48 138 88

F 78 132 76

My problem is:

I can create a new variable 'Age Group' with values '<=50' and '>50',

but I couldn't group the created 'Age Group' variable.

Can anyone give me some insights? Thank you.

do while

chouchou — Wed, 15 Oct 2014 19:32:30 GMT

Hi guys, I thought Square is the same thing as n**2 because they are just the opposite side of an equation.

but I really cannot figure our why it shows different result when I run the following two codes;

data square;

do n = 1 to 1000 while (n**2 le 100);

Square = n**2;

output;
end;

put n= ; The result is N=11

run;

data square;

do n = 1 to 1000 while (Square le 100);

Square = n**2;

output;
end;

put n= ; The result is N=12 :smileyshocked:

run;

n Square

1 1

2 4

... ...

10 100

11 121

12 144

Re: Using DATA STEP to convert several obs per subject to one obs with several subjects

chouchou — Sat, 11 Oct 2014 01:10:20 GMT

It's pretty weird. I just copied your code and it resolved to one obs.

:smileyconfused:

Re: Using DATA STEP to convert several obs per subject to one obs with several subjects

chouchou — Sat, 11 Oct 2014 01:03:26 GMT

Hi loko, can you please explain me why it has both 4 and 5 for Subj001, while it only has 6 for Subj002? I would greatly appreciate your help.

Subj Score S1 S2 S3 S4 S5 i

001 4 4 5 5 5 5 1

001 4 4 4 5 5 5 2

001 4 4 4 4 5 5 3

001 4 4 4 4 4 5 4

001 4 4 4 4 4 4 5

002 6 6 6 6 6 6 1

002 6 6 6 6 6 6 2

002 6 6 6 6 6 6 3

002 6 6 6 6 6 6 4

002 6 6 6 6 6 6 5

Re: Using DATA STEP to convert several obs per subject to one obs with several subjects

chouchou — Sat, 11 Oct 2014 00:32:07 GMT

The result is

Subj Score S1 S2 S3 S4 S5

001 4 7 6 5 5 4

just one obs, not two

Re: Using proc transpose to convert data

chouchou — Sat, 11 Oct 2014 00:11:31 GMT

Thank you Jagadishkatam .

However I know how to use array to do it, I'm just looking for a way to solve by proc transpose, is it possible?

Re: Using proc transpose to convert data

chouchou — Sat, 11 Oct 2014 00:10:58 GMT

Thank you PG.

However I know how to use array to do it, I'm just looking for a way to solve by proc transpose, is it possible?

Using proc transpose to convert data

chouchou — Thu, 09 Oct 2014 23:40:13 GMT

Hi guys, do you have any idea on how to use proc transpose to convert data have---> data want?

data have:

Obs Subj X1 X2 X3 X4 X5 Y1 Y2 Y3 Y4 Y5

1 001 8 5 6 5 4 10 20 30 40 50

2 002 7 5 6 4 5 11 33 29 34 56

3 003 2 2 4 5 6 22 38 21 20 34

data want:

Obs Subj Time X Y

1 001 1 8 10

2 001 2 5 20

3 001 3 6 30

4 001 4 5 40

5 001 5 4 50

6 002 1 7 11

7 002 2 5 33

8 002 3 6 29

9 002 4 4 34

10 002 5 5 56

I wrote the following codes:

proc transpose data=learn.wide out=long;

by Subj;

var X1-X5 Y1-Y5;

run;

The problem is that X variables and Y variables are under the same column, looks like below:

Subj _name_ Col1

001 X1 8

001 X2 5

001 X3 6

001 X4 5

001 X5 4

001 Y1 10

001 Y2 20

.....

Using DATA STEP to convert several obs per subject to one obs with several subjects

chouchou — Thu, 09 Oct 2014 23:26:52 GMT

Hi guys, I just don't use proc transpose but using data steps, how to convert the data have -->data want?

Data have:

Obs Subj Score

1 001 7

2 001 6

3 001 5

4 001 5

5 001 4

6 002 8

7 002 7

8 002 6

9 002 6

10 002 6

Data want:

Obs Subj S1 S2 S3 S4 S5

1 001 7 6 5 5 4

2 002 8 7 6 6 6

3 003 8 7 6 6 5

I wrote the following codes:

proc sort data=one;

by Subj;

run;

data want;

set have;

by Subj;

array S{5};

do i=1 to 5;

retain S1-S5;

if first.Subj then call missing(of S1-S5);

S{i}=Score;

if last.Subj then output;

end;

run;

It comes out 3*5=15 observations, I guess the problem is raised by do loop, but how can I justify it?

Thank you so much.

Chouchou

Re: User defined informats

chouchou — Thu, 09 Oct 2014 15:52:54 GMT

Thank you Patrick, I'm fully clear.

Re: User defined informats

chouchou — Tue, 07 Oct 2014 20:41:22 GMT

Hi Arthur,

Thank you for your time and it's really a great and different way of thinking.

But I'm still struggle with the proc format; invalue..... statement (not proc format;value.....), why I set a boundary of 100 and it doesn't work. It's just too weird!!!

Re: User defined informats

chouchou — Tue, 07 Oct 2014 20:29:29 GMT

Hi Amit, you're correct, but the problem is that I need to keep the boundary 85-<100 and leave the numbers larger than 100 as "other". Do you have any idea?

User defined informats

chouchou — Mon, 06 Oct 2014 21:38:36 GMT

Hi guys, I want to create an informat.

However log keeps notifying me that ERROR: Start is greater than end: -. unless I switch the number of 100 to a word of high.Could anyone explain to me the reason of the error?

What if I want to informat numbers which are larger than 100 as "Not defined yet", how should I adjust my code and avoid the error?

Thank you soooo much!

proc format;

invalue $convert

0 - <65 = 'F'

65 -<75 = 'C'

75 - <85 = 'B'

85 - <100 = 'A'

other = 'Not defined yet ';

run;

automatic macro

chouchou — Sat, 20 Sep 2014 01:57:43 GMT

%macro stats(dsn,class,vars);

title 'Listing produced on &sysday, &sysdate at &systime';

title2 "Statistics from data set &dsn";

proc means data=&dsn n mean min max maxdec=1;

class &class;

var &vars;

run;

%mend stats;

%STATS(learn.bicycles, Country, Units TotalSales) Hi guys, I'm just wondering why the first title couldn't be resolved and show the current day,date and time?

THANK YOU!

Re: List all obs in a data set where more than 2 words is in a variable?

chouchou — Wed, 17 Sep 2014 14:36:06 GMT

Thank you for letting me know prxmatch(). It do search certain Patterns, but it seems can not search two substrings according to my learning just acquired from SAS(R) 9.3 Functions and CALL Routines: Reference

Re: List all obs in a data set where more than 2 words is in a variable?

chouchou — Wed, 17 Sep 2014 14:12:43 GMT

Sorry, I didn't make my question clear.

I'm not looking for a substring with 2 words, but 2 or more substrings with 1 or more words.

For example, I want to search obs which contain the word of Patient and antibiotics in the variable Comment and obs which contain the word of patient and high stress in the variable Comment. Which function should I use?

Thank you so much!

comment

Patient has had a persistent cough for 3 weeks

Patient placed on beta-blockers on 7/1/2006

Patient has been on antibiotics for 10 days

Patient advised to lose some weight

This patient is always under high stress

Refer this patient to mental health for evaluation