topic Re: Redundant data macro by using raw excel in SAS Programming

Redundant data macro by using raw excel

pdhokriya — Mon, 25 Jan 2021 16:07:15 GMT

ygcd(RAW)	ygtx(RAW)	val(Target)	pcd(target)	yg(raw)
DEL70	NEW	11(num datatype)	DEL70N	11
DEL70	OLD	22	DEL70T	22
DEL70	PROPER	33	DEL70D	33

Hi I am using EG 7.2 also MS office competible.

Without excel raw also I am ok .

Hi ,

Can we make macro by using excel raw data???? ( ygcd,ygtx,val, pcd )

When new is present then at the end of pcd = _____N;

when old is present then at the end of pcd=_____T;

When Proper is present then at the end of pcd = ____D;

data T2;
set T1;
if ygcd="DEL70" and ygtx="NEW" then do ;
val = input (yg, best.);
pcd = "DEL70N";
end;
if ygcd="DEL70" and ygtx="OLD" then do ;
val = input (yg, best.);
pcd = "DEL70T";
end;
if ygcd="DEL70" and ygtx="PROPER" then do ;
val = input (yg, best.);
pcd = "DEL70D";
end;
run;

Regards

Priyanka

Re: Redundant data macro by using raw excel

LinusH — Mon, 25 Jan 2021 15:53:05 GMT

Seem that there are sverel questions here.

Can you use Excel raw data: if you mean a regular spreadsheet - yes. But depends on what license you have etc.

How do you mean a macro would work in your scenario?

If you can show what input data you have (Excel raw and potentially other) and the desired output (in table format and potentially report if that is your goal).

Re: Redundant data macro by using raw excel

pdhokriya — Mon, 25 Jan 2021 16:07:40 GMT

ygcd(RAW) ygtx(RAW) val(Target) pcd(target) yg(raw)
DEL70 NEW 11(num datatype) DEL70N 11
DEL70 OLD 22 DEL70T 22
DEL70 PROPER 33 DEL70D 33

Hi I am using EG 7.2 also MS office competible.

Without excel raw also I am ok .

Re: Redundant data macro by using raw excel

Reeza — Mon, 25 Jan 2021 17:18:34 GMT

What do you mean by a macro? A SAS or Excel macro? What would that macro do and why do you think you need a macro? Please clarify in detail by showing what you have in Excel, what you have in SAS and what you want as an output.

I'm assuming by your references to Excel that you're using the SAS Add In for Microsoft Excel? Is that correct?

I'm assuming when you say you're familiar with "Excel Raw" that you're comfortable working in Excel, but not in SAS or with the Add on. Is that correct?

Re: Redundant data macro by using raw excel

pdhokriya — Mon, 25 Jan 2021 17:28:27 GMT

I am only talking about SAS macro