About RahulG

RahulG · ‎08-10-2016

I am not sure of my answer. Try it yourself. Apply the below option, see if it works. option LOCALE=th_TH;

RahulG · ‎08-10-2016

proc sql; create table DESIRED_TABLE as select t1.* ,t2.CityCode as Seller_CityCode ,t2.Language as Seller_Language from PRIMARY_DATASET t1 left jon Lookup_Table t2 on t1.Seller = t2.City; quit;

RahulG · ‎08-10-2016

Proc sql left join should solve your problem. Lookup table should be left joined to primary dataset. Am I missing something in your question?

RahulG · ‎08-10-2016

This is specific to step 3, sending email. filename outbox email "xyz<XXX.XXX@XXX.com>"; data _null_; file outbox subject='test mail message'; put "hello"; put "this is a message from the data step"; run; Try this out. Example of first line can be filename outbox email "jashu14<jashu14@hotmail.com>"; You can also supply From, who is sending the email. filename outbox email "xyz<XXX.XXX@XXX.com>"; data _null_; file outbox from = "abcd<abcd.xxx@xxx.com>" subject='test mail message'; put "hello"; put "this is a message from the data step"; run;

RahulG · ‎08-10-2016

DATA REPLY; INPUT DEPT $ QUEST1 $ QUEST2 $; DATALINES; A P N B P N C N P A P N B N N C P P ; PROC SQL; CREATE TABLE TEMP AS SELECT DEPT, ROUND(SUM(CASE WHEN QUEST1 ='P' THEN 1 ELSE 0 END ) / COUNT(*),.01) AS QUEST_1, ROUND(SUM(CASE WHEN QUEST2 ='P' THEN 1 ELSE 0 END)/ COUNT(*),.01) AS QUEST_2 FROM REPLY GROUP BY DEPT; QUIT; PROC TRANSPOSE DATA=TEMP OUT=TRANS ; ID DEPT; RUN; I have used P as Postivie and N as Negative.

RahulG · ‎08-08-2016

Good catch ...same question asked twice by different person

RahulG · ‎08-06-2016

You are using Invalue keyword that will create informat. What I understand with your question that you want to convert 1 to Jan which can be done using format. Be sure what do you want Format or Informat. Another point is you are considering 1 as character in your code. Ensure that your input varaible where you are applying format is charcter type Proc Format; Value $ purchase_monthFmt '1' = 'JAN' '2' = 'FEB' '3' = 'MAR'; Run;

RahulG · ‎08-06-2016

You can try using format monname3. data _null_; format a monname3.; a=today(); put a=; run;

RahulG · ‎08-05-2016

As I use MS SQL server managent, my query looks like SELECT TOP 100 [TABLE_SCHEMA] ,[TABLE_NAME] FROM [MYDATABASE].[INFORMATION_SCHEMA].[TABLES] You can use same query in pass through proc sql; connect to access (path="&DBNAMES"); create table output.&title as select * from connection to access ( SELECT TOP 100 [TABLE_SCHEMA] ,[TABLE_NAME] FROM [MYDATABASE].[INFORMATION_SCHEMA].[TABLES] ); disconnect from access; quit; Similarly, you write the query MS Access editor, test it and then use the same query in pass through. It should work for you.

RahulG · ‎08-04-2016

data emp_sal; input Empid $ year salary; datalines; Emp1 1996 2596 Emp1 1997 2600 Emp2 1997 8596 Emp2 1998 8700 Emp3 1997 6200 Emp3 1998 6500 Emp3 1999 6800 ; proc transpose data=emp_sal out=transpose_emp_sal; by Empid; ID year; run; I have given the most simple proc transpose without using much option. Read about proc transpose and exlore. Regarding posting question, Any way that can be understood, it is nice that you have shown what is your input dataset and what do you wnat as output.

RahulG · ‎08-04-2016

I do not know, if it solves your problem but I use proc sql feedback option to list all columns used in proc sql. Ex proc sql feedback; select a.* from table1; quit; Now check the log and get list of all column and replace it with *

RahulG · ‎08-04-2016

@LinusH yes you are correct. I tried, SAS literal wont work here. @jerry4 Write a query in MS Access that help to select rows from the table. Put the same query in pass through. I tried on MS SQL, it worked for me.

RahulG · ‎08-03-2016

Excel consider 1Jan1900 as 0 SAS consider 1Jan1960 as 0 So while converting date to number make use of following formula SAS_date_time = (Excel_date_time - 21916)

RahulG · ‎08-03-2016

proc sql; connect to access (path="&DBNAMES"); create table output.&title as select * from connection to access ( select * from '02 - agent and emergency contact'n ); disconnect from access; quit; Try this out put your table name with ' 'n using SAS name literal A SAS name literal is a name token that is expressed as a string within quotation marks, followed by the upper- or lowercase letter n Refer to last section of this page - SAS Name Literals http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000998953.htm

RahulG · ‎08-03-2016

Please elaborate and share what do you want in output dataset.

Online Status	Offline
Date Last Visited	‎03-22-2019 01:32 PM

Re: SASVA -Text box - how to replace (missing) with 0

SASVA -Text box - how to replace (missing) with 0

Create multiple dataset from source dataset

Re: DI Studio - using programming or scripts to check in / out

Re: Excluding a foreign key in SAS DIS

Re: Duplicate Rows After Left Join

Re: Newbie here! Question about a proposal using SAS! :)

Re: SAS macro query

Re: Cant find newly created dataset

Re: "Library name is not assigned" PLEASE HELP

Re: Regarding Best use of Virtual Lab time

Re: PROC SQL how to add 2 columns from 2 different tables

Re: Create multiple dataset from source dataset

Re: Create multiple dataset from source dataset

Re: Newbie here! Question about a proposal using SAS! :)

Re: What are the ranks for communities.sas.com and how many posts do y...

Re: PROC SQL - DROP statement in a join - Discrimination between t1 an...

Re: Word wrap in SAS Enterprise Guide Program Editor

Re: Newbie here! Question about a proposal using SAS! :)

Re: Splitting dataset dynamically using macro

Re: Reading Thailand Characters from Teradata

Re: How do I use a lookup table conditionally?

Re: How do I use a lookup table conditionally?

Re: turn on email notification

Re: Summing vertically and transposing results

Re: Extracting strings from text

Re: Convert month number to name

Re: Convert month number to name

Re: SQL Pass-Through to Access - Table Names with Consecutive Spaces

Re: Create a Column Heading from Each Distinct Value & then Transpose ...

Re: How to format dates in PROC SQL outside the SELECT statement ?

Re: SQL Pass-Through to Access - Table Names with Consecutive Spaces

Re: convert excel dates to numbers

Re: SQL Pass-Through to Access - Table Names with Consecutive Spaces

Re: find the unique value in each pair

SAS Community Nordic