About Swati24

Swati24 · ‎07-14-2019

As it is throwing data error Saying NOTE: LOST CARD. 84 OPTIONS NONOTES 15 A=IND _ERROR_=1 _INFILE_= _N_=1 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.ONE has 3 observations and 1 variables.

Swati24 · ‎07-14-2019

run should be there or not

Swati24 · ‎07-14-2019

After cards; nothing will be written

Swati24 · ‎07-14-2019

Sry it is not &terr it is &X %let X = "AU","US","IND"; Data one; infile &X dlm = ","; input A $ @@; run;

Swati24 · ‎07-13-2019

I have a macro variable with few values i want to use this variable to create a data set having these values with the help of infile statement. I have tried but I'm getting some error. Please help me out in this and thank you in advance. %let X = "AU","US","IND"; Data one; infile &terr dlm = ","; input A $ @@; run;

Swati24 · ‎06-06-2019

Ok Thanks for the solution

Swati24 · ‎06-06-2019

Yes I'm using SAS Studio university Edition

Swati24 · ‎06-06-2019

I'm using SAS Studio noy SAS 9.4 or 9.3

Swati24 · ‎06-06-2019

Thanks I tried but it is giving me error that xls engine not found

Swati24 · ‎06-06-2019

Thanks but the file which I have to import to my SAS Studio is passenger.xls. Proc Import is working fine but when I'm trying to use Libname statement it is giving error.

Swati24 · ‎06-06-2019

Hi, I'm trying to get an excel file in my SAS with the help of libname but it is giving error to me. I'm writing a sample code for reference. libname A '/folders/myshortcuts/SAS program/Passenger.xls'; I'm using SAS studio. Please help me out in this

Swati24 · ‎12-13-2018

data one; infile datalines; input Group :$10. Count; datalines; R&D 2 Testing 3 Sales 8 ; run; I have a data set like above and I need the output like this Group Count Group Total 13

Swati24 · ‎12-13-2018

I have the following data set like this : Group_Name Head_Name LastYear_Count BeforeLastYear_Count R&D IT 1 2 R&D Testing 0 5 R&D Production 4 0 R&D Development 1 0 Sales Book 5 4 Sales Product 10 0 Sales Kit 1 1 Admin Marketing 4 1 Admin HR 5 2 Admin Project 6 3 and I want to get the output like the following attachment using proc report.:

Swati24 · ‎12-10-2018

Thanks I got the solution by using below Proc Report code: proc report data=one; column group_name head_name Before_Last_Year Last_Year; define group_name / group; define head_name / group; define Before_Last_Year / sum; define Last_Year / sum; break after group_name / summarize style={background=lightyellow}; rbreak after / summarize style=Header; compute after group_name; group_name = 'Sub Total'; endcomp; run;

Swati24 · ‎12-10-2018

Thanks but this will not work as after each group value one more row should be added that is subtotal.

Online Status	Offline
Date Last Visited	‎08-23-2019 05:56 AM

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

How to resolve Macro variable in infile statement.

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: Sub-Group Total

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

Re: How to resolve Macro variable in infile statement.

How to resolve Macro variable in infile statement.

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

Re: importing Excel file through libname

importing Excel file through libname

How to get single obs from one?

How to give one label for a group of variables .

Re: Sub-Group Total

Re: Sub-Group Total