About yaswanthj

yaswanthj · ‎09-25-2013

Hi .. Go though the below link, this question is already posted by PGstats... https://communities.sas.com/thread/37050?start=0&tstart=0 Please go though,you will get good idea about why we should be write the quit, in the end of proc sql; Thanks, Yash

yaswanthj · ‎09-25-2013

Hi . Macro parameters are always local to the macro that defines them. So that you already define the macro variable inside the macro..which means local And you are passing the local macro parameter..So that you have a result of local macro variable value .. Thanks, Yash

yaswanthj · ‎09-20-2013

Hi What was the alue for "OUT_REC" variable? Yash

yaswanthj · ‎09-20-2013

Hi.. There is a semicolon(;) in between the datafile and out. so that you can not generate the file to dataset. please remove semicolon(;) and run. you will get the results with out any error.. proc import datafile="E:\Sridhar\Analytics\SAS Course Material\case study\computer_peripherels\comp.csv" Out=lib1.comp dbms=csv; run; Thanks, Yaswanth J.

yaswanthj · ‎09-20-2013

Hi Srider, You can import the CSV file using infile statement. this should be easy way to import the file..to sas.. data want; infile "E:\Sridhar\Analytics\SAS Course Material\case study\computer_peripherels\comp.csv"; /*input var */ run; Thanks, Yashu

yaswanthj · ‎09-20-2013

Hi All.. I have a word doc file(.doc) in my PC. i want to get that file into sas. this should be automated using macro.. i have below problem to get the file .DOC file to generate the datset in sas automatically. but im getting an issue while generating the .doc file to sas dataset.. in the below program everything is good, but while generating the dataset from .xls it is giving an error like ; ERROR: Connect: External table is not in the expected format. ERROR: Error in the LIBNAME statement. Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 2.29 seconds cpu time 1.04 seconds Im using SAS V9.1 and windows environment.. my code.. %macro word2sas(in=, out=temp); options noxwait noxsync; %let rc=%sysfunc(system(start winword)); data test; x=sleep(3); run; filename word DDE 'winword|System'; data _null_; file word; put '[FileOpen.Name = "' "C:\Documents and Settings\yaswanth.j\Desktop\test\example2.doc" '"]'; put "[EditSelectAll]"; put "[EditCopy]"; put '[FileClose]'; put '[AppMinimize]'; run; %let rc=%sysfunc(system(start excel)); data test; x=sleep(3); run; filename excel dde 'excel|system'; data _null_; file excel; put '[error(false)]'; put '[paste]'; put '[SAVE.AS("C:\Documents and Settings\yaswanth.j\Desktop\test\Example2.xls")]'; put '[Select.Last.Cell()]'; put '[Copy]'; put '[quit]'; run; proc import out=temp datafile= "C:\Documents and Settings\yaswanth.j\Desktop\test\Example2.xls" DBMS=excel replace; getnames=yes; mixed=yes; run; filename fd "C:\Documents and Settings\yaswanth.j\Desktop\test\Example2.xls"; %let rc=%sysfunc(fdelete(fd)); filename _all_ clear; %mend word2sas; %word2sas(in = C:\Documents and Settings\yaswanth.j\Desktop\test\example2.doc, out=temp); Please help me where can i change the code.. Thanks, Yash..

yaswanthj · ‎09-19-2013

Hi, Can you please provide some data as example.. yash

yaswanthj · ‎09-19-2013

Hi.. You can convert the .xlsx file to .csv and using infile statement, you can easily get into sas environment without using proc import procedure. data test; infile '"path/file.csv"; run;

yaswanthj · ‎09-19-2013

Hi.. Im not sure the result, in which scenario do you really want.. here is the simple code using many to many merge.. data have; input x y ; cards; 1 5 2 . 3 7 4 6 5 . 6 . 7 3 ; run; proc print data = have; run; data want; merge have(keep = x) have(keep = y where = (y is not missing)); run; proc print; run; Thanks, Yash

yaswanthj · ‎09-19-2013

Hi.. Convert .xlsx (2007) file to .xls (2003), in your computer and use your code. you can easily import the files.. Thanks, Yaswanth

yaswanthj · ‎09-17-2013

Hi.. Please go through this doc http://www2.sas.com/proceedings/sugi29/253-29.pdf. you will idea about input statement and input statement options... Thanks,

yaswanthj · ‎09-17-2013

Hi Hillind, If you don`t want complex coding. and write that in simple. you should have to create new variable and apply format to that new variable and sort it. later in the final dataset just drop the new variable like below code.. data test; input name $ value $; cards; ccc C ddd D aaa A bbb B ; run; proc print; run; proc format; value $inv 'A' = 1 'B' = 2 'C' = 3 'D' = 4 ; run; data test; set test; format new $inv.; new = value; run; proc sort data = test; by name; run; proc print; run; proc sql; create table want as select * from test(drop = new); select * from want; quit; this code may help for your requirement.. Thanks,

yaswanthj · ‎09-17-2013

Hi.. Use format Z. is the best way to keep leading Zeros.. data test; input ID first $ last $; format id Z6.; cards; 056746 Sr M ; run; proc print; run;

yaswanthj · ‎09-11-2013

Thanks TOM for giving clear idea...

yaswanthj · ‎09-11-2013

WE can use the %Scan many ways in macro like suggested above..as per rules. method 1: %let qtnames = %str(var1, var2, var3); %put %scan(&qtnames, 2, ","); method 2: %let qtnames = "var1, var2, var3"; %put %scan(&qtnames, 2, ","); method 3: %let qtnames = var1, var2, var3; %put %scan("&qtnames", 2, ","); etc... As suggested by : SAS(R) 9.2 Macro Language: Reference : you can get clear idea by reading this.. Thanks , Yaswanth

Online Status	Offline
Date Last Visited	‎11-28-2017 12:50 AM

Re: Subtracting two SAS data sets

Re: how to create multiple dataset from one dataset?

Re: Need help on comparing end dates with start date in second line

Re: Need help on comparing end dates with start date in second line

Need help on comparing end dates with start date in second line

Re: how to extract perticular word.

Re: Subset data based on Numeric & Character Variables

Re: row sorting

Re: Count different columns

Re: global macro

Re: How to find the correct PAN #(ex: ABCDF1234J)in a given data.

Re: How to select last n rows of input records using SQL?

How To import .xlsx file in to sas using infile statment

Re: how to extract perticular word.

Re: proc sql count problem

Re: How to scan comma delimited macro variable list?

Re: how to create multiple dataset from one dataset?

Re: lack of quit statement in proc sql

Re: global macro

Re: Concatenation of 2 fields (need to retain Leading Zeros)

Re: Proc Import not successful

Re: Proc Import not successful

Error when i import doc file into sas..

Re: Convert values to missing

Re: PROC IMPORT - Problems with xls and xlsx

Re: Getting next non missing value for the same variable

Re: PROC IMPORT - Problems with xls and xlsx

Re: What's @@ actually doing?

Re: Easy way to reverse a proc Format?

Re: leading zero issue

Re: macro in a loop

Re: How to scan comma delimited macro variable list?