topic Re: RE: COMMAND HELP in SAS Procedures

Re:

spraynardz90 — Tue, 05 Jun 2012 04:43:45 GMT

Thanks!

Re: RE: COMMAND HELP

Ksharp — Tue, 05 Jun 2012 06:24:24 GMT

Can you attach a txt file to hold these data.

Your data's layout is too bad .I Can't copy and paste it into SAS rightly.

Ksharp

Re: RE: COMMAND HELP

spraynardz90 — Tue, 05 Jun 2012 11:30:33 GMT

Re: RE: COMMAND HELP

Haikuo — Tue, 05 Jun 2012 12:58:09 GMT

Proc sql seems to knock down three birds by using one stone:

proc import datafile="h:\book1.csv"

out=have

dbms=csv

replace;

getnames=yes;

run;

proc sql;

create table want as

select *, count(distcd) as c_distcd, substr(put(date, ddmmyy10.),4,7) as monyear,

case when distcd in (1262, 1272) then 1

else 0

end as flag

from have

group by calculated monyear, distcd

order by date, calculated monyear, distcd;

quit;

Haikuo

Re: RE: COMMAND HELP

spraynardz90 — Mon, 11 Jun 2012 01:34:01 GMT

This is the message I receive when following the above instructions. Is there a way to change your data types on SAS? I'm guessing I need the program to read these numbers as numerical figures

Re: RE: COMMAND HELP

Ksharp — Mon, 11 Jun 2012 02:12:02 GMT

Hi. I tested HaiKuo's code with your sample data,not found a problem. Maybe your variable at IN is a character not a numeric. But there is little choice to change the type of variables in PROC IMPORT. you can

try to use the following.

proc import datafile="h:\book1.csv"

out=have

dbms=csv

replace;

getnames=yes; guessingrows=32767;

run;

Sure, there is no guarantee to make it numeric.

So if you can, After IMPORT it , you can change it on your own.

new_distcd=input(distcd,best32.);

Ksharp

Re: RE: COMMAND HELP

spraynardz90 — Mon, 11 Jun 2012 08:40:23 GMT

Thanks Ksharp

Re: RE: COMMAND HELP

Ksharp — Mon, 11 Jun 2012 08:54:34 GMT

Hi.

HaiKuo's code is good enough.

From your Log, Maybe distribution code is being translated into Character variable. Try it for Character varaibel.

case when distcd in ("1262","1272") then 1

Ksharp

Re: RE: COMMAND HELP

spraynardz90 — Tue, 12 Jun 2012 03:17:53 GMT

almost there though I need a numeric statment for the monthyear conversion?

Re: RE: COMMAND HELP

Ksharp — Wed, 13 Jun 2012 02:35:15 GMT

The ERROR information tell you that put(date, ddmmyy10.) DATE is a character varaible ,therefore you don't need put() anymore ,you can use substr() directly if DATE looks like date format .